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 | 633 | 9303021551472 | 51183264 | 14696716320.0000 | 540848300784 | 18 | NULL | |
page_flush_coordinator_thread | 1625 | 1172627989632 | 3437280 | 386246916.0000 | 49076956368 | 13 | NULL | |
io_write_thread | 73 | 888390731712 | 105880368 | 12169736040.0000 | 34112121120 | 10 | NULL | |
io_write_thread | 61 | 733280474256 | 2175989904 | 12020991312.0000 | 34883091408 | 9 | NULL | |
log_writer_thread | 1381 | 682712031408 | 466752 | 494360592.0000 | 325773233808 | 20 | NULL | |
log_checkpointer_thread | 72 | 541625062704 | 10722096 | 7522570176.0000 | 24182628096 | 15 | NULL | |
io_write_thread | 13 | 192477048720 | 1863002592 | 14805926784.0000 | 35838526944 | 11 | NULL | |
io_write_thread | 10 | 144743159616 | 1582606608 | 14474315856.0000 | 33482964768 | 12 | NULL | |
main | 146 | 101424816240 | 92928 | 433321251.0000 | 38023076256 | 1 | NULL | |
io_read_thread | 14 | 2423898576 | 21986448 | 173135424.0000 | 1869351264 | 5 | NULL | |
srv_worker_thread | 2 | 1152611856 | 13847856 | 576305928.0000 | 1138764000 | 42 | NULL | |
clone_gtid_thread | 5 | 977463696 | 5785824 | 195492528.0000 | 339808128 | 35 | NULL | |
srv_purge_thread | 2 | 445836864 | 220956912 | 222918432.0000 | 224879952 | 36 | NULL | |
srv_worker_thread | 1 | 330799920 | 330799920 | 330799920.0000 | 330799920 | 40 | NULL | |
srv_worker_thread | 2 | 113146176 | 10860432 | 56573088.0000 | 102285744 | 38 | NULL |
|