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 | 283 | 3676279235904 | 71970096 | 12990385848.0000 | 38203678128 | 18 | NULL | |
page_flush_coordinator_thread | 1264 | 1168874960880 | 4296336 | 807213396.0000 | 73640725488 | 13 | NULL | |
io_write_thread | 69 | 817118249904 | 1847186880 | 11842293408.0000 | 27980855232 | 9 | NULL | |
log_checkpointer_thread | 70 | 533533864512 | 8507664 | 7621912320.0000 | 26161040928 | 15 | NULL | |
io_write_thread | 27 | 398475825792 | 1646219520 | 14758363752.0000 | 35958215040 | 10 | NULL | |
io_write_thread | 16 | 177032232432 | 1610933808 | 11064514296.0000 | 20788591296 | 11 | NULL | |
main | 148 | 107452950000 | 77088 | 418342782.0000 | 28360815648 | 1 | NULL | |
log_writer_thread | 452 | 87051361584 | 514800 | 192591432.0000 | 11598730176 | 20 | NULL | |
io_write_thread | 7 | 82410363552 | 6280767504 | 11772908928.0000 | 18895063968 | 12 | NULL | |
srv_purge_thread | 2 | 2282892480 | 198068112 | 1141446240.0000 | 2084824368 | 36 | NULL | |
srv_worker_thread | 2 | 1102853664 | 14825712 | 551426832.0000 | 1088027952 | 38 | NULL | |
clone_gtid_thread | 5 | 974284608 | 5306400 | 194856816.0000 | 335834400 | 35 | NULL | |
io_read_thread | 12 | 606624480 | 17053872 | 50552040.0000 | 321813360 | 5 | NULL | |
srv_worker_thread | 1 | 34642608 | 34642608 | 34642608.0000 | 34642608 | 40 | NULL | |
srv_worker_thread | 2 | 19555536 | 8668704 | 9777768.0000 | 10886832 | 42 | NULL |
|