MySQL管理工具MySQL Utilities查询MySQL使用的空间大小

我们准备备份或维护数据的时候,常常会考虑磁盘空间大小的问题,通常需要知道我们的数据和日志有多大,数据是至关重要的,数据是生命线.

使用mysqldiskusage 工具来查看数据库实例使用到的空间,包括数据库和各种日志大小.

实例:

1. shell>sudoenvPYTHONPATH=$PYTHONPATHmysqldiskusage\
2. --server=root:root@localhost--all
3. #Sourceonlocalhost:...connected.
4. #Databasetotals:
5. +-----------------+--------------+
6. |db_name|total|
7. +-----------------+--------------+
8. |oltp2|829,669|
9. |bvm|15,129|
10. |db1|9,895|
11. |db2|11,035|
12. |employees|206,117,692|
13. |griots|14,415|
14. |mysql|995,722|
15. |oltp1|177,393|
16. |room_temp|9,847|
17. |sakila|791,727|
18. |test|647,911|
19. |test_arduino|9,999|
20. |welford_kindle|72,032|
21. |world|472,785|
22. |world_innodb|829,669|
23. +-----------------+--------------+
25. Totaldatabasediskusage=210,175,251bytesor200.44MB
27. #Loginformation.
28. +--------------------+--------------+
29. |log_name|size|
30. +--------------------+--------------+
31. |host123.log|957,282,265|
32. |host123-slow.log|123,647|
33. |host123.local.err|321,772,803|
34. +--------------------+--------------+
36. Totalsizeoflogs=1,279,178,715bytesor1.19GB
38. #Binaryloginformation:
39. Currentbinarylogfile=my_log.000287
40. +----------------+---------+
41. |log_file|size|
42. +----------------+---------+
43. |my_log.000285|252208|
44. |my_log.000286|256|
45. |my_log.000287|3063|
46. |my_log.index|48|
47. +----------------+---------+
49. Totalsizeofbinarylogs=255,575bytesor249.58KB
51. #Serverisnotanactiveslave-norelayloginformation.
52. #InnoDBtablespaceinformation:--phpfensi.com
53. +--------------+--------------+
54. |innodb_file|size|
55. +--------------+--------------+
56. |ib_logfile0|5,242,880|
57. |ib_logfile1|5,242,880|
58. |ibdata1|815,792,128|
59. |ibdata2|52,428,800|
60. +--------------+--------------+
62. TotalsizeofInnoDBfiles=889,192,448bytesor848.00MB
64. InnoDBfreespace=635,437,056bytesor606.00MB

使用–all选项,将显示所有日志和InnoDB的磁盘使用情况,也会列出所有数据库,即使不包含任何数据.

权限:用户必须具有读取数据目录的权限.