SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='数据库名';
- 单位为字节
SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='数据库名';
本文标题：查看Mysql数据库表占用内存
本文链接：https://www.haomeiwen.com/subject/evafcqtx.html
网友评论