- 当前位置：首页 >时尚 >MySQL上线，检查数据库设计的“十条合规”
MySQL上线，检查数据库设计的“十条合规”
发布时间：2025-11-05 07:46:25 来源：创站工坊 作者：域名
复制SELECT TABLE_SCHEMA,十条合规 TABLE_NAME TABLE_NAME, TABLE_ROWS, CONCAT(ROUND(data_length / (1024 * 1024), 2),M) data_length, CONCAT(ROUND(index_length / (1024 * 1024), 2),M) index_length, CONCAT(ROUND(ROUND(data_length + index_length) / (1024 * 1024),2),M) total_size, engine FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA NOTIN (INFORMATION_SCHEMA , performance_schema, sys, mysql) ORDERBY (data_length + index_length) DESC LIMIT 10; +--------------+-----------------------+------------+-------------+--------------+------------+--------+ | TABLE_SCHEMA | TABLE_NAME | TABLE_ROWS | data_length | index_length | total_size | ENGINE | +--------------+-----------------------+------------+-------------+--------------+------------+--------+ | employees | salaries | 1910497 | 64.59M | 0.00M | 64.59M | InnoDB | | employees | employees | 299556 | 14.52M | 10.03M | 24.55M | InnoDB | | employees | employees01 | 101881 | 5.52M | 8.55M | 14.06M | InnoDB | | employees | t_temp | 95374 | 5.52M | 5.52M | 11.03M | InnoDB | | db3 | t_temp | 1000 | 0.08M | 0.13M | 0.20M | InnoDB | | db3 | transportorder | 3 | 0.02M | 0.06M | 0.08M | InnoDB | | db3 | transportorderwaybill | 3 | 0.02M | 0.05M | 0.06M | InnoDB | | db1 | pt1 | 10 | 0.06M | 0.00M | 0.06M | InnoDB | | db1 | city | 2 | 0.02M | 0.03M | 0.05M | InnoDB | | db2 | tabname | 30 | 0.02M | 0.03M | 0.05M | InnoDB | +--------------+-----------------------+------------+-------------+--------------+------------+--------+ 10 rowsinset (0.20 sec) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.
源码下载服务器租用源码库亿华云益华科技IT资讯网IT技术网企商汇香港云服务器IT资讯网益华科技益强前沿资讯益强数据堂益强资讯优选益华科技多维IT资讯亿华智慧云益强智囊团运维纵横极客编程码力社益强编程堂云站无忧编程之道亿华智造益华IT技术论坛全栈开发亿华科技益强科技亿华互联科技前瞻技术快报创站工坊亿华云益强智未来思维库益强科技亿华云计算亿华灵动极客码头益强IT技术网云智核汇智坊益强编程舍码上建站
- Copyright © 2025 Powered by MySQL上线，检查数据库设计的“十条合规”,创站工坊 滇ICP备2023006006号-44sitemap