原创

mysql数据查看命令

1.mysql数据

# 查看整个实例大小
...
select concat(round(sum((DATA_LENGTH+INDEX_LENGTH)/1024/1024/1024),2),'GB') as data from information_schema.tables  ;
# 查看每个schema的数据大小
select TABLE_SCHEMA, concat(round(sum((DATA_LENGTH+INDEX_LENGTH)/1024/1024/1024),2),'GB') as data from information_schema.tables group by TABLE_SCHEMA ;
正文到此结束
本文目录