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 | 502 | 3350444020704 | 6674191128 | 276927100560 | 1308393504 | 87751981152 | 3261383646048 | 8 | 70656 | 8832.0000 | 285 | 288256 | 1011.4246 | |
innodb/innodb_data_file | 2464 | 2872490915184 | 1165783608 | 246859888176 | 203229937152 | 25876262544 | 2643384715488 | 1371 | 27574272 | 20112.5252 | 701 | 31670272 | 45178.7047 | |
innodb/innodb_temp_file | 190 | 415698315120 | 2187885744 | 37221783984 | 0 | 6178125888 | 409520189232 | 0 | 0 | 0.0000 | 126 | 2981888 | 23665.7778 | |
sql/binlog | 146 | 194681966688 | 1333438128 | 26330184144 | 602892048 | 745549200 | 193333525440 | 29 | 859 | 29.6207 | 13 | 2957 | 227.4615 | |
sql/binlog_index | 38 | 40841345952 | 1074772248 | 25226289792 | 428287200 | 0 | 40413058752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 31356179184 | 570112224 | 3804564720 | 16039297296 | 0 | 15316881888 | 33 | 3381415 | 102467.1212 | 0 | 0 | 0.0000 | |
sql/io_cache | 76 | 9636869616 | 126800784 | 7788069168 | 486282192 | 1041056016 | 8109531408 | 34 | 1855800 | 54582.3529 | 32 | 1855800 | 57993.7500 | |
sql/casetest | 15 | 851667696 | 56777688 | 766341312 | 0 | 0 | 851667696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 596326896 | 119265168 | 560220144 | 576318336 | 0 | 20008560 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 375203664 | 125067888 | 343525248 | 343525248 | 0 | 31678416 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 265574496 | 66393624 | 247611936 | 249629952 | 0 | 15944544 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 65132496 | 10855416 | 16564416 | 0 | 0 | 65132496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13321968 | 4440480 | 10891584 | 0 | 1792560 | 11529408 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 6953232 | 3476616 | 6687120 | 0 | 0 | 6953232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|