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 | 817 | 5576561921568 | 6825657168 | 909505135968 | 1408118976 | 46614888144 | 5528538914448 | 8 | 70656 | 8832.0000 | 475 | 472576 | 994.8968 | |
innodb/innodb_data_file | 2977 | 4335540950928 | 1456345440 | 270526406832 | 320869837200 | 58806462000 | 3955864651728 | 1475 | 29278208 | 19849.6325 | 1020 | 41533440 | 40719.0588 | |
innodb/innodb_temp_file | 271 | 1355959341264 | 5003539992 | 127711105632 | 0 | 243795043536 | 1112164297728 | 0 | 0 | 0.0000 | 172 | 6029312 | 35054.1395 | |
sql/binlog | 336 | 193172616384 | 574918344 | 23503733616 | 1482788736 | 2883772320 | 188806055328 | 77 | 1051 | 13.6494 | 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 |
|