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 | 203 | 2966110818528 | 1500175776 | 14611383336.0000 | 141294807456 | 18 | NULL | |
page_flush_coordinator_thread | 722 | 766765285440 | 5480640 | 544825380.0000 | 49690499760 | 13 | NULL | |
io_write_thread | 65 | 756110926032 | 2177029536 | 11632475712.0000 | 30520813488 | 9 | NULL | |
log_checkpointer_thread | 58 | 478789642320 | 13205808 | 8254993824.0000 | 36090505968 | 15 | NULL | |
io_write_thread | 25 | 267860683200 | 1629140304 | 10714427328.0000 | 28782342336 | 11 | NULL | |
io_write_thread | 23 | 248514060960 | 1997347440 | 10804959000.0000 | 21989662464 | 10 | NULL | |
main | 148 | 107076356112 | 74976 | 443869107.0000 | 28859722320 | 1 | NULL | |
io_write_thread | 8 | 80595157632 | 2788206960 | 10074394704.0000 | 18052647360 | 12 | NULL | |
log_writer_thread | 316 | 64035833136 | 488928 | 202644816.0000 | 19368619776 | 20 | NULL | |
srv_purge_thread | 2 | 10911033936 | 908120400 | 5455516968.0000 | 10002913536 | 36 | NULL | |
srv_worker_thread | 3 | 2032824288 | 13273920 | 677608008.0000 | 1115099568 | 42 | NULL | |
clone_gtid_thread | 5 | 893605152 | 4260432 | 178720872.0000 | 328412304 | 35 | NULL | |
srv_worker_thread | 2 | 797804304 | 355824480 | 398902152.0000 | 441979824 | 40 | NULL | |
io_read_thread | 4 | 178899072 | 32611920 | 44724768.0000 | 59495568 | 5 | NULL | |
srv_worker_thread | 2 | 23673936 | 10973424 | 11836968.0000 | 12700512 | 38 | NULL |
|