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 :)
Regards, Jocelyn ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Michael She" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Muruganandam" <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 4:06 PM Subject: Re: Can MySQL handle 120 million records? > On Wed, Dec 18, 2002 at 02:38:31AM -0500, Michael She wrote: > > Being paranoid... > > > > Have you ever lost data with MySQL before? > > No. > > > Is it "reliable". > > Yes. It doesn't crash and doesn't lose data. If it did either, we'd > never have used it this much. > > > I have no problems using MySQL as a lightweight database for simple > > chores, but I'm a bit weary about putting into a mission critical > > environment. > > Why, exactly? > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 3 days, processed 136,569,878 queries (457/sec. avg) > > --------------------------------------------------------------------- > 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 > > > > --------------------------------------------------------------------- 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
