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 | 267 | 4050384565392 | 139870368 | 15169979616.0000 | 368929078320 | 18 | NULL | |
page_flush_coordinator_thread | 833 | 935626382592 | 3578256 | 647888604.0000 | 62728777056 | 13 | NULL | |
io_write_thread | 73 | 843886290192 | 2031810000 | 11560086120.0000 | 28795337472 | 9 | NULL | |
io_write_thread | 35 | 537376897728 | 2424926592 | 15353625408.0000 | 142944392448 | 10 | NULL | |
log_checkpointer_thread | 60 | 433694979168 | 12589104 | 7228249512.0000 | 26342139648 | 15 | NULL | |
io_write_thread | 19 | 161926610736 | 1626829776 | 8522453016.0000 | 15409668912 | 12 | NULL | |
log_writer_thread | 424 | 149265700848 | 496320 | 352041624.0000 | 82349423376 | 20 | NULL | |
main | 149 | 99493824672 | 73392 | 409571448.0000 | 24543401520 | 1 | NULL | |
io_write_thread | 8 | 78592696512 | 2354597520 | 9824087064.0000 | 14474657472 | 11 | NULL | |
srv_purge_thread | 2 | 6203679504 | 1978000464 | 3101839752.0000 | 4225679040 | 36 | NULL | |
srv_worker_thread | 2 | 3128106432 | 268784208 | 1564053216.0000 | 2859322224 | 40 | NULL | |
root@192.168.30.20 | 1 | 1813933440 | 1813933440 | 1813933440.0000 | 1813933440 | 1179 | 1103 | |
clone_gtid_thread | 5 | 1461659760 | 8995536 | 292331952.0000 | 490881072 | 35 | NULL | |
srv_worker_thread | 2 | 115644144 | 53521248 | 57822072.0000 | 62122896 | 38 | NULL | |
io_read_thread | 2 | 85584576 | 39976992 | 42792288.0000 | 45607584 | 5 | NULL | |
srv_worker_thread | 2 | 71220864 | 7050384 | 35610432.0000 | 64170480 | 42 | NULL |
|