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 | 596 | 3224038437840 | 5409460320 | 102523776432 | 1518118272 | 80124939312 | 3142395380256 | 8 | 70656 | 8832.0000 | 357 | 393728 | 1102.8796 | |
innodb/innodb_data_file | 2350 | 2567935119024 | 1092738240 | 240852355392 | 232156717056 | 40339004112 | 2295439397856 | 1308 | 26542080 | 20292.1101 | 699 | 31899648 | 45636.1202 | |
innodb/innodb_temp_file | 181 | 1153430986752 | 6372546840 | 315185863344 | 0 | 319545551952 | 833885434800 | 0 | 0 | 0.0000 | 100 | 3670016 | 36700.1600 | |
sql/binlog | 313 | 186036370608 | 594365376 | 37872024432 | 2856458352 | 2146417680 | 181033494576 | 71 | 880 | 12.3944 | 11 | 2939 | 267.1818 | |
sql/binlog_index | 38 | 42411867696 | 1116101712 | 22757886624 | 1687446288 | 0 | 40724421408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 28118840640 | 562376760 | 4481761152 | 14674775808 | 0 | 13444064832 | 30 | 3072706 | 102423.5333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3267058080 | 408382128 | 1703162208 | 2383439520 | 0 | 883618560 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1561358832 | 390339576 | 1443176064 | 0 | 0 | 1561358832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 796515984 | 53100960 | 707077536 | 0 | 0 | 796515984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 580085088 | 116016912 | 555559488 | 557613936 | 0 | 22471152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 302893536 | 100964424 | 291339840 | 291339840 | 0 | 11553696 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 91710432 | 18341928 | 32951424 | 0 | 0 | 91710432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46673616 | 15557784 | 35909808 | 0 | 8233104 | 38440512 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|