I just wanted to say that MySQL absolutely rocks!

We are using Mysql with a very large database and it's working 
beautfully.  Needless to say we will be buying licenses to further 
support mysql.

Here are some rough stats on what we were doing:

Inserts: 13,000,000 per day
Updates: 12,000,000 per day
Queries: 12,000,000 per day

This process has been running for almost a year with no problems.  This 
puts the total number of inserts, updates and queries at about 5 billion 
EACH for the year.  Thats 5 billion inserts and the system is idle about 
50% of the time, so there's plenty of room for growth.

We use Myisam tables to store the raw and summary data, Innodb tables to 
keep track of the batch transactions, Merge tables to query large 
numbers of rows accross many tables, and Heap tables to quickly reduce 
raw data into summary data.

Again, cheers to the mysql development team for a job well done.

--Mark


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

Reply via email to