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 | 521 | 7768907613456 | 57330768 | 14911530744.0000 | 373293279744 | 18 | NULL | |
page_flush_coordinator_thread | 1807 | 1862801028000 | 3636864 | 537926004.0000 | 52016313888 | 13 | NULL | |
io_write_thread | 159 | 1564292950176 | 1617286176 | 9838320360.0000 | 34167319296 | 9 | NULL | |
log_checkpointer_thread | 152 | 1108481353056 | 9847200 | 7292640432.0000 | 30672256032 | 15 | NULL | |
io_write_thread | 87 | 906146659968 | 70557696 | 10415478744.0000 | 37860380448 | 10 | NULL | |
log_writer_thread | 771 | 302412249744 | 466752 | 392233776.0000 | 106609912992 | 20 | NULL | |
io_write_thread | 27 | 265159739856 | 1595896896 | 9820731096.0000 | 20248787856 | 12 | NULL | |
io_write_thread | 23 | 201051055920 | 1637600976 | 8741350200.0000 | 20684086896 | 11 | NULL | |
root@192.168.30.20 | 49 | 149920594032 | 291984 | 3059603712.0000 | 144380810112 | 2739 | 2475 | |
main | 150 | 102773312400 | 75504 | 407531124.0000 | 23095689408 | 1 | NULL | |
srv_purge_thread | 3 | 4187813520 | 228590208 | 1395937752.0000 | 3652325424 | 36 | NULL | |
srv_worker_thread | 1 | 1931873856 | 1931873856 | 1931873856.0000 | 1931873856 | 40 | NULL | |
clone_gtid_thread | 4 | 616587840 | 6735696 | 154146960.0000 | 309110736 | 35 | NULL | |
io_read_thread | 7 | 253874016 | 27482928 | 36267528.0000 | 56066208 | 5 | NULL | |
srv_worker_thread | 2 | 32074944 | 8798064 | 16037472.0000 | 23276880 | 38 | NULL | |
srv_worker_thread | 2 | 26256384 | 8884656 | 13128192.0000 | 17371728 | 42 | NULL |
|