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.