If you look closely, you'll see that the max size is related to the max number of rows. I'm almost sure that you're running into a conflict with the size more than the row count. Also stated in the manual is that v3.23 only supports table sizes of 4GB, but the default max is set to 2GB. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Martin Waite" <martin@datacash.com> To: "MySQL List" <mysql@lists.mysql.com> Sent: Tuesday, 10 June, 2003 07:30 Subject: What is the maximum number of rows per table ? Hi, I can't find any mention of this in the MySQL manual. It discusses the maximum file size, but what I want to know is if there is some limitation (perhaps in the index file format) on the number of rows a MyISAM or INNODB table can hold ? regards, Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=subs@becomingdigital.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
