SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 453 | 2242595068032 | 4950540936 | 38132296224 | 1302877488 | 53138835552 | 2188153354992 | 8 | 70656 | 8832.0000 | 267 | 248832 | 931.9551 | |
innodb/innodb_data_file | 2229 | 1897361627040 | 851216520 | 232346465472 | 238076984640 | 28426886400 | 1630857756000 | 1349 | 27213824 | 20173.3314 | 623 | 29736960 | 47731.8780 | |
innodb/innodb_temp_file | 275 | 1589681201328 | 5780658840 | 44883084048 | 0 | 7783834608 | 1581897366720 | 0 | 0 | 0.0000 | 152 | 7274496 | 47858.5263 | |
sql/binlog_index | 38 | 52503089760 | 1381660104 | 30889038048 | 1748080752 | 0 | 50755009008 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 441 | 52047647520 | 118021728 | 18369960576 | 992796816 | 558045312 | 50496805392 | 108 | 1322 | 12.2407 | 4 | 456 | 114.0000 | |
sql/ERRMSG | 75 | 47348733168 | 631316400 | 5501758944 | 22746456480 | 0 | 24602276688 | 45 | 4607863 | 102396.9556 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 2633589024 | 219465576 | 2025463440 | 2594949456 | 0 | 38639568 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1356138432 | 90409176 | 1291507536 | 0 | 0 | 1356138432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1275890880 | 159486360 | 515978496 | 909990048 | 0 | 365900832 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 711812112 | 142362264 | 690599712 | 692234928 | 0 | 19577184 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 304240464 | 101413488 | 290891568 | 290891568 | 0 | 13348896 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 272835552 | 68208888 | 200007984 | 0 | 0 | 272835552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48020016 | 16006584 | 37561920 | 0 | 7667088 | 40352928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 6 | 23768448 | 3961320 | 7897824 | 0 | 0 | 23768448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13530000 | 13530000 | 13530000 | 0 | 0 | 13530000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|