Queries view
Queries View
The Queries view view provides a detailed view of ongoing and past queries, providing specifics like query text, start time, execution duration, and more. Advanced filtering options let users sort and filter this data by various metrics, such as duration, to quickly isolate long-running or resource-intensive queries.
Query History
The query history chart provides a comprehensive overview of past queries. This historical data is crucial for diagnosing problems, planning capacity, and preparing for future demands by understanding past trends and behaviors.
Total Executing Queries
The total executing queries chart provides a real-time snapshot of the number of queries currently being executed on your MySQL server. This metric is essential for understanding the current load on your database and identifying potential bottlenecks or performance issues.
Executing Query & Query Duration
The executing query and query duration provides a information regrading the current running query, including the query text, start time, execution duration, and more. This real-time visibility is crucial for database administrators who need to ensure optimal performance and quick troubleshooting.
Locks & Waits
The locks and waits count provides insights into the queries that are currently waiting for locks or resources to be released. This metric is essential for identifying potential bottlenecks and performance issues caused by locking contention.
Pie Chart View
For a more graphical representation, the pie chart view breaks down query statistics into visual segments, making it easy to digest the proportional impact of different queries on your system. This can be particularly useful for presentations and quick assessments during team meetings or reports.
Table View
This view presents a detailed tabulation of ongoing queries and processes, providing specifics like query text, start time, execution duration, and more. Advanced filtering options let users sort and filter this data by various metrics, such as duration, to quickly isolate long-running or resource-intensive queries.
