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 | 2480 | 12427555529664 | 5011110984 | 54719224032 | 1038616128 | 433526966400 | 11992989947136 | 8 | 70656 | 8832.0000 | 1567 | 2137600 | 1364.1353 | |
innodb/innodb_data_file | 3990 | 5922922704336 | 1484441640 | 173565092448 | 177951388032 | 89436167568 | 5655535148736 | 1388 | 28147712 | 20279.3314 | 1852 | 70172672 | 37890.2117 | |
sql/binlog | 765 | 3584214792576 | 4685247864 | 36954052080 | 1674106896 | 10044541056 | 3572496144624 | 60 | 21983 | 366.3833 | 262 | 86912 | 331.7252 | |
innodb/innodb_temp_file | 427 | 734163602832 | 1719352536 | 27807011232 | 0 | 4691570928 | 729472031904 | 0 | 0 | 0.0000 | 341 | 7946240 | 23302.7566 | |
sql/ERRMSG | 55 | 29294292192 | 532623432 | 4632072720 | 18078077424 | 0 | 11216214768 | 33 | 3381066 | 102456.5455 | 0 | 0 | 0.0000 | |
sql/io_cache | 426 | 21200401200 | 49766112 | 5897274768 | 980360832 | 3996740352 | 16223300016 | 192 | 10204838 | 53150.1979 | 174 | 10204838 | 58648.4943 | |
csv/data | 15 | 1602083472 | 106805424 | 1542745776 | 22022880 | 0 | 1580060592 | 6 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1375850784 | 275170104 | 1344589488 | 1346383632 | 0 | 29467152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 833385168 | 36234000 | 314752416 | 501179184 | 0 | 332205984 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 828849120 | 55256520 | 752770656 | 0 | 0 | 828849120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 349420896 | 87355224 | 234414576 | 234414576 | 0 | 115006320 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 193439136 | 64479624 | 176899008 | 176899008 | 0 | 16540128 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 114537984 | 12726384 | 30281328 | 0 | 0 | 114537984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 35578224 | 11859408 | 30471936 | 0 | 3877632 | 31700592 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|