当前位置:网站首页>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
边栏推荐
- Redis cluster principle
- How does eolink help telecommuting
- 机器学习——逻辑回归
- Leetcode151 - invert words in string - String - simulation
- API gateway / API gateway (III) - use of Kong - current limiting rate limiting (redis)
- LeetCode149-直线上最多的点数-数学-哈希表
- UML learning_ Day2
- UML学习_day2
- Borui data and F5 jointly build the full data chain DNA of financial technology from code to user
- thinkphp5+数据大屏展示效果
猜你喜欢
Borui data and F5 jointly build the full data chain DNA of financial technology from code to user
My raspberry PI zero 2W toss notes to record some problems and solutions
Advanced version of array simulation queue - ring queue (real queuing)
Brute force of DVWA low -- > High
Differential privacy (background)
22年了你还不知道文件包含漏洞?
API gateway / API gateway (III) - use of Kong - current limiting rate limiting (redis)
My raspberry PI zero 2W tossing notes record some problems encountered and solutions
每日一题-LeetCode396-旋转函数-递推
Analysis of common storage types and FTP active and passive modes
随机推荐
Openfaas practice 4: template operation
How to write the keywords in the cover and title? As we media, why is there no video playback
中富金石财富班29800效果如何?与专业投资者同行让投资更简单
Lotus DB design and Implementation - 1 Basic Concepts
8.2 text preprocessing
Fill in the next right node pointer II of each node [classical hierarchy traversal | regarded as linked list]
[thymeleaf] handle null values and use safe operators
asp. Net method of sending mail using mailmessage
UML learning_ Day2
TLS / SSL protocol details (30) RSA, DHE, ecdhe and ecdh processes and differences in SSL
Kubernetes详解(十一)——标签与标签选择器
Reptile exercises (1)
LeetCode162-寻找峰值-二分-数组
C language super complete learning route (collection allows you to avoid detours)
The wechat applet optimizes the native request through the promise of ES6
Three uses of kprobe
MySQL installation process (steps for successful installation)
Nacos program connects to mysql8 0+ NullPointerException
Mds55-16-asemi rectifier module mds55-16
Difference between like and regexp