Hi MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH values for MyISAM tables, to decide how big the resulting table should. If you don't specify either option, the maximum size for a table is 65,536TB of data (4GB before MySQL 5.0.6).
Ref: http://www.mysql.org/doc/refman/5.0/en/create-table.html Thanks ViSolve DB Team. ----- Original Message ----- From: "Amit Dor-Shifer" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, November 28, 2006 7:54 PM Subject: How to calculate max number of rows in a MyISAM table (default MAX_ROWS) ? > Hi. > I've created the following table, with default value for MAX_ROWS. As > the following shows, it has a max. size of 4G. > I'm wondering: Is the expected max number of rows in this table = > Max_data_length \ Avg_row_length? > If not, what might it be? > How do I calculate it? > > mysql> show table status from foo like 'bar'\G > *************************** 1. row *************************** > Name: bar > Engine: MyISAM > Version: 9 > Row_format: Dynamic > Rows: 15094 > Avg_row_length: 121 > Data_length: 2001000 > Max_data_length: 4294967295 > Index_length: 1496064 > Data_free: 163680 > Auto_increment: 67217 > Create_time: 2006-11-01 15:41:20 > Update_time: 2006-11-28 11:42:13 > Check_time: NULL > Collation: utf8_general_ci > Checksum: NULL > Create_options: > Comment: > > > Thanks, > Amit > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
