当前位置:网站首页>MySQL query library size
MySQL query library size
2022-04-23 15:14:00 【A run】
select
table_schema as ' database ',
sum(table_rows) as ' Record number ',
sum(truncate(data_length/1024/1024, 2)) as ' Data capacity (MB)',
sum(truncate(index_length/1024/1024, 2)) as ' Index capacity (MB)'
from information_schema.tables
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;
版权声明
本文为[A run]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231407312563.html
边栏推荐
- Llvm - generate for loop
- win10 任务栏通知区图标不见了
- Baidu written test 2022.4.12 + programming topic: simple integer problem
- My raspberry PI zero 2W toss notes to record some problems and solutions
- Kubernetes详解(九)——资源配置清单创建Pod实战
- What is the effect of Zhongfu Jinshi wealth class 29800? Walk with professional investors to make investment easier
- Sqlserver transaction and lock problem
- Little red book timestamp2 (2022 / 04 / 22)
- Example of time complexity calculation
- Practice of unified storage technology of oppo data Lake
猜你喜欢
中富金石财富班29800效果如何?与专业投资者同行让投资更简单
LeetCode165-比较版本号-双指针-字符串
Five data types of redis
1n5408-asemi rectifier diode
UML学习_day2
LeetCode151-颠倒字符串中的单词-字符串-模拟
8.2 text preprocessing
Detailed explanation of C language knowledge points -- first understanding of C language [1] - vs2022 debugging skills and code practice [1]
Openfaas practice 4: template operation
如何设计一个良好的API接口?
随机推荐
分布式事务Seata介绍
What is the effect of Zhongfu Jinshi wealth class 29800? Walk with professional investors to make investment easier
Little red book timestamp2 (2022 / 04 / 22)
async关键字
The life cycle of key value in redis module programming
LeetCode167-两数之和II-双指针-二分-数组-查找
C language super complete learning route (collection allows you to avoid detours)
like和regexp差别
C语言超全学习路线(收藏让你少走弯路)
Kubernetes详解(九)——资源配置清单创建Pod实战
LeetCode149-直线上最多的点数-数学-哈希表
Detailed explanation of C language knowledge points - data types and variables [2] - integer variables and constants [1]
Alexnet model
Common interview questions of operating system:
LeetCode153-寻找旋转排序数组中的最小值-数组-二分查找
T2 iCloud日历无法同步
Borui data and F5 jointly build the full data chain DNA of financial technology from code to user
SQL中HAVING和WHERE的区别
The wechat applet optimizes the native request through the promise of ES6
Basic operation of sequential stack