|
|
The Disk information is available at 3 information levels:
Connection level
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 most significant will display.
An overview of the 3 information levels:
Connection level: This level is displayed when you open the Disk Info tab. It displays the connections you have defined in the 'Register Servers' page. For every connection that is registered and selected you get an overview of the space occupied by MySQL databases on each server.
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 forth and back between the 3 information levels using the 'Breadcrumb' navigation bar on top of every page.
Also, Disk Info charts displayed can now be exported as PDF/JPG/PNG formats. Refer for more info "Exporting graphics".
NOTE: This feature is available in MONyog Enterprise and Ultimate.
|
|