View Queries in real time

The rows returned by the SHOW FULL PROCESSLIST query to the MySQL server are stored in a table (named processlist) in the embedded database - one column for every column returned plus one additional column named action. The Action column contains an HTML string that is used for the various options that are provided by SQL DM for MySQL. This table is stored in a MEMORY type database (no disk storage) and only the data returned by the latest SHOW FULL PROCESSLIST for each server is saved.

Also, PROCESSLIST data is only retrieved when the corresponding page in the web interface is showing in one or more browser windows connected to SQL DM for MySQL.



SQL Diagnostic Manager for MySQL agentless and cost-effective performance monitoring for MySQL and MariaDB.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal
  • No labels