
MySQL Table Size
information_schema
. It has right information for those who want to get DB table real size. Let’s look into the information_schema.tables
table. We will use next fields from it:–
TABLE_SCHEME
(database name),–
TABLE_NAME
(it is self-explaining),–
TABLE_ROWS
(quant of rows in the table),–
DATA_LENGTH
(table data length in bytes),–
INDEX_LENGTH
(table indexes length in bytes)
