Okay, this is clearly not what I want. I'm looking for a method to see how much space a table is using compared to the total amount of space available. Is there a way to do this (with innodb tables)?
Eric Mayers > -----Original Message----- > From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 11:33 AM > To: [EMAIL PROTECTED] > Subject: Re: max_data_length? > > > 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
