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

|
|
Number of rows:

ID USER HOST DB COMMAND TIME STATE INFO
1009674 root localhost:49899 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
1009672 root localhost:49897 test Query 0 Opening tables 
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= 'test'
1009676 root localhost:49901 mysql Sleep 0 NULL
1009671 root localhost:49896 test2 Query 0 Opening tables 
SELECT `SPECIFIC_NAME`, `ROUTINE_NAME`, `ROUTINE_TYPE`, `DTD_IDENTIFIER`, `ROUTINE_DEFINITION` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE ROUTINE_SCHEMA='test2'
1009667 root localhost:49892 mysql Sleep 0 NULL
1009675 root localhost:49900 information_schema Query 0 executing 
SELECT * FROM `PROCESSLIST`
 LIMIT 0, 25
1009666 root localhost:49891 mysql Query 0 checking permissions 
SHOW COLUMNS FROM `mysql`.`proxies_priv`
1009673 root localhost:49898 mysql Sleep 0 NULL

|
|
Number of rows:
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