MAX_ROWS and AVG_ROW_LENGTH

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)

re: MAX_ROWS and AVG_ROW_LENGTH

> Are there *any other ways* in which MySQL uses MAX_ROWS and[color=blue]
> AVG_ROW_LENGTH? Does it use them to improve performance by
> sizing buffers appropriately, to prevent fragmentation in
> dynamic tables (variable row lengths)?[/color]

It's a damn good question, but I really don't think so. I've looked
through the manual, as well as MySQL Enterprise Solutions, and can't
find anything about optimization.

The variables are used when rebuilding corrupted data, or resizing
during a "table is full" error. But I see nothing regarding
optimization that might help you.

Lukas

re: MAX_ROWS and AVG_ROW_LENGTH

> Are there *any other ways* in which MySQL uses MAX_ROWS and[color=blue]
> AVG_ROW_LENGTH? Does it use them to improve performance by
> sizing buffers appropriately, to prevent fragmentation in
> dynamic tables (variable row lengths)?[/color]

It's a damn good question, but I really don't think so. I've looked
through the manual, as well as MySQL Enterprise Solutions, and can't
find anything about optimization.

The variables are used when rebuilding corrupted data, or resizing
during a "table is full" error. But I see nothing regarding
optimization that might help you.

Lukas