MAX_ROWS can be used in conjunction with AVG_ROW_LENGTH to
(a) limit the size of a HEAP table
(b) overcome MyISAM's default 4GB limit
Are there *any other ways* in which MySQL uses MAX_ROWS and
AVG_ROW_LENGTH? Does it use them to improve performance by
sizing buffers appropriately, to prevent fragmentation in
dynamic tables (variable row lengths)?
The sizes of my tables will be small (20KB up to 700KB with
slow growth rates). Is there any point in me using MAX_ROWS,
MIN_ROWS or AVG_ROW_LENGTH?
Marco
----------------------------------------------------
Please remove digits from e-mail address (tr/0-9//d)