Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 display in the graph.

...

You reach at this level by clicking on the Disk Info option provided for each server in the Servers page. In this view, you get an overview of the space occupied by individual MySQL databases on the server you selected.

...

You reach at this level by clicking one of the databases in the 'database level' Database Level view. In this screen, you get an overview of the space occupied by the individual tables in the MySQL database you selected.

...

Also, you get a detailed view of the disk space occupied by data and indexes, 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 displayeddisplays.

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' Level returns the size of the tablespace itself not the cumulative sum of the databases as shown in the 'database level'Database Level. This may be rather misleading as the tablespace does not ' shrink ' when objects are dropped. Same may apply to 3rd third-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 can affect the accuracy and usability of the information. Finally, 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.

Tip

Disk Info charts displayed can now be exported as JPEG/PNG/PDF formats.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse
Note
This feature is available in SQL DM for MySQL Enterprise and Ultimate