You can pause recording and save a session for later analysis. The charts are zoomable.
SQL DM for MySQL stores Real-Time data gathered in a session in SQLite. You can find them in the data
folders under realtimedata
. Real-Time data collection for the server stops and save after three days if no activity happens inside that session.
Real-Time gives you details of your server activity.
The Queries tab gives you an aggregated view of the queries that are executed in a session. This information is obtained from the SHOW FULL PROCESSLIST
. You get additional information like execution time, user/host information, and the total count for each query. You do not have to enable general log to retrieve this information.
The Tables and Databases tabs detail information retrieved using SHOW OPEN TABLES
:
The Hosts, Users, and Slow queries are again fetched from the SHOW FULL PROCESSLIST
and aggregated information is displayed. There is an option to change the slow query time of Real-Time profiler. On selecting Slow queries, Real-Time considers the queries taking more than the specified time as slow queries.
The Locked queries, Locking queries, and Locked tables tabs are fetched from InnoDB transaction tables.