Show table size splitted for data and index

20 posts
[expired user #8405]'s profile image [expired user #8405] posted 9 years ago in Feature discussion Permalink
Hello,

in the database overview i see the size of every table. But only the totaly size is shown. Is there a chance to see the real data size and the index size?

Martin
560 posts
jfalch's profile image jfalch posted 9 years ago Permalink
what is the "real data size" as compared to the "total size shown" ?
20 posts
[expired user #8405]'s profile image [expired user #8405] posted 9 years ago Permalink
The "real data size" is the column DATA_LENGTH from the information_schema.TABLES table in mysql. You will find the index size at the column INDEX_LENGTH.

Please login to leave a reply, or register at first.