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 | 783 | 5374002531216 | 6863349240 | 909505135968 | 1408118976 | 46206933168 | 5326387479072 | 8 | 70656 | 8832.0000 | 456 | 461312 | 1011.6491 | |
innodb/innodb_data_file | 2923 | 4086801116640 | 1398152712 | 270526406832 | 317905553856 | 57200872080 | 3711694690704 | 1470 | 29196288 | 19861.4204 | 991 | 40747008 | 41117.0616 | |
innodb/innodb_temp_file | 259 | 1286685254448 | 4967896560 | 127711105632 | 0 | 243468761712 | 1043216492736 | 0 | 0 | 0.0000 | 164 | 5636096 | 34366.4390 | |
sql/binlog | 300 | 192976425312 | 643254744 | 23503733616 | 1457443152 | 2883772320 | 188635209840 | 68 | 1015 | 14.9265 | 12 | 2947 | 245.5833 | |
sql/ERRMSG | 70 | 54571599984 | 779594112 | 3329231136 | 28003381296 | 0 | 26568218688 | 42 | 4293041 | 102215.2619 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 51795348528 | 1363035432 | 29991683040 | 1049469696 | 0 | 50745878832 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 74 | 25830464880 | 349060272 | 24177289488 | 165173184 | 1111217184 | 24554074512 | 32 | 1847552 | 57736.0000 | 32 | 1847552 | 57736.0000 | |
mysys/cnf | 5 | 2583015072 | 516602856 | 2563330704 | 2564542464 | 0 | 18472608 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 942521712 | 235630296 | 898491792 | 904185216 | 0 | 38336496 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 840500496 | 56033208 | 776593488 | 0 | 0 | 840500496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 232 | 470592672 | 2028312 | 306922704 | 380439312 | 0 | 90153360 | 150 | 8919 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 303347616 | 101115696 | 280915008 | 280915008 | 0 | 22432608 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 95036832 | 15839472 | 31951392 | 0 | 0 | 95036832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46747536 | 15582336 | 36608352 | 0 | 7299600 | 39447936 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|