mysql 数据库，表存储大小-白红宇

mysql 数据库，表存储大小

阅读量：5047 次

发布时间：2019-06-12

本文共 980 字，大约阅读时间需要 3 分钟。

use information_schema;

-- 查询一个数据库存储大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane'; 85MB

-- 查询一个表存储大小

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane' and table_name='saleorder'; 0.23MB/505

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane' and table_name='productset'; 0.08MB/134

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane' and table_name='product'; 0.19MB/487

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane' and table_name='productattribute'; 0.11MB/711

select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='database nane' and table_name='userpictures'; 0.02MB/30

转载于:https://www.cnblogs.com/youlixishi/p/5821609.html

你可能感兴趣的文章