SmartMySQL is providing built-in database reports, which are the well-formatted result of DB servers' Disk, CPU, RAM utilization and contains useful data for decision-making and analysis. SmartMySQL tools include built-in reports; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy understand your Database usage
RAM Reports shows detailed reports about DB server RAM details. Also, it can calculate RAM allocation based on your DB server configurations variables.
Disk utilization reports give details about size of each database, Table, Index details with rich graphs. It is easy to identify Big size tables which are occupied huge size in the storage. The following reports are available
Index Reports provide details about all index, Foreign key, duplicate index and unused index details which are very useful for database administrator and developers. You can drop unused and duplicate indexes, results to be save storage and improve performance.
It has the following details under File IO Report section.
These reports are very useful reports provide details about SQL Statements utilization. It is easy to identify which SQL Queries are taking more resources consumption, executing with high frequency, doing Full table scan, and creating Temp tables.
It has the following reports under Miscellaneous Reports
SmartMySQL is a next-generation GUI tool for the RDBMS MySQL. It has unique advanced features help to Speed up SQL and PL/SQL development time, Optimize slow query and recommends optimal indexes and Debugs Production MySQL problems and provides fixes.