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 | 2094 | 26994272412624 | 57299088 | 12891247512.0000 | 919435474320 | 18 | NULL | |
page_flush_coordinator_thread | 6252 | 3721530475872 | 3341184 | 312366516.0000 | 58509813648 | 13 | NULL | |
io_write_thread | 184 | 1666375492848 | 136557696 | 9056388528.0000 | 32615732160 | 9 | NULL | |
log_writer_thread | 3510 | 1613148995040 | 473088 | 459586512.0000 | 711319596240 | 20 | NULL | |
log_checkpointer_thread | 160 | 1074069157392 | 7228320 | 6712932072.0000 | 22708278912 | 15 | NULL | |
io_write_thread | 97 | 1019673612672 | 1468708560 | 10512099048.0000 | 39316876896 | 12 | NULL | |
io_write_thread | 105 | 962828909856 | 1574404656 | 9169798968.0000 | 26090005920 | 10 | NULL | |
root@192.168.30.20 | 136 | 812122266912 | 1056000 | 6419023248.0000 | 34354871232 | 7217 | 6541 | |
io_write_thread | 61 | 489808814880 | 1462474992 | 8029652664.0000 | 28826125152 | 11 | NULL | |
main | 148 | 97694902272 | 71808 | 404394804.0000 | 29062866096 | 1 | NULL | |
srv_purge_thread | 5 | 16390796928 | 177922272 | 3278159280.0000 | 4584219024 | 36 | NULL | |
srv_worker_thread | 2 | 1263762720 | 9111168 | 631881360.0000 | 1254651552 | 42 | NULL | |
clone_gtid_thread | 5 | 1076527584 | 11307648 | 215305464.0000 | 371720976 | 35 | NULL | |
io_read_thread | 14 | 435747840 | 20808480 | 31124808.0000 | 50307312 | 5 | NULL | |
srv_worker_thread | 2 | 20639520 | 9105888 | 10319760.0000 | 11533632 | 38 | NULL |
|