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 | 1027 | 5334106038096 | 5193871320 | 57127459488 | 1251466128 | 154521365856 | 5178333206112 | 8 | 70656 | 8832.0000 | 603 | 477696 | 792.1990 | |
innodb/innodb_data_file | 3246 | 3720906631200 | 1146305160 | 177507452496 | 290974961904 | 73323675216 | 3356607994080 | 1444 | 28770304 | 19924.0332 | 1295 | 50348032 | 38878.7892 | |
innodb/innodb_temp_file | 429 | 1117137468480 | 2604049800 | 34930062816 | 0 | 34679763360 | 1082457705120 | 0 | 0 | 0.0000 | 325 | 8863744 | 27273.0585 | |
sql/binlog_index | 38 | 54885724080 | 1444361160 | 37811737392 | 247417104 | 0 | 54638306976 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 40723789392 | 814475640 | 9484481424 | 24391641120 | 0 | 16332148272 | 30 | 3071856 | 102395.2000 | 0 | 0 | 0.0000 | |
sql/binlog | 241 | 34985650128 | 145168584 | 15424925472 | 1306618368 | 24588960 | 33654442800 | 57 | 824 | 14.4561 | 3 | 156 | 52.0000 | |
sql/io_cache | 93 | 3993979440 | 42945936 | 1914040128 | 155944272 | 1538288400 | 2299746768 | 40 | 2155332 | 53883.3000 | 38 | 2150958 | 56604.1579 | |
mysys/cnf | 5 | 2940380256 | 588075840 | 2920684800 | 2922087168 | 0 | 18293088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2285040912 | 142815024 | 718390992 | 2222459184 | 0 | 62581728 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 866976000 | 57798312 | 790178400 | 0 | 0 | 866976000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 495798864 | 123949584 | 440354640 | 440354640 | 0 | 55444224 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 88 | 316425120 | 3595680 | 238591056 | 249909264 | 0 | 66515856 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 271076256 | 90358752 | 256241040 | 256241040 | 0 | 14835216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 268563504 | 134281752 | 262550112 | 0 | 0 | 268563504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13808256 | 4602576 | 10735296 | 0 | 2341680 | 11466576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4238784 | 4238784 | 4238784 | 0 | 0 | 4238784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|