SELECT * FROM `x$session`
|
thd_id | conn_id | user | db | command | state | time | current_statement | statement_latency | progress | lock_latency | rows_examined | rows_sent | rows_affected | tmp_tables | tmp_disk_tables | full_scan | last_statement | last_statement_latency | current_memory | last_wait | last_wait_latency | source | trx_latency | trx_state | trx_autocommit | pid | program_name | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7445 | 7089 | root@192.168.30.20 | sys | Query | executing | 0 | SELECT * FROM `x$session` LIMIT 0, 25 | 33191717000 | NULL | 674000000 | 0 | 0 | 0 | 4 | 0 | YES | NULL | NULL | 400828 | NULL | NULL | NULL | 50825000 | COMMITTED | YES | NULL | NULL | |
7440 | 7084 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 30000000 | 0 | 0 | 0 | 0 | 0 | NO | NULL | 99765000 | 24736 | NULL | NULL | NULL | 466320000 | COMMITTED | YES | NULL | NULL | |
7441 | 7085 | root@192.168.30.20 | sys | Query | NULL | 0 | SELECT * FROM `x$schema_table_statistics_with_buff... | 179584968000 | NULL | 507000000 | 286 | 0 | 0 | 7 | 1 | YES | NULL | NULL | 1174279 | NULL | NULL | NULL | 44001000 | COMMITTED | YES | NULL | NULL | |
7442 | 7086 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 51000000 | 0 | 0 | 0 | 0 | 0 | NO | NULL | 185178000 | 24736 | NULL | NULL | NULL | 25911000 | COMMITTED | YES | NULL | NULL | |
7443 | 7087 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 126000000 | 0 | 0 | 0 | 0 | 0 | NO | NULL | 314664000 | 24736 | NULL | NULL | NULL | 182400000 | COMMITTED | YES | NULL | NULL | |
7444 | 7088 | root@192.168.30.20 | sys | Sleep | NULL | 0 | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | NULL | NULL | 221000000 | 3 | 0 | 0 | 0 | 0 | NO | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | 390457000 | 18108 | NULL | NULL | NULL | 145914000 | COMMITTED | YES | NULL | NULL | |
44 | 4 | sql/event_scheduler | NULL | Sleep | Waiting on empty queue | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NO | NULL | NULL | 16569 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|