select concat(round(sum(data_length/1024/1024),2),‘MB’) as data_length_MB,
concat(round(sum(index_length/1024/1024),2),‘MB’) as index_length_MB
from information_schema.tables
where table_schema=‘pbs_finance’ AND table_name=‘fun_depositsBankFlow’
TABLE_NAME :表名字;
DATA_LENGTH : 数据大小;
INDEX_LENGTH :索引大小;
TABLE_ROWS : 记录数量;
TABLE_SCHEMA : 数据库名字
查看数据库表占用内存
最新推荐文章于 2024-07-21 03:21:53 发布