search

Home >Database >Mysql Tutorial >mysql 查询表的行数和空间使用及其它信息_MySQL

mysql 查询表的行数和空间使用及其它信息_MySQL

WBOY
WBOYOriginal
2016-06-01 13:15:461115browse

use information_schema;

select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES;

select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES where table_schema='dbname';

select table_schema,table_name,table_rows,data_length/1024/1024 from TABLES where table_schema='dbname'

记录

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安装配置，修改初试密码。Next article：使用Haproxy对MariaDB做负载均衡_MySQL

Related articles

See more