SELECT * FROM `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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
880 | 812 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 28.00 us | 0 | 0 | 0 | 0 | 0 | NO | NULL | 75.92 us | 24.16 KiB | NULL | NULL | NULL | 271.07 us | COMMITTED | YES | NULL | NULL | |
881 | 813 | root@192.168.30.20 | performance_schema | Sleep | NULL | 0 | SELECT COUNT(*) FROM ( SELECT ... SCHEMA.SCHEMATA... | NULL | NULL | 185.00 us | 30 | 1 | 0 | 2 | 0 | YES | SELECT COUNT(*) FROM ( SELECT ... SCHEMA.SCHEMATA... | 421.48 us | 32.32 KiB | NULL | NULL | NULL | 200.06 us | COMMITTED | YES | NULL | NULL | |
882 | 814 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 26.00 us | 0 | 0 | 0 | 0 | 0 | NO | NULL | 50.00 us | 24.16 KiB | NULL | NULL | NULL | 347.80 us | COMMITTED | YES | NULL | NULL | |
883 | 815 | root@192.168.30.20 | performance_schema | Sleep | NULL | 0 | SELECT `SCHEMA_NAME` FROM `INF ... '_')) ORDER BY ... | NULL | NULL | 392.00 us | 151 | 30 | 0 | 3 | 0 | YES | SELECT `SCHEMA_NAME` FROM `INF ... '_')) ORDER BY ... | 1.02 ms | 32.32 KiB | NULL | NULL | NULL | 548.21 us | COMMITTED | YES | NULL | NULL | |
884 | 816 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 27.00 us | 0 | 0 | 0 | 0 | 0 | NO | NULL | 59.21 us | 24.16 KiB | NULL | NULL | NULL | 394.85 us | COMMITTED | YES | NULL | NULL | |
885 | 817 | root@192.168.30.20 | sys | Query | NULL | 0 | SET @sys.statement_truncate_le ... ('statement_tru... | 317.99 ms | NULL | 1.50 ms | 1 | 0 | 0 | 4 | 0 | YES | NULL | NULL | 1017.75 KiB | NULL | NULL | NULL | 316.51 ms | ACTIVE | YES | NULL | NULL | |
886 | 818 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 20.00 us | 0 | 0 | 0 | 0 | 0 | NO | NULL | 52.01 us | 24.16 KiB | NULL | NULL | NULL | 54.99 us | COMMITTED | YES | NULL | NULL | |
887 | 819 | root@192.168.30.20 | performance_schema | Sleep | NULL | 0 | SHOW INDEXES FROM `performance ... e_lock_waits_su... | NULL | NULL | 319.00 us | 17 | 3 | 0 | 1 | 0 | NO | SHOW INDEXES FROM `performance ... e_lock_waits_su... | 603.91 us | 16.40 KiB | NULL | NULL | NULL | 248.01 us | COMMITTED | YES | NULL | NULL | |
888 | 820 | pma@192.168.30.20 | NULL | Sleep | NULL | 0 | SHOW TABLES FROM `phpmyadmin` | NULL | NULL | 20.00 us | 0 | 0 | 0 | 0 | 0 | NO | NULL | 70.38 us | 24.16 KiB | NULL | NULL | NULL | 272.03 us | COMMITTED | YES | NULL | NULL | |
889 | 821 | root@192.168.30.20 | NULL | Sleep | NULL | 0 | SET collation_connection = 'utf8mb4_unicode_ci' | NULL | NULL | 0 ps | 0 | 0 | 0 | 0 | 0 | NO | SET collation_connection = 'utf8mb4_unicode_ci' | 102.83 us | 42.31 KiB | NULL | NULL | NULL | NULL | NULL | NULL | 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 | 16.38 KiB | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|