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 | 1690 | 20716235289552 | 48555936 | 12258127200.0000 | 703004902512 | 18 | NULL | |
page_flush_coordinator_thread | 5953 | 2670060349968 | 3405072 | 247345692.0000 | 41641953936 | 13 | NULL | |
io_write_thread | 148 | 1383037215120 | 1530243264 | 9344846016.0000 | 35545428864 | 10 | NULL | |
io_write_thread | 154 | 1340666252640 | 1515714816 | 8705624928.0000 | 30462248256 | 9 | NULL | |
log_checkpointer_thread | 106 | 771237428016 | 8717280 | 7275824688.0000 | 101544580368 | 15 | NULL | |
io_write_thread | 55 | 604949446464 | 1533922368 | 10999080840.0000 | 117729340080 | 11 | NULL | |
log_writer_thread | 2725 | 567574100544 | 525360 | 208283856.0000 | 11309722512 | 20 | NULL | |
io_write_thread | 50 | 440931249264 | 1494147600 | 8818624848.0000 | 32055317184 | 12 | NULL | |
main | 149 | 95049828720 | 74976 | 407662860.0000 | 26931266208 | 1 | NULL | |
srv_purge_thread | 3 | 4331783280 | 183343776 | 1443927672.0000 | 3813973680 | 36 | NULL | |
srv_worker_thread | 2 | 577924512 | 7755792 | 288962256.0000 | 570168720 | 42 | NULL | |
clone_gtid_thread | 4 | 455854080 | 5932608 | 113963520.0000 | 222505536 | 35 | NULL | |
io_read_thread | 8 | 212866896 | 18089280 | 26608296.0000 | 49304112 | 5 | NULL | |
srv_worker_thread | 2 | 22490160 | 8439024 | 11245080.0000 | 14051136 | 38 | NULL |
|