-- 查看表状态
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_sizefrom 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;