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