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 | 708 | 4708483967088 | 6650401032 | 886357028832 | 1090735536 | 109193466096 | 4598199765456 | 8 | 70656 | 8832.0000 | 411 | 339456 | 825.9270 | |
innodb/innodb_data_file | 2794 | 2728273490448 | 976475808 | 255052925424 | 300833854992 | 30781649712 | 2396657985744 | 1517 | 29966336 | 19753.6823 | 854 | 36782080 | 43070.3513 | |
innodb/innodb_temp_file | 339 | 751188838752 | 2215896144 | 46263986208 | 0 | 61930703472 | 689258135280 | 0 | 0 | 0.0000 | 266 | 5865472 | 22050.6466 | |
sql/io_cache | 140 | 94389085824 | 674207688 | 92002618752 | 296558592 | 1472731920 | 92619795312 | 64 | 3257960 | 50905.6250 | 56 | 3257960 | 58177.8571 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 237 | 42818608800 | 180669192 | 19495037232 | 1216018848 | 76851456 | 41525738496 | 56 | 820 | 14.6429 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 60 | 35671948752 | 594532224 | 3930899808 | 18037972656 | 0 | 17633976096 | 36 | 3694649 | 102629.1389 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4205834160 | 525729072 | 2253383088 | 1788136944 | 0 | 2417697216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1655208720 | 137933928 | 644688000 | 1610470752 | 0 | 44737968 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 34 | 1072532736 | 31544832 | 771527328 | 1042588800 | 0 | 29943936 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 779265696 | 51950976 | 715726704 | 0 | 0 | 779265696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 708786672 | 141757176 | 688565328 | 690146160 | 0 | 18640512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290792832 | 96930768 | 274138128 | 274138128 | 0 | 16654704 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 54821712 | 18273816 | 35330064 | 0 | 16422912 | 38398800 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 6 | 38337024 | 6389328 | 13111296 | 5442624 | 0 | 32894400 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13226928 | 13226928 | 13226928 | 0 | 0 | 13226928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|