In order to start using Real-Time, you will have to select a server from the dropdown, choose a saved session or hit 'Start new session' and voila! You can pause recording and also save a session for later analysis. The charts are zoomable.
Monyog 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 will stop and save after 3 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 will get additional information like
execution time, user/host information, the total count for each query.
You do not have to enable general log to retrieve his 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.
For MySQL versions above 5.1, InnoDB plugin has to installed to retrieve locked and locking query information. But for 5.5 onwards MySQL comes with InnoDB storage engine. Refer documentation for more details.
This feature is available in Monyog Enterprise and Ultimate.