Have a look at some of the case studies at mysql.com....there are servers handling 50Million records with not problems....at a certain point it becomes more a hardware issue than a db server issue...


From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] MySQL max records
Date: Sat, 16 Oct 2004 02:01:07 +0200

How many records it can hold before becoming too slow for practical use depends entirely of the hardware that makes up the server.

Current versions of MySQL has a finite limit of 2^64 records per table, but how many billion records you can shove into it before you start seeing performance issues depends on the RAM size, the RAM/CPU roundtrip speed, and the pure processing power of the CPUs, as well as the overall load of the server. Obviously dedicated DB servers/clusters will be able to handle alot higher record counts than mixed-purpose servers.


At 01:32 16-10-2004, ApexEleven wrote:
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?


-- Rene Brehmer aka Metalbunny

If your life was a dream, would you wake up from a nightmare, dripping of sweat, hoping it was over? Or would you wake up happy and pleased, ready to take on the day with a smile?

References, tools, and other useful stuff...
Check out the new Metalbunny forums at http://forums.metalbunny.net/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to