Re: actual size of a innodb tablespace

itial size (10M: autoextend) is actually used? I would like to have an idea of the data space progression? Per database (I have 3). Thank you in advance Johanne Duhaime IRCM courrier: [EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

ta that is inserted by B while A is running is not visible to A. If A is re-started all the data that was inserted by B is now available. A is a plotting program and B is a data importer process. Any clue on what may be going wrong? Thank you in advance. Jose. -- Jeff Mathis, Ph.D.

Re: insert

can somebody explain why is this insert/select not working? insert into the_db (place,address,number) values("stuff","stuff2",select this from that where one=two); i tried ()s around the 'select....' too but it didn't work. thanks. -- Jeff Mathis, Ph.

migration of InnoDB 4.1.3 to 4.1.6

I see from the release notes that tables with timestamp column will need to be rebuilt. will the server automatically do this upon startup? thanks, jeff -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez

Re: simple but frustrating query

d and less error prone. this was one example where conceptually we thought it should be able to be done -- and it can, if you use a nested select. thanks again to all for helped. we're on to bigger and better things... jeff Michael Stassen wrote: Jeff Mathis wrote: well, obviously some, if n

Re: simple but frustrating query

ords, this wasn't such a simple query, after all. Michael Jeff Mathis wrote: we really don't want to issue two queries. this should be able to be done in one, and without using temp tables, but maybe not. thanks for the help though jeff [EMAIL PROTECTED] wrote: It takes two steps: first dete

Re: simple but frustrating query

4.1.3 and the innodb engine on solaris 5.8 Brad Eacker wrote: Jeff Mathis writes: now, leaving off name from the group by clause (select max(close_date), symbol, name from TD where symbol in ('aa','bb','cc') group by symbol;) gives +-++-

Re: Delete data from more than one table

. I tried to run this query: delete from account, survey; //But the query crashes. Any ideas how to delete data for more than one query. TH -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6

Re: simple but frustrating query

Database Administrator Unimin Corporation - Spruce Pine Jeff Mathis <[EMAIL PROTECTED]> wrote on 10/14/2004 02:22:32 PM: hello query gurus. we have a table TD with the following columns: close_date symbol name close_date is just a date field there is a unique constraint on the combination

Re: simple but frustrating query

---++-+ | max(close_date) | symbol | name| +-++-+ | 2004-10-05 | aa | cmptrhw | | 2004-10-05 | bb | biotech | | 2004-10-05 | cc | biotech | +-+----+-+ but we can't seem to f

Re: simple but frustrating query

f values for symbol something like this: select max(close_date), symbol, name from TD where symbol in () group by symbol; this returns the max close_date value, but the name that is returned is garbage and seems to point to the earliest row in the table. any suggestions? jeff -- Jeff Mat

simple but frustrating query

h the innodb engine -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: ResultSet NotUpdatabelProblem

BRX9E= =8Mac -END PGP SIGNATURE- -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http:/

Re: increasing mysql/table performance..

do to speed up the response time/tbl interactions for the users thanks -bruce ps. if need to, i could provide sample sql statements/table defs... -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste

Re: Simple DB design question

'Active'. With design 2, there will only ever be 1 record in the Active_Data table. Neither idea seems very good to me. Any suggestions? thanks much sean peters [EMAIL PROTECTED] mysql, query -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [E

Re: problem with 4.1.3

that this was a bug that was then fixed, and I just happened to get nipped by it. jeff Dan Nelson wrote: In the last episode (Aug 05), Jeff Mathis said: after lokking at this, it appears that our float(11,9) columns cannot store an number larger than 100 or smaller than -100. the database is rou

Re: problem with 4.1.3

r the decimal, so only 2 digits are allowed before the decimal. sean peters [EMAIL PROTECTED] On Thursday 05 August 2004 15:47, Jeff Mathis wrote: after lokking at this, it appears that our float(11,9) columns cannot store an number larger than 100 or smaller than -100. the database is roundin

Re: problem with 4.1.3

s jeff Jeff Mathis wrote: after upgrading from 4.0.4 to 4.1.3, we noticed that some of our float(11,9) columns refused to store anything other than the numer -100 or the number 100, even though the insert or update sql clearly specifies other numbers. We've tried dropping the table and reloadin

problem with 4.1.3

same problem. we're using Connector/J to load the data. is this a know issue? jeff -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Ma

Re: time zone leap seconds

export the tables and import the tables into the upgraded environment. You could also export your 4.0.x data and import this data into the newly created 4.1.3 environment. -Original Message----- From: Jeff Mathis To: mysql Sent: 8/4/04 11:14 AM Subject: time zone leap seconds we just upgraded fro

time zone leap seconds

without them thanks jeff -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: InnoDB TableSpace Question

any use in shrinking it). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Ma

Re: Querying serveral databases (Views?)

" fix, since I don't feel it's a neat way to solve it. Thanks in advance Regards Daniel Ek -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe

Re: "hot" innodb backup options

ent a process where the database is backed up without having to shut it down (live, or hot backup). Reading the documentation, it appears the only option I have is to purchase a solution from InnoDB ($500/yr). Is there a free option out there to do this? Thank you, Kevin Williams -- Jeff Mathis,

Re: INSERT returning ID

If you mean, can you have the insert statement itself return the ID, no. Insert statements don't return records. -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict

Re: bigint support in MySql 4

responding data type that I ccould use if I am imoprting tables from MySql 3.2 to MySql 4.0 Thanks, Sharath -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com San

Re: bigint support in MySql 4

yes it does. we use a bigint(20) for example. [EMAIL PROTECTED] wrote: Hi, I would like to know whether MySql 4.0 supports bigint. If not what is the corresponding data type that I ccould use if I am imoprting tables from MySql 3.2 to MySql 4.0 Thanks, Sharath -- Jeff Mathis, Ph.D

Re: Newbie Question

here it is: http://www.mysql.com/news/article-111.html its also all over the mysql reference manual, especially in the InnoDB tables section. Rhino wrote: - Original Message - From: "Jeff Mathis" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>;

Re: Newbie Question

ta. I'd rather stay with something stable than mess with alpha or beta code but if 4.0.15 is not significantly better than 4.0.11, I'd rather stay with 4.0.11 because it works fine and is less work than upgrading to a newer version. Rhino - Original Message - From: "Jeff Math

Re: Newbie Question

I'm not sure why permission is denied; I don't use Linux very often and haven't used it much in several months but I know the 'find' command worked last time I tried it). Anyway, if anyone could tell me how to find my.cnf and verify that InnoDB is set up correctly, I'd

Re: Newbie Question

n't work since MyISAM doesn't support foreign keys, at least as I understand the manual. However, this doesn't answer the big question: *Why* aren't my tables InnoDB since I explicitly defined them that way?? Can any MySQL veterans clear up this mystery for me? Rhino --- rh

Re: Unique IDs

making Mysql wait one second between inserts. We only get about 1000 hits per day, but they tend to be concentrated in short time intervals. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- Jeff Mathis, Ph.D. 505-

Re: Shrinking innodb datafiles?

to do this? Thx BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 http://btyahoo.yahoo.co.uk -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, St

Re: TINYINT(1) vs ENUM?

gt; >Thanks! > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company

Re: Running without logfiles

> > I am using Innodb Tables but I Like to run this database without > creating any logfiles. > > Is there a way that Mysql doesn't create any logfiles at all . I can > recover from a master system so this database can or is allowed to loose > the data -- Jeff Mathis

Re: Need help comparing MySQL to MS SQL Server

> Database Workbench - developer tool for InterBase, Firebird & MS SQL > Server. > Upscene Productions > http://www.upscene.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.c

Re: practical MySQL database size limits

l limits under Solaris 2.8? > > ari > > Ari Davidow > [EMAIL PROTECTED] > http://www.ivritype.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -

Re: innodb and fragmentation

Paul DuBois wrote: > > At 12:40 PM -0600 9/19/03, Jeff Mathis wrote: > >this looks great. will this work with version 4.04 on solaris? > > > >as a side comment, anyone know when 4.1 will get out of the alpha stage? > >very much looking forward to upgrading, but only

Re: innodb and fragmentation

EY constraints. > > > > Please test it! > > It did the job just fine. Thanks. > > -- > Per Andreas Buer > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Je

Re: Storing Java Objects

Kind regards, > Dennis > > > Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! > http://login.mail.lycos.com/r/referral?aid=27005 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lis

Re: innodb and fragmentation

there any plans to implement index clustering or similar technology > to battle this? (Would clustering help?) > > -- > Per Andreas Buer > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Re: Number of Rows from Select Statement

I'm not sure. You could run a test. I'd be surprised if counting rows from the resultset was slower. Charles So wrote: > > which is more efficient? > > 1) find num from rs or > 2) select count(*) from table? > > cheers, > Charles > > On Saturday, Au

Re: innodb on delete cascade

+---+--++-+ > >>1 row in set (0.00 sec) > >> > >>mysql> delete from gene where id=9; > >>Query OK, 1 row affected (0.00 sec) > >> > >>mysql> select * from name; > >>++-

Re: innodb on delete cascade

3 rows in set (0.00 sec) > > When I come to try to delete some data from the parent table i'm getting > errors as in: > > mysql> delete from parent where id=1; > ERROR 1217: Cannot delete a parent row: a foreign key constraint fails > > any thoughts? > > ch

Re: innodb on delete cascade

; >>mysql> delete from gene where id=9; > >>Query OK, 1 row affected (0.00 sec) > >> > >>mysql> select * from name; > >>+++--+---+--++-+ > >>| id | other_name | other

Re: reindexing

ta. MySQL assumes data values > have an equal distribution in a database, updating the indexes will > force MySQL to update it's assumptions and thus do a better job of > optimizing searches. > > On Wednesday, August 6, 2003, at 12:17 PM, Jeff Mathis wrote: > > > I was u

Re: reindexing

ists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 -- MySQL Gene

Re: Update Table By ID Ranges

> UPDATE testTable set testField='' WHERE > test_id in (100:1000); > > Thanks in advance for any comments, > > Mike > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.

Re: Triggers

; > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:

Re: need help

I have no idea. sorry. Sibananda Sahoo wrote: > > Thanks for your reply. Could you please tell me is it > possible to achieve foreign key constraint in MySQL > 3.23.56. > > Rgds, > Sibananda > > --- Jeff Mathis <[EMAIL PROTECTED]> wrote: > > i'm no

Re: need help

ld you pls suggest how can I change and to achieve > foreign key constraints. > > Rgds, > Sibananda > > __ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > http://calendar.yahoo.com -- Jeff Mathis, P

Re: help creating foreign keys

increment, >foo_idint unsigned, >bar_value int, >constraint bar_pk primary key (bar_id), >index (foo_id), >foreign key (foo_id) references foo (foo_id) > ) type=innodb; > > -Original Message- > From: Jeff Mathis [mailto:[EMAIL PROTECT

Re: help creating foreign keys

bar_id), > foreign key(foo_id) references foo(foo_id), > ) type=innodb; > > ERROR 1005: Can't create table './test/bar.frm' (errno: 150) > > -justin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsub

Re: primary key/foreign key constraints with InnoDB

easily extensible as your model, but perhaps that's > OK. In SQL to join the parent and child you must decide which parent to > join based on which FK column has the non-default value. > > You might be able to come up with a DB rule to ensure that exactly one of > the FK v

Re: primary key/foreign key constraints with InnoDB

: you have to create them explicitly. > > The example on that page, however, shows exactly how you'd do that. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) >

primary key/foreign key constraints with InnoDB

; if table_name is 'TabA', then I want to make sure the row exists in TabA. Likewise if table_name is 'TabB' the usual syntax to add a foreign key constraint doesn't seem to allow this. I could certainly perform this check with an insert trigger, but, alas, mysql does not s

Re: -bin files

f your data, just what it took > to get there. You can use mysqlbinlog to translate them to SQL files. > > -jeff > > On Fri, 2003-03-21 at 12:52, Jeff Mathis wrote: > > we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables. > > > > I see

-bin files

age these files? What happens if I delete them> How can I tell if any of them are stale? thanks -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com

matlab interface

hello, does anyone know of a good mysql-matlab release 13 interface? the standard database connection capability within matlab is a really poor implementation based on JDBC. JDBC is fine, but not how the matlab people use it. thanks jeff -- Jeff Mathis, Ph.D. 505-995-1434

Re: Mysql Innodb performance slow

an Nelson wrote: > > In the last episode (Oct 25), Jeff Mathis said: > > I'll agree to this somewhat: > > > > (1) always bind your variables. whatever code you are using to do your > > inserts, the fewer prepared statements you can make the better. > > >

Re: Mysql Innodb performance slow

> - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> >

show version problem

x27;show table status' or 'mysqlshow --status' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Mar

error executing 'show variables' and 'show table status from [table]'

x27;show table status' or 'mysqlshow --status' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Mar