Benefits of MAX_ROWS and AVG_ROW_LENGTH

Fri, 19 Dec 2003 08:59:01 -0800

Hi all,

At table creation time I can use MAX_ROWS and AVG_ROW_LENGTH to

  (a) limit the size of a HEAP table
  (b) overcome MyISAM's default 4GB limit

But are they used in any other ways? Does MySQL use them to improve performance by sizing buffers appropriately or to prevent fragmentation in dynamic tables?

Is there any point in me using MAX_ROWS, MIN_ROWS or AVG_ROW_LENGTH if my tables will be small (20KB to 700KB with slow growth rates)? I'm currently running 3.23.41.

Mark


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to