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 | 1566 | 19591290742320 | 51229728 | 12510402696.0000 | 94665321168 | 18 | NULL | |
page_flush_coordinator_thread | 4923 | 3232242404160 | 2962080 | 972822312.0000 | 133308454752 | 13 | NULL | |
io_write_thread | 231 | 2241597740976 | 1433843136 | 9703886280.0000 | 30831002400 | 9 | NULL | |
log_checkpointer_thread | 204 | 1333301948352 | 7093152 | 6535793616.0000 | 31863412416 | 15 | NULL | |
io_write_thread | 121 | 1129304317152 | 1556117904 | 9333093528.0000 | 28725061728 | 10 | NULL | |
log_writer_thread | 2769 | 703867183008 | 453552 | 254195304.0000 | 15039994464 | 20 | NULL | |
io_write_thread | 74 | 678598060272 | 1565802480 | 9170243808.0000 | 29889478608 | 11 | NULL | |
io_write_thread | 44 | 471752707536 | 1509877776 | 10721652216.0000 | 26760598128 | 12 | NULL | |
main | 147 | 107755105392 | 73920 | 468221589.0000 | 30856177440 | 1 | NULL | |
srv_worker_thread | 2 | 5892208080 | 1812801408 | 2946104040.0000 | 4079406672 | 38 | NULL | |
srv_worker_thread | 3 | 3979032288 | 13646688 | 1326343920.0000 | 3948014928 | 42 | NULL | |
srv_purge_thread | 3 | 2455758096 | 202421472 | 818585856.0000 | 1984697616 | 36 | NULL | |
clone_gtid_thread | 5 | 1279746864 | 11603328 | 255949320.0000 | 433465296 | 35 | NULL | |
io_read_thread | 14 | 492575952 | 19194384 | 35183808.0000 | 134669040 | 5 | NULL | |
srv_worker_thread | 2 | 325695744 | 8350320 | 162847872.0000 | 317345424 | 40 | NULL |
|