SELECT * FROM `x$io_by_thread_by_latency`
|
user | total | total_latency | min_latency | avg_latency | max_latency | thread_id | processlist_id | |
---|---|---|---|---|---|---|---|---|
log_flusher_thread | 237 | 3198026841504 | 41534064 | 13493783952.0000 | 154196825904 | 18 | NULL | |
log_writer_thread | 375 | 670766691408 | 497376 | 1788711144.0000 | 263690719248 | 20 | NULL | |
page_flush_coordinator_thread | 788 | 662541806256 | 3767280 | 4380667632.0000 | 148382622432 | 13 | NULL | |
io_write_thread | 41 | 434644651584 | 1393126944 | 10601088960.0000 | 25621608672 | 9 | NULL | |
io_write_thread | 17 | 186493077408 | 1626958608 | 10970181024.0000 | 33099851664 | 11 | NULL | |
log_checkpointer_thread | 28 | 173487271056 | 9095856 | 6195973872.0000 | 17904634176 | 15 | NULL | |
main | 147 | 113016980736 | 79200 | 435183177.0000 | 30858444672 | 1 | NULL | |
io_write_thread | 9 | 101212029600 | 2175383760 | 11245780920.0000 | 17186963904 | 12 | NULL | |
io_write_thread | 10 | 89501919936 | 1497472944 | 8950191888.0000 | 15363551808 | 10 | NULL | |
io_read_thread | 13 | 11926455552 | 27937008 | 917419536.0000 | 10908177984 | 5 | NULL | |
srv_purge_thread | 2 | 3899167008 | 211017840 | 1949583504.0000 | 3688149168 | 36 | NULL | |
root@192.168.30.20 | 1 | 1886755728 | 1886755728 | 1886755728.0000 | 1886755728 | 1470 | 1286 | |
srv_worker_thread | 2 | 1172856432 | 9038304 | 586428216.0000 | 1163818128 | 38 | NULL | |
clone_gtid_thread | 5 | 1016555232 | 8135952 | 203310888.0000 | 361491504 | 35 | NULL | |
srv_worker_thread | 2 | 22478016 | 10327680 | 11239008.0000 | 12150336 | 42 | NULL |
|