table size

[alaios]

Hi!! How i can find detailed information about a table? I want to know how much disk space the specific table consumes... any idea?

[Tangerine Dream]

Hi, check 13.5.4.16. SHOW TABLE STATUS Syntax (http://dev.mysql.com/doc/mysql/en/show-table-status.html) for 'Data_length' (The length of the data file.) and 'Index_length' (The length of the index file.) columns. Another way to determine data & index size for MyISAM tables is to get the size of table_name.MYD (data) and table_name.MYI (indexes) files located in database directory