How to measure HEAP table size

[marklenel]

Can anyone suggest a method of measuring the size of a HEAP/MEMORY-type table? This would be useful to set an appropriate figure for the max_heap_table_size server variable.

I can create the table on disk rather than in memory and check the file size that way, but is there a more direct method?

 

[TonyGroves]

To find out the data size for a table (including a HEAP table), you can do:
[tt] SHOW TABLE STATUS like 'tblname'[/tt]
The field Data_length contains the size of the table (not including indexes).



-----
ALTER world DROP injustice, ADD peace;