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 | 1403 | 7829200558080 | 5580328248 | 43897336032 | 1369110864 | 200706835296 | 7627124611920 | 8 | 70656 | 8832.0000 | 842 | 1039360 | 1234.3943 | |
innodb/innodb_data_file | 3980 | 5894893096224 | 1481128704 | 248257719072 | 282356574720 | 81095469312 | 5531441052192 | 1596 | 31260672 | 19586.8872 | 1638 | 61456384 | 37519.1600 | |
innodb/innodb_temp_file | 108 | 564783091488 | 5229473040 | 70103249568 | 0 | 3083276064 | 561699815424 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | |
sql/binlog | 403 | 363479505312 | 901934088 | 26476846704 | 1763869008 | 4856340192 | 356859296112 | 88 | 1242 | 14.1136 | 25 | 7441 | 297.6400 | |
sql/binlog_index | 38 | 54705635424 | 1439621832 | 34237009488 | 964771104 | 0 | 53740864320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 20043378432 | 445408392 | 4455120912 | 10183862304 | 0 | 9859516128 | 27 | 2778735 | 102916.1111 | 0 | 0 | 0.0000 | |
myisam/dfile | 8310 | 6559131216 | 789096 | 1010088816 | 6339496416 | 0 | 219634800 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2200568832 | 137535552 | 734105856 | 2120517696 | 0 | 80051136 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 962895120 | 64192920 | 896677584 | 0 | 0 | 962895120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 7 | 726256608 | 103750944 | 644649984 | 0 | 0 | 726256608 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 457434912 | 91486824 | 437328144 | 438621744 | 0 | 18813168 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 235276800 | 78425424 | 219576192 | 219576192 | 0 | 15700608 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 60510912 | 20170128 | 40262112 | 0 | 17232864 | 43278048 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|