Mysql 备查

1. -- 数据库表占用空间大小
2. select
3. table_schema as '数据库',
4. sum(table_rows) as '记录数',
5. sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)',
6. sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)'
7. from information_schema.tables
8. where table_schema='db_name';
10. -- 清空表(无日志)
11. truncate table tablename;

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！