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 | 737 | 4594272934944 | 6233748840 | 179520252912 | 1750027488 | 94137139536 | 4498385767920 | 8 | 70656 | 8832.0000 | 439 | 526336 | 1198.9431 | |
innodb/innodb_data_file | 2437 | 3638436734064 | 1492998144 | 232023574992 | 210271280736 | 42624966912 | 3385540486416 | 1272 | 25952256 | 20402.7170 | 741 | 33112064 | 44685.6464 | |
innodb/innodb_temp_file | 117 | 512592632112 | 4381133592 | 25462147920 | 0 | 3069248160 | 509523383952 | 0 | 0 | 0.0000 | 49 | 1982464 | 40458.4490 | |
sql/binlog | 169 | 248425253472 | 1469971800 | 21164678832 | 857623008 | 1002298176 | 246565332288 | 34 | 1026 | 30.1765 | 16 | 5850 | 365.6250 | |
sql/binlog_index | 38 | 53934731664 | 1419335016 | 34961213232 | 361840512 | 0 | 53572891152 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 42336786624 | 769759584 | 6290812704 | 18868431120 | 0 | 23468355504 | 33 | 3378955 | 102392.5758 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1657101600 | 331420320 | 1640696112 | 1641838704 | 0 | 15262896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 772219536 | 193054752 | 653151312 | 653151312 | 0 | 119068224 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 725734416 | 48382224 | 662945184 | 0 | 0 | 725734416 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 259589616 | 86529696 | 245762880 | 245762880 | 0 | 13826736 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 61855728 | 15463800 | 27958656 | 0 | 0 | 61855728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 50589792 | 16863264 | 40192416 | 0 | 7314912 | 43274880 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 6 | 42932208 | 7155192 | 21247776 | 23865072 | 0 | 19067136 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|