select concat(truncate(sum(data_length) / 1024 / 1024, 2), 'MB') as data_size,
concat(truncate(sum(max_data_length) / 1024 / 1024, 2), 'MB') as max_data_size,
concat(truncate(sum(data_free) / 1024 / 1024, 2), 'MB') as data_free,
concat(truncate(sum(index_length) / 1024 / 1024, 2), 'MB') as index_size
from information_schema.tables
where TABLE_NAME = 'tablename';