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
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: vishwas kharajge [mailto:[EMAIL PROTECTED]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
