Page History

...

• 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.