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 - 3 (4 total, Query took 0.0053 sec)
SELECT * FROM `PROCESSLIST`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


ID USER HOST DB COMMAND TIME STATE INFO
429235 root localhost:51328 information_schema Query 0 removing tmp table
SELECT COUNT(*) FROM `information_schema`.`STATISTICS`
429237 root localhost:51330 mysql Sleep 0 NULL
429243 root localhost:51336 information_schema Query 0 executing
SELECT * FROM `PROCESSLIST`
 LIMIT 0, 25
429242 root localhost:51335 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')
                    AND t.`TABLE_NAME` = 'GLOBAL_STATUS' ORDER BY Name ASC

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