Mysql database capacity

Mysql database capacity

am 09.01.2006 10:34:34 von vishwas kharajge

---MOQ1136797474887d17bd270f924dfda7780477f0afc4
Content-Type: text/plain
Content-Transfer-Encoding: 8bit

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
---MOQ1136797474887d17bd270f924dfda7780477f0afc4--

RE: Mysql database capacity

am 09.01.2006 10:38:05 von david.logan

Hi Vishwas

These and many other answers can be found here :
http://dev.mysql.com/doc/refman/5.0/en/what-is.html

There is no practical limitation on the row size apart from the number
of fields x the size of these fields. eg. 1000 fields of varchar(255) or
larger will take up that space. I don't know your table description so
can't say.

I have referenced the version 5.0 manual as I'm not sure of your
version. How long to search a record in 1 billion rows? That is very
much dependent on how you are searching, which index you are using etc.
It could take as little as .01 of a second if you use the primary key to
access the record directly.

For the number of records, it is dependent on the size of the record.
Unfortunately there is very little information in your email to be able
to make a judgement. I would suggest you see the limitations in the url
above and divide your record size into that.

Regards=20



------------------------------------------------------------ ---
********** _/ ********** David Logan=20
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: david.logan@hp.com
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ****** =20
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia=20
i n v e n t =20
------------------------------------------------------------ ---

-----Original Message-----
From: vishwas kharajge [mailto:kharajge@sify.com]=20
Sent: Monday, 9 January 2006 8: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=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

RE: Mysql database capacity

am 09.01.2006 10:46:39 von Sujay Koduri

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:kharajge@sify.com]
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/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Mysql database capacity

am 09.01.2006 11:28:29 von Alex

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 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:kharajge@sify.com]
> 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/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Mysql database capacity

am 09.01.2006 12:38:15 von praj

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 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:kharajge@sify.com]
> 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/mysql?unsub=praj@yahoo-inc.com
>
>


--
Thanks
Praj

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org