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 | 414 | 5577931445328 | 66224400 | 13473264288.0000 | 102695888064 | 18 | NULL | |
page_flush_coordinator_thread | 2259 | 2316861319872 | 3305808 | 1027036164.0000 | 451593983280 | 13 | NULL | |
io_write_thread | 114 | 1171991482464 | 114384864 | 10280627016.0000 | 25776260400 | 9 | NULL | |
log_checkpointer_thread | 106 | 715284120672 | 9170832 | 6747963288.0000 | 22153344576 | 15 | NULL | |
io_write_thread | 57 | 623495583744 | 1521196512 | 10938518976.0000 | 29456236128 | 10 | NULL | |
io_write_thread | 48 | 543376381152 | 1689558288 | 11320341120.0000 | 24270280848 | 11 | NULL | |
log_writer_thread | 718 | 257084440800 | 470448 | 358056072.0000 | 80525986992 | 20 | NULL | |
io_write_thread | 8 | 121978205712 | 2502823488 | 15247275648.0000 | 32605218096 | 12 | NULL | |
main | 147 | 100157881296 | 73392 | 408188715.0000 | 28685321808 | 1 | NULL | |
srv_purge_thread | 2 | 2398919952 | 936328272 | 1199459976.0000 | 1462591680 | 36 | NULL | |
srv_worker_thread | 2 | 1149453360 | 8333424 | 574726680.0000 | 1141119936 | 42 | NULL | |
clone_gtid_thread | 4 | 580918272 | 5462160 | 145229568.0000 | 300075600 | 35 | NULL | |
srv_worker_thread | 1 | 177190464 | 177190464 | 177190464.0000 | 177190464 | 40 | NULL | |
io_read_thread | 2 | 104485392 | 22041888 | 52242696.0000 | 82443504 | 5 | NULL | |
srv_worker_thread | 3 | 47029488 | 7485456 | 15676320.0000 | 31647792 | 38 | NULL |
|