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 | 415 | 3161200607136 | 7617350664 | 702658584144 | 1459148592 | 127437961200 | 3032303497344 | 8 | 70656 | 8832.0000 | 230 | 227840 | 990.6087 | |
innodb/innodb_data_file | 2225 | 2354460387840 | 1058184336 | 260410094208 | 256841219184 | 26939881584 | 2070679287072 | 1323 | 26787840 | 20247.8005 | 574 | 27705344 | 48267.1498 | |
innodb/innodb_temp_file | 105 | 464543640000 | 4424224992 | 30940605168 | 0 | 3641666688 | 460901973312 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
sql/binlog | 387 | 107936009808 | 278904384 | 18991388064 | 905884848 | 1128565152 | 105901559808 | 91 | 960 | 10.5495 | 8 | 1917 | 239.6250 | |
sql/binlog_index | 38 | 53134159056 | 1398267288 | 30405174096 | 581688624 | 0 | 52552470432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 42175213872 | 648849432 | 2740245024 | 24770946288 | 0 | 17404267584 | 39 | 3991686 | 102350.9231 | 0 | 0 | 0.0000 | |
sql/io_cache | 188 | 6011203440 | 31974360 | 1956218880 | 584197680 | 2099816400 | 3327189360 | 64 | 3790168 | 59221.3750 | 74 | 3755176 | 50745.6216 | |
sql/casetest | 15 | 756694224 | 50446176 | 691358976 | 0 | 0 | 756694224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 620978688 | 124195632 | 585911040 | 599333856 | 0 | 21644832 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 266793648 | 88931040 | 254642784 | 254642784 | 0 | 12150864 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 199019040 | 66339504 | 174205680 | 0 | 0 | 199019040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48508416 | 16169472 | 38550336 | 0 | 7343424 | 41164992 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|