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 | 1098 | 13838042286288 | 44129184 | 12602952648.0000 | 65656160064 | 18 | NULL | |
page_flush_coordinator_thread | 3880 | 2713689911856 | 3418800 | 371435856.0000 | 131637686928 | 13 | NULL | |
io_write_thread | 179 | 1620664130448 | 1528584816 | 9053989296.0000 | 25889855376 | 9 | NULL | |
log_checkpointer_thread | 179 | 1276450140240 | 6642768 | 7141515348.0000 | 32951335296 | 15 | NULL | |
io_write_thread | 119 | 1023853204176 | 1496377872 | 8603808312.0000 | 31836257376 | 10 | NULL | |
io_write_thread | 77 | 640470012864 | 1490320128 | 8317792296.0000 | 26163410064 | 11 | NULL | |
io_write_thread | 44 | 452217025920 | 1666574976 | 10277659656.0000 | 28737257472 | 12 | NULL | |
log_writer_thread | 1713 | 384734096208 | 488400 | 224596416.0000 | 12307261296 | 20 | NULL | |
main | 149 | 133208627376 | 76032 | 506310189.0000 | 34599758688 | 1 | NULL | |
srv_purge_thread | 3 | 1445411088 | 199082928 | 481803696.0000 | 991926672 | 36 | NULL | |
clone_gtid_thread | 5 | 1006780368 | 6318048 | 201355968.0000 | 348334272 | 35 | NULL | |
io_read_thread | 23 | 835471824 | 18957312 | 36324816.0000 | 148582368 | 5 | NULL | |
srv_worker_thread | 2 | 297219120 | 9322896 | 148609560.0000 | 287896224 | 40 | NULL | |
srv_worker_thread | 2 | 202794240 | 18698064 | 101397120.0000 | 184096176 | 42 | NULL |
|