mysql - InnoDB 数据库上的 MAX_ROWS 和 AVG_ROW_LENGTH - MySQL

Question

这个选项在 InnoDB MySQL 数据库 MAX_ROWS 和 AVG_ROW_LENGTH 中有效吗？

有效的意思是它会产生任何积极的影响!

Answer 1

看起来该选项仅适用于 MyISAM 表，但我对此并不完全确定。

参见 http://dev.mysql.com/doc/refman/5.1/en/create-table.html

AVG_ROW_LENGTH

An approximation of the average row length for your table. You need to set this only for large tables with variable-size rows.

When you create a MyISAM table, MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH options to decide how big the resulting table is. If you don't specify either option, the maximum size for MyISAM data and index files is 256TB by default. (If your operating system does not support files that large, table sizes are constrained by the file size limit.) If you want to keep down the pointer sizes to make the index smaller and faster and you don't really need big files, you can decrease the default pointer size by setting the myisam_data_pointer_size system variable. (See Section 5.1.4, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by setting this variable. Setting the value to 7 permits table sizes up to 65,536TB.