How to find current size (in memory) of table?

Question

I have an in-memory table specified using engine=MEMORY. What command can I run to find out how much space it is currently taking? What about the maximum size?

Answer 1

SHOW TABLE STATUS LIKE 'tablename'\G

Where tablename is the name of the table you want to check.