RE: Having success with 20 million rows

2001-05-10 Thread Robin Keech
. Potter; [EMAIL PROTECTED] Subject: Re: Having success with 20 million rows At 11:00 PM +0200 5/9/01, Christian Jaeger wrote: Was the table inaccessible during these 4 days? Or is mysql able to still write to the table while it's being altered? Those are not mutually exclusive possibilities

RE: Having success with 20 million rows

2001-05-10 Thread JHDrexler
the credit that it desrves. [EMAIL PROTECTED] -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:09 PM To: mysql Cc: david100 Subject: Having success with 20 million rows Just wanted to say that we are having success using MySql. Even though

RE: Having success with 20 million rows

2001-05-10 Thread Nemholt, Jesper Frank
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: jueves, 10 de mayo de 2001 6:00 To: Christian Jaeger; David J. Potter; [EMAIL PROTECTED] Subject: Re: Having success with 20 million rows At 11:00 PM +0200 5/9/01, Christian Jaeger wrote: Was the table

Having success with 20 million rows

2001-05-09 Thread David J. Potter
Just wanted to say that we are having success using MySql. Even though our tables are large, over 20 million rows, selects, updates and inserts occur very fast. We use both Windows and Linux. Adding a column is the only action that is slow (it took 4 days once to add a column), but that is

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
To: [EMAIL PROTECTED] Subject: Re: Having success with 20 million rows FOUR days!?!? THAT'S patience. But I'm glad to hear the success story. j- k On Wednesday 09 May 2001 11:08, David J. Potter wrote: Just wanted to say that we are having success using MySql. Even though our tables

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
: Having success with 20 million rows Well normally its not the best to add columns after the fact if the design met the specs. But this is not always the case. As we all now the specs change about every hour. -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] Sent

Re: Having success with 20 million rows

2001-05-09 Thread Ernesto Vargas
Can you put your my.cnf for windows and linux? Will be nice to compare you setting again others. TIA, Ernesto Vargas - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 3:49 PM Subject: Re: Having success with 20 million

Re: Having success with 20 million rows

2001-05-09 Thread Zak Greant
PROTECTED] To: Robert Henkel [EMAIL PROTECTED]; 'Joshua J. Kugler' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 2:03 PM Subject: RE: Having success with 20 million rows I take that back the word not the best shouldnt be used. I should of said in a perfect world we shouldnt have

Re: Having success with 20 million rows

2001-05-09 Thread Christian Jaeger
Was the table inaccessible during these 4 days? Or is mysql able to still write to the table while it's being altered? Christian. At 12:08 Uhr -0700 9.5.2001, David J. Potter wrote: occur very fast. We use both Windows and Linux. Adding a column is the only action that is slow (it took 4

Re: Having success with 20 million rows

2001-05-09 Thread Paul DuBois
At 11:00 PM +0200 5/9/01, Christian Jaeger wrote: Was the table inaccessible during these 4 days? Or is mysql able to still write to the table while it's being altered? Those are not mutually exclusive possibilities. :-) According to the manual, reads can be done on the original table while