Home >Database >Mysql Tutorial >查询mysql所有表的大小_MySQL
查询mysql所有表的大小_MySQL
- WBOYOriginal
- 2016-06-01 13:11:21929browse
先用
use information_schema;
SELECT sum(DATA_LENGTH+INDEX_LENGTH) as size,table_name FROM tables where table_schema='数据库名' group by table_name order by size desc;
哪些表数据量大就一目了然了噢
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql分区管理基本操作_MySQLNext article：mysql.zip免安装版配置_MySQL