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 | 947 | 5346755052672 | 5645992440 | 98320923360 | 1339622592 | 117190603728 | 5228224826352 | 8 | 70656 | 8832.0000 | 557 | 501248 | 899.9066 | |
innodb/innodb_data_file | 3094 | 3477477614688 | 1123942248 | 220708028112 | 282649133184 | 59627023104 | 3135201458400 | 1509 | 29835264 | 19771.5467 | 1136 | 45760512 | 40282.1408 | |
innodb/innodb_temp_file | 302 | 1828469602080 | 6054535080 | 913424651568 | 0 | 925036245936 | 903433356144 | 0 | 0 | 0.0000 | 216 | 5898240 | 27306.6667 | |
sql/binlog | 307 | 117959571840 | 384232992 | 20437034112 | 1558472256 | 2589393840 | 113811705744 | 71 | 880 | 12.3944 | 8 | 1530 | 191.2500 | |
sql/binlog_index | 38 | 63511642656 | 1671358920 | 38387382000 | 865843440 | 0 | 62645799216 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 33195460848 | 663909048 | 4287739104 | 16999731936 | 0 | 16195728912 | 30 | 3082764 | 102758.8000 | 0 | 0 | 0.0000 | |
sql/io_cache | 96 | 8406953280 | 87572232 | 6560282256 | 377284512 | 1215274896 | 6814393872 | 48 | 2272324 | 47340.0833 | 38 | 2272324 | 59798.0000 | |
csv/metadata | 8 | 2503386336 | 312923160 | 1492409952 | 883841904 | 0 | 1619544432 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 732416256 | 146483040 | 707747040 | 709981008 | 0 | 22435248 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 725079168 | 48338400 | 663415632 | 0 | 0 | 725079168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 515696016 | 128923872 | 478974144 | 0 | 0 | 515696016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 262134576 | 87378192 | 247961472 | 247961472 | 0 | 14173104 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 55049280 | 18349584 | 34053888 | 0 | 17920320 | 37128960 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 49702224 | 16567320 | 30396432 | 0 | 0 | 49702224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|