mysql常用运维_MySQL日常运维常用命令_橘喲的博客

一、查看库的大小

1、查看库大小方法一：select (sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024/1024 from information_schema.tables where table_schema='databasename';select table_schema,(sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024/1024 from information_schema.tables where table_schema not in ('information_schema','performance_schema','mysql') group by table_schema;1、查看库大小方法一：select (sum(DAT