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...
bastien
From: -{ Rene Brehmer }- <metalbunny@xxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: 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.
Rene
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?
thanks,
--
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?
http://metalbunny.net/
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
