On 25 Feb 2002, at 10:03, Eric Mayers wrote: > Why is the max_data_length portion of "Show table status ..." for innodb > tables null? Is there a way to get this value? I want to use this and > data_length to display a % of space used statistic.
I think you're misunderstanding what the max_data_length number means. It has nothing to do with an amount of space available. At least for MyISAM tables, it seems to be based entirely on the size of the pointers used in the indexes. Thus in general it's 4 GB (for 4-byte pointers), except for tables that have had MAX_ROWS and AVG_ROW_LENGTH set specifically to use pointers larger or smaller than that, or for tables with fixed-length rows (in which the pointers indicate row numbers rather than byte numbers, so the max table sizes are multiplied by the row length). Filter fodder: sql, query -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
