|
Current PerformanceThe DBTuna Current Performance View displays current database performance metrics including:
- Current MySQL Buffer Usage - including Read and Write ratios
- Current Query Cache Usage - including Hit to Insert ratio
- Connection Usage
- Table Lock Activity
- Current connected sessions and activity information
|
Historical PerformanceThe DBTuna Activitiy View is the main view within DBTuna where historical database activity and performance information is displayed; including:
- Time series activity graphs showing MySQL resource consumption versus number of completed database queries.
- Completely configurable views, from last 5 minutes to last 30 days.
- Breakdown of activity by Wait state
- Correlated drilldown by Server, SQL, Grouped SQL, User, Session, Database
|
 |
 |
MySQL StatisticsThe DBTuna Statistics View displays historical statistical information on your MySQL database:
- Report and analyze any statistic available from MySQL
- Display Delta Graph's over-time
|
SQL DrilldownOnce poorly performing SQL has been identified by DBTuna the DBA can drill into the SQL View to display details of the statement and explain plan:
- One click statement analysis shows the MySQL Explain plan to quickly see if it has the optimum access path.
- Display wait states for SQL.
- Parses the SQL to make it easier to read.
|
 |
 |
Objects ViewThe DBTuna Objects View displays all the current MySQL configuration parameters from any monitored database, as well as databases, tables and objects:
- One-click view to check or cross reference Database config values.
- Switch between monitored databases to compare config values.
- Quickly view information on tables and indexes.
- Display historical config changes to your MySQL instance.
|