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 | 202 | 2784308428704 | 61113360 | 13783705056.0000 | 114401879856 | 18 | NULL | |
io_write_thread | 117 | 1089418941600 | 1463767008 | 9311272872.0000 | 39246457008 | 9 | NULL | |
page_flush_coordinator_thread | 853 | 1034534736576 | 3852816 | 642673548.0000 | 58556377440 | 13 | NULL | |
log_checkpointer_thread | 100 | 655607574336 | 8288544 | 6556075680.0000 | 20602990848 | 15 | NULL | |
io_write_thread | 49 | 427890313488 | 1533998928 | 8732455248.0000 | 47347754784 | 10 | NULL | |
io_write_thread | 12 | 101797132272 | 1714459296 | 8483094312.0000 | 12567368352 | 11 | NULL | |
main | 149 | 81421999296 | 92928 | 367639635.0000 | 25905152064 | 1 | NULL | |
io_write_thread | 8 | 69454071984 | 1630846800 | 8681758800.0000 | 13335524400 | 12 | NULL | |
log_writer_thread | 294 | 63498726192 | 529056 | 215981832.0000 | 6768822192 | 20 | NULL | |
srv_worker_thread | 3 | 2896856160 | 12818784 | 965618544.0000 | 2870676864 | 42 | NULL | |
srv_worker_thread | 2 | 1723054080 | 25855632 | 861527040.0000 | 1697198448 | 38 | NULL | |
clone_gtid_thread | 5 | 827495856 | 4521264 | 165498960.0000 | 294798768 | 35 | NULL | |
srv_purge_thread | 2 | 488331360 | 243666192 | 244165680.0000 | 244665168 | 36 | NULL |
|