Check Mysql Database Size
2024-08-25 08:52:27
SELECT ROUND( SUM(data_length + index_length) / 1024 / 1024 ) TOTAL_MB, ROUND(SUM(data_length) / 1024 / 1024) DATA_MB, ROUND( SUM(index_length) / 1024 /1024 ) INDEX_MB FROM information_schema.TABLES;
+----------+---------+----------+
|
TOTAL_MB | DATA_MB | INDEX_MB | +----------+---------+----------+
|
944 | 466 | 478 | +----------+---------+----------+
1
row in
set
(0.04 sec) SELECT
TABLE_SCHEMA,
ENGINE,
ROUND(
SUM(data_length + index_length) / 1024 / 1024
) TOTAL_MB,
ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,
ROUND(
SUM(index_length) / 1024 / 1024
) INDEX_MB,
count(*) "TABLES"
FROM
information_schema. TABLES
GROUP BY
TABLE_SCHEMA,
ENGINE
ORDER BY 3 DESC;
+--------------------+--------------------+----------+---------+----------+--------+
|
TABLE_SCHEMA | ENGINE | TOTAL_MB | DATA_MB | INDEX_MB | TABLES |
+--------------------+--------------------+----------+---------+----------+--------+
|
zwc | MyISAM | 485 | 191 | 294 | 1 |
|
zwc | InnoDB | 456 | 273 | 183 | 1 |
|
common_schema | InnoDB | 2 | 2 | 0 | 11 |
|
mysql | MyISAM | 1 | 1 | 0 | 22 |
|
information_schema | MyISAM | 0 | 0 | 0 | 9 |
|
mysql | CSV | 0 | 0 | 0 | 2 |
|
information_schema | MEMORY | 0 | 0 | 0 | 28 |
|
common_schema | MyISAM | 0 | 0 | 0 | 7 |
|
performance_schema | PERFORMANCE_SCHEMA | 0 | 0 | 0 | 17 |
|
common_schema | NULL
| NULL
| NULL
| NULL
| 62 | +--------------------+--------------------+----------+---------+----------+--------+
10
rows
in
set
(0.03 sec) Check table number:
SELECT
TABLE_SCHEMA,
ENGINE,
ROUND(
SUM(data_length + index_length) / 1024 / 1024
) TOTAL_MB,
ROUND(SUM(data_length) / 1024 / 1024) DATA_MB,
ROUND(
SUM(index_length) / 1024 / 1024
) INDEX_MB,
count(*) "TABLES"
FROM
information_schema. TABLES
GROUP BY
TABLE_SCHEMA,
ENGINE
ORDER BY 3 DESC;
最新文章
- centos 下pip 安装snappy 系列问题记录
- 响应式设计，bootstrap框架的IE兼容问题
- 两年内从零到每月十亿 PV 的发展来谈 Pinterest 的架构设计（转）
- JPA && Spring Data && Spring Data JPA
- Effective C++ 笔记三 资源管理
- CSS常用操作-对齐
- 博客收藏--sailing的博客
- JS对象属性命名规则
- 与scrollTop相关的一些方法（更新）
- UWP Acrylic Material
- redis日志格式
- Rhino学习教程——1.2
- ASP.NET获取POST提交过来的数据流，转换成Json格式的字符串
- fixed Oracle SQL报错 #ORA-01460: 转换请求无法实施或不合理
- Innodb semi-consistent 简介
- Linux 权限管理命令
- 17行代码解决微信小程序图片延迟加载
- Java相关文章
- BZOJ.3673/3674.可持久化并查集(可持久化线段树 按秩合并/启发式合并)
- java和js生成二维码