Hi,
The limit for the table can be set when you create the table itself.
the MAX_ROWS and AVG_ROW_LENGTH variables (m X n matrix) will decide the
table size.
MAX_ROWS limts the maximum number of rows in that table. The AVG_ROW_LENGTH
variable decides the length of the row. The specified value can be used by
a single column itself or depends on the size of the columns.
Thanks
ViSolve DB Team.
----- Original Message -----
From: "kalin mintchev" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, February 05, 2007 9:14 AM
Subject: mysql limits
hi all...
i just wanted to ask here if somebody has experience in pushing the mysql
limits... i might have a job that needs to have a table (or a few tables)
holding about a 100 million records. that's a lot of records.... is there
any limitation of some kind that wouldn;t allow mysql to handle that kind
of amounts or it all depends on memory and cpu... or how are the searches
- speed and otherwise - affected by such numbers?
thanks....
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
