Sujay , > Tables : 1 (only 1) ::: Innodb or Myisam ? I see lots of updates happening on that table so , how frequent do you defragment the table .
-- Thanks Praj On Mon, 9 Jan 2006 01:46:39 -0800 Sujay Koduri <[EMAIL PROTECTED]> wrote: > > 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] > > -- Thanks Praj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]