mysql avg row length_InnoDB数据库上的MAX_ROWS和AVG_ROW_LENGTH - MySQL

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.