Re: Can MySQL handle 120 million records?

[Michael Bacarella]

> > > 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.

> 1. MySQL hasn't been "proven" yet in the corporate environment

We run a periodic billing system backed with MySQL, in addition to
the rest of a web site that is hammered with approximately 300 million
hits per month. These all go against a single MySQL instance running on
modest x86 hardware.

> 2. Some of the comments in the mySQL manual... people losing data doing 
> routine stuff like table optimizations, adding keys, etc.  If a database is 
> reliable, things like that shouldn't happen.  Comments like those in the 
> MySQL manual scared me.

We've never lost data. Our database server has crashed hard from OS failures
and suffered plenty of unclean shutdowns. MySQL/InnoDB always recovers
perfectly.

-- 
Michael Bacarella  | Netgraft Corp
                   | 545 Eighth Ave #401
 Systems Analysis  | New York, NY 10018
Technical Support  | 212 946-1038 | 917 670-6982
 Managed Services  | http://netgraft.com/