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 | 709 | 4452207632400 | 6279559176 | 276927100560 | 1308393504 | 120663561216 | 4330235677680 | 8 | 70656 | 8832.0000 | 410 | 377856 | 921.6000 | |
innodb/innodb_data_file | 2904 | 3394762626816 | 1168995168 | 246859888176 | 233081224992 | 30644628432 | 3131036773392 | 1516 | 29949952 | 19755.9050 | 917 | 38387712 | 41862.2814 | |
innodb/innodb_temp_file | 196 | 480387052992 | 2450954352 | 37221783984 | 0 | 6343652832 | 474043400160 | 0 | 0 | 0.0000 | 130 | 3178496 | 24449.9692 | |
sql/binlog | 164 | 279653320320 | 1705202928 | 26330184144 | 2692230816 | 1472584080 | 275488505424 | 31 | 867 | 27.9677 | 18 | 4817 | 267.6111 | |
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 | |
csv/metadata | 8 | 495448272 | 61930968 | 200712336 | 350674368 | 0 | 144773904 | 2 | 70 | 35.0000 | 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 | |
csv/data | 4 | 230702208 | 57675552 | 196476192 | 0 | 0 | 230702208 | 0 | 0 | 0.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 |
|