查看某个表的详细信息(记录数,索引空间,表大小)
show table status from employees like 'salaries';
也可以使用查询information_schema中TABLES中的DATA_LENGHT与INDEX_LENGTH
select concat(round(DATA_LENGTH/1024/1024,2), 'MB'), concat(round(INDEX_LENGTH/1024/1024,2), 'MB') from TABLES where TABLE_NAME='salaries';