mysql常用命令

-- 查看表状态

show table status 

-- 查询所有数据库占用磁盘空间大小的SQL语句：

select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),' MB') as data_size,

concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size

from information_schema.tables

group by TABLE_SCHEMA

order by data_length desc;

GB的：

SELECT 
    TABLE_SCHEMA,
    CONCAT(TRUNCATE(SUM(data_length) / 1024 / 1024/1024,
                2),
            'GB') AS data_size,
    CONCAT(TRUNCATE(SUM(index_length) / 1024 / 1024/1024,
                2),
            'GB') AS index_size
FROM
    information_schema.tables
GROUP BY TABLE_SCHEMA
ORDER BY data_length DESC;

--显示数据库关于超时的时间配置

show global variables like '%timeout%';

set global wait_timeout= 288000000;