select table_schema,table_name ,(( table_rows * AVG_ROW_LENGTH + INDEX_LENGTH )/1024/1024/1024) as table_size from tables where table_schema not in ('sys','mysql','information_schema','performance_schema') order by table_size desc limit 40;
统计mysql服务 中的表占用磁盘的大小(SQL)
最新推荐文章于 2022-12-05 14:24:51 发布