I am giving the system configuration which we are using to run MySQL. 2-CPU 4G RAM, SAN filesystem. MySQL version : 4.14 (INNODB) OS : RHEL - 3 Amount of Data : 200G No of Rows : 278 million approximately (Every day 2.5-3 million rows gets added) Transaction rate : 300-400 reads/sec, 110-120 updates/sec, 80 inserts/sec Tables : 1 (only 1)
This mysql is handling comfortably. So I think this info might help you to get a good idea about planning your system resources. I am not very much sure about the maximum rows/data it can support, but I am sure it can easily handle a billion of rows in a single table. Regards sujay -----Original Message----- From: vishwas kharajge [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 3:05 PM To: mysql@lists.mysql.com Subject: Mysql database capacity Hi all I am working with startup company. Have some quries about Mysql 1. What is the maximum database storage capacity of mysql 2. What is the maximum row capacity? 3. How much time it will take to search the record if there are consider more than 1 billion rows in a table 4. How many records can i store in a single table. Please help me. Thanks in advance Vishwas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]