Server: mysql wampserver »Database: information_schema »Table: PROCESSLIST
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 10 (11 total, Query took 0.0052 sec)
SELECT * FROM `PROCESSLIST`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


ID USER HOST DB COMMAND TIME STATE INFO
1173288 root localhost:53292 information_schema Query 0 Opening tables
SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`         AS `Name`,
                    `TABLE_TYPE`         AS `TABLE_TYPE`,
                    `ENGINE`             AS `Engine`,
                    `ENGINE`             AS `Type`,
                    `VERSION`            AS `Version`,
                    `ROW_FORMAT`         AS `Row_format`,
                    `TABLE_ROWS`         AS `Rows`,
                    `AVG_ROW_LENGTH`     AS `Avg_row_length`,
                    `DATA_LENGTH`        AS `Data_length`,
                    `MAX_DATA_LENGTH`    AS `Max_data_length`,
                    `INDEX_LENGTH`       AS `Index_length`,
                    `DATA_FREE`          AS `Data_free`,
                    `AUTO_INCREMENT`     AS `Auto_increment`,
                    `CREATE_TIME`        AS `Create_time`,
                    `UPDATE_TIME`        AS `Update_time`,
                    `CHECK_TIME`         AS `Check_time`,
                    `TABLE_COLLATION`    AS `Collation`,
                    `CHECKSUM`           AS `Checksum`,
                    `CREATE_OPTIONS`     AS `Create_options`,
                    `TABLE_COMMENT`      AS `Comment`
                FROM `information_schema`.`TABLES` t
                WHERE  `TABLE_SCHEMA`
                    IN ('information_schema')
                     ORDER BY Name ASC LIMIT 250 OFFSET 0
1173289 root localhost:53293 mysql Sleep 1 NULL
1173259 root localhost:53262 mysql Sleep 1 NULL
1173278 root localhost:53281 mysql Query 0 executing
SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`SCHEMATA` WHERE TRUE
1173279 root localhost:53282 information_schema Query 0 Opening tables
SELECT TABLE_NAME
            FROM information_schema.VIEWS
            WHERE TABLE_SCHEMA = 'information_schema'
                AND TABLE_NAME = 'PARTITIONS'
                AND IS_UPDATABLE = 'YES'
1173265 root localhost:53268 information_schema Query 0 Opening tables
SELECT COUNT(*) FROM `information_schema`.`PARTITIONS`
1173291 root localhost:53295 information_schema Query 0 executing
SELECT * FROM `PROCESSLIST`
 LIMIT 0, 25
1173286 root localhost:53289 NULLQuery 1 executing
SHOW VARIABLES LIKE 'character_set_results'
1173285 root localhost:53288 readme_to_recover_sz Sleep 0 NULL
1173284 root localhost:53287 performance_schema Query 0 executing
SELECT (COUNT(`SCHEMA_NAME`) DIV 250) * 250 FROM `INFORMATION_SCHEMA`.`SCHEMATA` WHERE `SCHEMA_NAME` < 'performance_schema' ORDER BY `SCHEMA_NAME` ASC
1173287 root localhost:53291 mysql Query 0 Writing to net
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, DEFINER FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'mysql'

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view