https://dev.mysql.com/create-table.html
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. MAX_ROWS The maximum number of rows you plan to store in the table. Important The use of MAX_ROWS with NDB ...
https://dev.mysql.com/mysql-cluster-online-add-node-basics.html
Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... You should also bear in mind that using MAX_ROWS to set the number of partitions in this fashion is deprecated, and you should use ...
https://dev.mysql.com/mysql-cluster-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. Keep in mind that using MAX_ROWS to set the number of partitions per table is deprecated, and you should use PARTITION_BALANCE instead; see ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/table-size-limit.html
If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE statement supports AVG_ROW_LENGTH and MAX_ROWS options. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; ...
https://dev.mysql.com/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. The discussion ...
https://dev.mysql.com/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
Note In previous versions of NDB Cluster it was possible to create extra partitions for NDB Cluster tables and thus have more memory available for hash indexes by using the MAX_ROWS option for CREATE TABLE. While still supported for backward ... The ...
https://dev.mysql.com/partitioning-overview.html
In addition, MAX_ROWS and MIN_ROWS can be used to determine the maximum and minimum numbers of rows, respectively, that can be stored in each partition. The MAX_ROWS option can also be useful for creating NDB Cluster tables with extra partitions, ...
https://dev.mysql.com/alter-table.html
ALTER TABLE tbl_name [alter_specification [, alter_specification] ...] [partition_options] alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD ...
https://dev.mysql.com/server-system-variables.html
The value of the variable is used to calculate MEMORY table MAX_ROWS values. myisam_data_pointer_size Property Value Command-Line Format --myisam-data-pointer-size=# System Variable myisam_data_pointer_size Scope Global Dynamic Yes SET_VAR Hint ...
