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

RE: Having success with 20 million rows

2001-05-10 Thread JHDrexler
I would be very intested in finding out more about the hardware being used here, as well as load on the server (queries/sec, etc.), and maybe the amount of data (Megabytes, Gigabytes, Terabytes). Twenty million records is a lot but that number in itself may not give the application the credit

RE: Having success with 20 million rows

2001-05-10 Thread Robin Keech
r; 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 inaccessible during these 4 days? Or is mysql able to >still write to the table while it's being altered? Those are not mutually ex

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 t

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 da

Re: Having success with 20 million rows

2001-05-09 Thread Zak Greant
t; <[EMAIL 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 t

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:

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
TED]] Sent: Wednesday, May 09, 2001 2:49 PM 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 a

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
: [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

Re: Having success with 20 million rows

2001-05-09 Thread Joshua J. Kugler
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 are large, over 20 million rows, selects, updates and inserts occur