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

Real-Time

Real-Time is what you need to use if you do not have Slow log or sniffer and still want to know what is happening on your server in real time!

Real-Time continuously executes a bunch of queries on a server and fetches information on the top queries, tables, databases, user, hosts, queries that are locked, queries that are locking etc. Since the information is retrieved in real time, you get to see what your server is up to at any point in time. You will have to start 'Recording' a session in order to see your server activity. 'Recording' can be stopped and saved for later analysis.

Real-Time collection mode

Real-Time monitoring can be done in two modes: "Processlist" and "Performance schema". In "Processlist" mode, Monyog executes the query SHOW FULL PROCESSLIST every second to fetch the queries. Performance schema based Real-time makes use of the performance_schema database of the MySQL server. Performance schema database logs each and every query in its table. Monyog queries the performance_schema and retrieves the queries, including the short-lived ones.

With Performance schema based Real-time, you can get extra information like Number of full table scans done by the query, Success, Error and Warning count for each query.

image

Note

This feature is available in Monyog Enterprise and Ultimate.