Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

Using Real-Time

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.

image

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.

image

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:

image

The 'Hosts', 'Users' and 'Slow queries' are again fetched from the SHOW FULL PROCESSLIST and aggregated information is displayed.

image

The 'Locked queries', 'locking queries' and 'locked tables' tabs are fetched from InnoDB transaction tables.

Note

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.

image

Note

This feature is available in Monyog Enterprise and Ultimate.