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 | 2511 | 10736633784096 | 4275839568 | 76510713840 | 1251466128 | 357254378448 | 10378127939520 | 8 | 70656 | 8832.0000 | 1668 | 2577920 | 1545.5156 | |
innodb/innodb_data_file | 4339 | 5055431451840 | 1165114368 | 177507452496 | 319661606880 | 98916605040 | 4636853239920 | 1492 | 29556736 | 19810.1448 | 2020 | 73285632 | 36280.0158 | |
innodb/innodb_temp_file | 632 | 1349746826208 | 2135675256 | 51915861888 | 0 | 36242110080 | 1313504716128 | 0 | 0 | 0.0000 | 518 | 12681216 | 24481.1120 | |
sql/binlog | 347 | 507658845936 | 1462993752 | 48729560352 | 1691967552 | 4794112224 | 501172766160 | 67 | 864 | 12.8955 | 36 | 7017 | 194.9167 | |
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/io_cache | 380 | 25740461472 | 67737912 | 7723138368 | 762026496 | 5228400144 | 19750034832 | 149 | 9428006 | 63275.2081 | 166 | 9423632 | 56768.8675 | |
mysys/cnf | 5 | 2940380256 | 588075840 | 2920684800 | 2922087168 | 0 | 18293088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 2797725744 | 116571840 | 718390992 | 2222459184 | 0 | 575266560 | 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 | 98 | 379383312 | 3871032 | 238591056 | 249909264 | 0 | 129474048 | 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/misc | 3 | 26265360 | 8755032 | 11039952 | 0 | 0 | 26265360 | 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 |
|