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 | 2297 | 2670040407936 | 1162403088 | 286023770736 | 445798283568 | 43858195920 | 2180383928448 | 1386 | 27820032 | 20072.1732 | 579 | 27901952 | 48189.8998 | |
innodb/innodb_log_file | 433 | 2487781668240 | 5745454176 | 110100187824 | 1966099872 | 50787944064 | 2435027624304 | 8 | 70656 | 8832.0000 | 255 | 256512 | 1005.9294 | |
innodb/innodb_temp_file | 151 | 1005905695872 | 6661627104 | 43638274944 | 0 | 3942829440 | 1001962866432 | 0 | 0 | 0.0000 | 72 | 3080192 | 42780.4444 | |
sql/binlog | 703 | 174609318576 | 248377272 | 30798241584 | 1716715968 | 1395437472 | 171497165136 | 169 | 1272 | 7.5266 | 10 | 1854 | 185.4000 | |
sql/binlog_index | 38 | 105157814784 | 2767310832 | 52294202400 | 998612208 | 0 | 104159202576 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 36102183744 | 656403264 | 4059232320 | 20881041456 | 0 | 15221142288 | 33 | 3389231 | 102703.9697 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 2855190096 | 571037808 | 2835448176 | 2836673136 | 0 | 18516960 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 1462265376 | 182783040 | 744821616 | 1424615280 | 0 | 37650096 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 888030000 | 59202000 | 810897648 | 0 | 0 | 888030000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 221530320 | 73843440 | 208005600 | 208005600 | 0 | 13524720 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 31601856 | 10533864 | 18892368 | 0 | 10922208 | 20679648 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 24079968 | 12039984 | 12588576 | 0 | 0 | 24079968 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 16776144 | 4193904 | 9403152 | 0 | 0 | 16776144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|