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 | 377 | 5757473917008 | 56743104 | 15271813920.0000 | 265671232464 | 18 | NULL | |
page_flush_coordinator_thread | 1286 | 878320070496 | 3947328 | 407760540.0000 | 62132443296 | 13 | NULL | |
io_write_thread | 56 | 592252062864 | 1637598864 | 10575929496.0000 | 20359739664 | 9 | NULL | |
io_write_thread | 43 | 531215741760 | 1798117728 | 12353854392.0000 | 28640472432 | 10 | NULL | |
log_checkpointer_thread | 58 | 455856461280 | 11370480 | 7859594160.0000 | 30935893296 | 15 | NULL | |
io_write_thread | 16 | 249722521488 | 5169416736 | 15607657560.0000 | 40765864656 | 11 | NULL | |
log_writer_thread | 584 | 200043396960 | 482592 | 342540000.0000 | 39435304128 | 20 | NULL | |
main | 149 | 88725078288 | 73920 | 376574748.0000 | 28982271120 | 1 | NULL | |
io_write_thread | 4 | 26663439264 | 1549951392 | 6665859816.0000 | 11531080704 | 12 | NULL | |
srv_worker_thread | 1 | 1522372896 | 1522372896 | 1522372896.0000 | 1522372896 | 40 | NULL | |
srv_purge_thread | 2 | 973030608 | 236260464 | 486515304.0000 | 736770144 | 36 | NULL | |
clone_gtid_thread | 5 | 659772432 | 4758864 | 131954328.0000 | 237931584 | 35 | NULL | |
io_read_thread | 10 | 558196848 | 14560656 | 55819632.0000 | 343955568 | 5 | NULL | |
srv_worker_thread | 2 | 294433920 | 8855088 | 147216960.0000 | 285578832 | 42 | NULL | |
srv_worker_thread | 2 | 30705840 | 12950256 | 15352920.0000 | 17755584 | 38 | NULL |
|