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 | 1178 | 6264517918900 | 5317926720 | 106629735400 | 934892970 | 144708905100 | 6118874120830 | 8 | 70656 | 8832.0000 | 710 | 814592 | 1147.3127 | |
innodb/innodb_data_file | 3553 | 5152746453600 | 1450252250 | 244354912120 | 284356661060 | 46385241720 | 4822004550820 | 1535 | 30261248 | 19714.1681 | 1362 | 52674560 | 38674.4200 | |
innodb/innodb_temp_file | 173 | 725482226170 | 4193538875 | 36584281380 | 0 | 63933367880 | 661548858290 | 0 | 0 | 0.0000 | 97 | 3293184 | 33950.3505 | |
sql/binlog | 802 | 584734758370 | 729095560 | 23836475990 | 1979780550 | 10415014100 | 572339963720 | 179 | 1459 | 8.1508 | 41 | 14159 | 345.3415 | |
sql/ERRMSG | 75 | 58124111020 | 774987995 | 3544194270 | 29823530890 | 0 | 28300580130 | 45 | 4609478 | 102432.8444 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 55559302690 | 1462086885 | 34599833650 | 1974518180 | 0 | 53584784510 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 82 | 10199136620 | 124379605 | 8245849180 | 175426290 | 1431624340 | 8592085990 | 38 | 2012512 | 52960.8421 | 34 | 2012512 | 59191.5294 | |
sql/misc | 11 | 1804257800 | 164023340 | 1542830000 | 0 | 0 | 1804257800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1535867390 | 307173425 | 1505513760 | 1508354560 | 0 | 27512830 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 914748730 | 114343525 | 468884110 | 717675120 | 0 | 197073610 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 764367060 | 50957645 | 695139520 | 0 | 0 | 764367060 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 645158930 | 161289600 | 628056890 | 630082020 | 0 | 15076910 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 261020760 | 87006920 | 248175150 | 248175150 | 0 | 12845610 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 62282950 | 20760895 | 37800130 | 0 | 21521180 | 40761770 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 31344730 | 7836050 | 11816350 | 0 | 0 | 31344730 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 3 | 29772220 | 9923985 | 22721630 | 0 | 0 | 29772220 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|