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_data_file | 2198 | 3236166634272 | 1472323248 | 865909180752 | 1131929732736 | 29436107184 | 2074800794352 | 1351 | 27246592 | 20167.7217 | 539 | 26886144 | 49881.5288 | |
innodb/innodb_log_file | 355 | 1849769589888 | 5210618424 | 55907680224 | 1665183696 | 23971198944 | 1824133207248 | 8 | 70656 | 8832.0000 | 203 | 185344 | 913.0246 | |
innodb/innodb_temp_file | 133 | 615330591216 | 4626545616 | 23698900896 | 0 | 3111441168 | 612219150048 | 0 | 0 | 0.0000 | 59 | 2539520 | 43042.7119 | |
sql/binlog | 632 | 70950289872 | 112263096 | 24297593760 | 1637060832 | 4321443456 | 64991785584 | 155 | 1363 | 8.7935 | 4 | 350 | 87.5000 | |
sql/binlog_index | 38 | 55160528016 | 1451592648 | 29829081744 | 1867154256 | 0 | 53293373760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 43715227248 | 794822160 | 9354486768 | 21462538416 | 0 | 22252688832 | 33 | 3380023 | 102424.9394 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1664522112 | 208065264 | 1081908960 | 1305404496 | 0 | 359117616 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 942445680 | 62829624 | 875809440 | 0 | 0 | 942445680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 728736096 | 145747008 | 703686720 | 705852048 | 0 | 22884048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 331105104 | 165552552 | 314600352 | 0 | 0 | 331105104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 294997824 | 98332608 | 269738304 | 269738304 | 0 | 25259520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 69275712 | 17318928 | 38932608 | 0 | 0 | 69275712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55510224 | 18503232 | 36900336 | 0 | 15727536 | 39782688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|