Re: [PHP-DB] MySQL max records
thanks a lot, that's just about what i needed to hear On Sat, 16 Oct 2004 11:00:25 -0400, Bastien Koert [EMAIL PROTECTED] wrote: Have a look at some of the case studies at mysql.comthere are servers handling 50Million records with not problemsat a certain point it becomes more a hardware issue than a db server issue... bastien From: -{ Rene Brehmer }- [EMAIL PROTECTED] To: [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. 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 -- Jasper Howard - Database Administration ApexEleven.com 530 559 0107 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL max records
Have a look at some of the case studies at mysql.comthere are servers handling 50Million records with not problemsat a certain point it becomes more a hardware issue than a db server issue... bastien From: -{ Rene Brehmer }- [EMAIL PROTECTED] To: [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. 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
[PHP-DB] MySQL max records
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, -- Jasper Howard - Database Administration ApexEleven.com 530 559 0107 --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL max records
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
Re: [PHP-DB] MySQL max records
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? Check the output from phpinfo()... I'm pretty sure the value is in there. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php