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 | 325 | 4227998750448 | 45632928 | 13009226736.0000 | 65656160064 | 18 | NULL | |
page_flush_coordinator_thread | 1236 | 829115541936 | 3418800 | 356660436.0000 | 34527314448 | 13 | NULL | |
io_write_thread | 62 | 586538451312 | 1537801056 | 9460297440.0000 | 25064968368 | 9 | NULL | |
log_checkpointer_thread | 72 | 500095729056 | 9752688 | 6945774000.0000 | 21985050912 | 15 | NULL | |
io_write_thread | 46 | 418066088352 | 1496377872 | 9088392984.0000 | 22665670896 | 10 | NULL | |
io_write_thread | 18 | 198447981600 | 1502932464 | 11024887632.0000 | 26163410064 | 11 | NULL | |
io_write_thread | 16 | 197107524768 | 1695239040 | 12319220232.0000 | 25848349824 | 12 | NULL | |
main | 149 | 133208627376 | 76032 | 506310189.0000 | 34599758688 | 1 | NULL | |
log_writer_thread | 502 | 119172267456 | 488400 | 237394872.0000 | 7997966064 | 20 | NULL | |
clone_gtid_thread | 5 | 1006780368 | 6318048 | 201355968.0000 | 348334272 | 35 | NULL | |
io_read_thread | 20 | 719485008 | 18957312 | 35974224.0000 | 148582368 | 5 | NULL | |
srv_purge_thread | 2 | 453484416 | 199082928 | 226742208.0000 | 254401488 | 36 | NULL | |
srv_worker_thread | 2 | 297219120 | 9322896 | 148609560.0000 | 287896224 | 40 | NULL | |
srv_worker_thread | 2 | 202794240 | 18698064 | 101397120.0000 | 184096176 | 42 | NULL |
|