How to find size of individual columns and indexes in mysql/innodb database?
- by taw
SHOW TABLE STATUS LIKE 'foo' returns Data_length - size of all data, and Index_length - size of all indexes. What's the best way to get per-column and per-index breakdown?