W. D. wrote:
At 10:40 12/18/2002, Jocelyn Fournier wrote:We have a magnitude smallar DB, with aroung 5M rows (0.5GB data).
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?
STATUS:
Threads: 15 Questions: 171147358 Slow queries: 2388 Opens: 22690 Flush tables: 1 Open tables: 119 Queries per second avg: 68.198
The thing is it runs on a commercial P3 server (733Mhz) with 512M RAM. It is 3.23.53a, this is a RedHat 7.3 (or 7.1, I don't remember :-)), with one 60GB 7200 IDE HDD. We are peaking at aroung 300-500 queries/sec (30% of those are inserts or updates). This machine also runs a very busy Apache server, yet the load is under 1.0 most of the time (goes up to 3-4 when we do the batch processing). So MySQL can be very efficient - we have not encountered any data loss whatsoever in the last few months. (But that is MyISAM - we had performance problems with InnoDB).
What you need to have is a _good_ install, and then MySQL is superb. But to have a "good install" is not as easy as it sounds.
- Csongor
---------------------------------------------------------------------
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
