The Disk Info is an easy to use disk space usage analyzer that allows you to see which MySQL server takes up the most space. It displays number of databases with their data and index sizes. It gives you the snapshot of the disk space occupied by MySQL database objects on your servers as well as a graphical chart display to quickly spot the largest databases.
The Disk information is available at 2 information levels:
- Database level
- Table level
In 'Database' and 'Table' information levels the data are illustrated by a graphical chart (a 'Doughnut' chart type) for an easy overview. If there are few objects only (databases on server or tables in database) they will all display in the graph - if there are many only the top 5 will be displayed.
An overview of the 2 information levels:
Database level: You reach at this level by clicking on one of the connections in the 'Connection level view'. Here, you get an overview of the space occupied by individual MySQL databases on the server you selected.
Table level: You reach at this level by clicking on one of the databases in the 'database level' view. Here you get an overview of the space occupied by individual tables in the MySQL database you selected.
To the extent that information is available, a detailed view of the disk space occupied by data and indexes is provided, along with values indicating how efficiently disk space for every object is utilized. Note that for specific table ENGINES such information is not always available and "N/A" will be displayed.
Also note: For table ENGINES having a shared tablespace for all databases like INNODB (if not the file_per_table option is set in configuration) the 'Connection level' will return the size of the tablespace itself not the cumulative sum of the databases as shown in the 'database level'. This may be rather misleading as the tablespace does not 'shrink' when objects are dropped. Same may apply to 3rd party engines (like SolidDB) also having a shared tablespace for all databases. Also with third party ENGINES and ENGINES in beta other issues may occur that could affect the accuracy and usability of the information. Finally, note that you can navigate back to the Database level from the Table level by clicking on the database name adjacent to the chart. You can navigate back to the servers page by clicking on the 'Back to servers' link.
Also, Disk Info charts displayed can now be exported as JPEG/PNG/PDF formats.
NOTE: This feature is available in MONyog Enterprise and Ultimate