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 | 274 | 3948204544944 | 91471776 | 14409505440.0000 | 274770808224 | 18 | NULL | |
page_flush_coordinator_thread | 1008 | 667257310368 | 4701840 | 349249692.0000 | 45659863392 | 13 | NULL | |
io_write_thread | 44 | 454546337520 | 1458758928 | 10330598520.0000 | 22041977760 | 9 | NULL | |
log_checkpointer_thread | 50 | 331124968944 | 13178352 | 6622499136.0000 | 19428695088 | 15 | NULL | |
io_write_thread | 30 | 314766621312 | 1638963744 | 10492220640.0000 | 23925685344 | 10 | NULL | |
io_write_thread | 20 | 241732697184 | 1618349568 | 12086634648.0000 | 37464451728 | 12 | NULL | |
log_writer_thread | 426 | 173584907760 | 494208 | 407476080.0000 | 111565439568 | 20 | NULL | |
io_write_thread | 12 | 122386667040 | 1659723120 | 10198888920.0000 | 27818572848 | 11 | NULL | |
main | 146 | 94290161328 | 117744 | 376551681.0000 | 35059058496 | 1 | NULL | |
srv_purge_thread | 2 | 4018144416 | 281015856 | 2009072208.0000 | 3737128560 | 36 | NULL | |
clone_gtid_thread | 5 | 948520320 | 11038896 | 189704064.0000 | 345500496 | 35 | NULL | |
srv_worker_thread | 1 | 568330224 | 568330224 | 568330224.0000 | 568330224 | 40 | NULL | |
srv_worker_thread | 2 | 352714560 | 10312368 | 176357280.0000 | 342402192 | 42 | NULL | |
io_read_thread | 1 | 34185888 | 34185888 | 34185888.0000 | 34185888 | 5 | NULL | |
srv_worker_thread | 1 | 25469136 | 25469136 | 25469136.0000 | 25469136 | 38 | NULL |
|