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 | 435 | 3284545069344 | 7550678256 | 702658584144 | 1459148592 | 127556812944 | 3155529107808 | 8 | 70656 | 8832.0000 | 242 | 233984 | 966.8760 | |
innodb/innodb_data_file | 2251 | 2428430770656 | 1078823064 | 260410094208 | 260913650976 | 27489540672 | 2140027579008 | 1327 | 26853376 | 20236.1537 | 588 | 28131328 | 47842.3946 | |
innodb/innodb_temp_file | 108 | 491292775776 | 4549006968 | 30940605168 | 0 | 3720018720 | 487572757056 | 0 | 0 | 0.0000 | 43 | 1687552 | 39245.3953 | |
sql/binlog | 411 | 108058752384 | 262916544 | 18991388064 | 922508928 | 1128565152 | 106007678304 | 97 | 984 | 10.1443 | 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 |
|