...
| Tip |
|---|
Real-Time is what you need to use if you do not have Slow or General query log or sniffer, and still want to know what is happening on your server in real time. |
Real-Time collection mode
Real-Time monitoring can be done in two modes: Processlist and Performance Schema.
- Processlist mode, SQL DM for MySQL 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. SQL DM for MySQL queries the performance_schema and retrieves the queries, including the short-lived ones. - 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.
| Note |
|---|
| This feature is available in SQL DM for MySQL Enterprise and Ultimate. |