Previous hardware was a Bi PIII-733 with 786 MB of RAM, and 1 SCSI drive, under Linux (kernel 2.4.18). It worked fine, with sometimes some slowdown, mainly because of the hard drive. Now the server is Bi Athlon MP 2200+, 2 GB of RAM, and Maxtor Atlas 10K3 SCSI 320 (RAID-5) (still kernel 2.4.18) The load average is roughly 0.7.
Regards, Jocelyn ----- Original Message ----- From: "W. D." <[EMAIL PROTECTED]> To: "Jocelyn Fournier" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Michael She" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Muruganandam" <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 5:38 PM Subject: Re: Can MySQL handle 120 million records? At 10:40 12/18/2002, Jocelyn Fournier wrote: >Hi, > >I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some >tables contains more than 40 millions of rows) under quite high stress >(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables) >I never experienced any losses, *even with MySQL-4.1* (yes, I'm currently >using 4.1 on this production server ;)). >So for me MySQL is ready for a mission critical environment :) Wow! What kind of hardware? What OS? Start Here to Find It Fast!© -> http://www.US-Webmasters.com/best-start-page/ --------------------------------------------------------------------- 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]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php