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 | 153 | 3033574133568 | 1377556224 | 19827281760.0000 | 872643469632 | 18 | NULL | |
page_flush_coordinator_thread | 609 | 690307351536 | 3964752 | 596055768.0000 | 75378425760 | 13 | NULL | |
io_write_thread | 57 | 573304378944 | 1551418704 | 10057971528.0000 | 23616576720 | 9 | NULL | |
log_checkpointer_thread | 52 | 394054387056 | 10675632 | 7577968728.0000 | 24836997504 | 15 | NULL | |
io_write_thread | 25 | 282630192240 | 1708572624 | 11305207584.0000 | 32395805904 | 10 | NULL | |
io_write_thread | 17 | 209940994032 | 1532435520 | 12349470144.0000 | 26655682944 | 11 | NULL | |
main | 147 | 118399218960 | 70752 | 457836027.0000 | 31744155168 | 1 | NULL | |
log_writer_thread | 233 | 46894782000 | 644688 | 201265152.0000 | 8617997520 | 20 | NULL | |
srv_purge_thread | 2 | 8688739488 | 163269744 | 4344369744.0000 | 8525469744 | 36 | NULL | |
srv_worker_thread | 2 | 1835133696 | 7319664 | 917566848.0000 | 1827814032 | 40 | NULL | |
srv_worker_thread | 3 | 1015720464 | 16992624 | 338573400.0000 | 974182176 | 42 | NULL | |
clone_gtid_thread | 5 | 828557136 | 6161232 | 165711216.0000 | 310621872 | 35 | NULL | |
io_read_thread | 2 | 66109824 | 27584832 | 33054912.0000 | 38524992 | 5 | NULL |
|