查询表的大小语句

 select table_schema,table_name,engine,row_format as format, table_rows, avg_row_length as avg_row,ROUND((data_length+index_length)/1024/1024,2) as total_mb,ROUND((data_length)/1024/1024,2) as data_mb,ROUND((index_length)/1024/1024,2) as index_mb,CURDATE() as today from information_schema.tables where table_schema not in('mysql','information_schema','performance_schema') order by table_schema,table_name;