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 | 1046 | 6863665443360 | 6561821640 | 860704525296 | 1816132032 | 245797470864 | 6616051840464 | 8 | 70656 | 8832.0000 | 608 | 460288 | 757.0526 | |
innodb/innodb_data_file | 3265 | 4474128700272 | 1370330280 | 257236156320 | 378223398960 | 75547342464 | 4020357958848 | 1477 | 29310976 | 19844.9397 | 1184 | 46415872 | 39202.5946 | |
innodb/innodb_temp_file | 110 | 531204338016 | 4829130240 | 38026740048 | 0 | 3753048288 | 527451289728 | 0 | 0 | 0.0000 | 43 | 1818624 | 42293.5814 | |
sql/binlog_index | 38 | 61740777648 | 1624757112 | 31685812752 | 689451312 | 0 | 61051326336 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 39399756528 | 875549928 | 10122740496 | 16659420624 | 0 | 22740335904 | 27 | 2771067 | 102632.1111 | 0 | 0 | 0.0000 | |
sql/binlog | 185 | 35931580080 | 194224536 | 16904237328 | 1033345632 | 46685760 | 34851548688 | 43 | 768 | 17.8605 | 3 | 156 | 52.0000 | |
csv/metadata | 8 | 6275712960 | 784464120 | 2583691440 | 2261038032 | 0 | 4014674928 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 3742722192 | 311893296 | 2688691632 | 3694253904 | 0 | 48468288 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 819821376 | 54654600 | 758420256 | 0 | 0 | 819821376 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 18 | 782708784 | 43483704 | 671130768 | 671130768 | 0 | 111578016 | 1 | 67 | 67.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 686051520 | 137210304 | 657139296 | 659318880 | 0 | 26732640 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 220974336 | 73658112 | 207788592 | 207788592 | 0 | 13185744 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 34 | 208762224 | 6139848 | 36468432 | 58250544 | 0 | 150511680 | 13 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18341664 | 6113712 | 14503104 | 0 | 3008016 | 15333648 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13800336 | 13800336 | 13800336 | 0 | 0 | 13800336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|