Hi Sujay,
Can you please post details like the my.cnf configs, how is the
load on system like cpu, memory, disk usage etc.
Thanx in advance
--Alex
On Mon, 09 Jan 2006 15:16:39 +0530, 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]
