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 | 91 | 1196626063776 | 147466704 | 13149736776.0000 | 70169486640 | 18 | NULL | |
io_write_thread | 35 | 374895336288 | 2404437552 | 10711295232.0000 | 21884140608 | 9 | NULL | |
page_flush_coordinator_thread | 354 | 299682118560 | 4580400 | 653441448.0000 | 58690980480 | 13 | NULL | |
log_checkpointer_thread | 26 | 181967810112 | 12347280 | 6998761704.0000 | 21619635840 | 15 | NULL | |
main | 150 | 111247033392 | 75504 | 435122292.0000 | 32081871888 | 1 | NULL | |
io_write_thread | 7 | 72638160144 | 1711620768 | 10376879832.0000 | 16711497792 | 10 | NULL | |
log_writer_thread | 144 | 67386354288 | 578688 | 467960592.0000 | 38700985488 | 20 | NULL | |
io_write_thread | 3 | 27000159648 | 2598789600 | 9000053040.0000 | 13166929776 | 11 | NULL | |
root@192.168.30.20 | 5 | 5398704960 | 18301008 | 1079740992.0000 | 2245786752 | 1377 | 1241 | |
srv_worker_thread | 1 | 1861246464 | 1861246464 | 1861246464.0000 | 1861246464 | 40 | NULL | |
clone_gtid_thread | 5 | 1042581408 | 10766448 | 208516176.0000 | 345558576 | 35 | NULL | |
io_read_thread | 13 | 537388896 | 24913680 | 41337384.0000 | 81305136 | 5 | NULL | |
root@192.168.30.20 | 1 | 312088128 | 312088128 | 312088128.0000 | 312088128 | 1379 | 1243 | |
srv_purge_thread | 1 | 235810608 | 235810608 | 235810608.0000 | 235810608 | 36 | NULL | |
srv_worker_thread | 3 | 54520752 | 8171328 | 18173496.0000 | 23775840 | 42 | NULL | |
srv_worker_thread | 2 | 40319664 | 8412624 | 20159832.0000 | 31907040 | 38 | NULL |
|