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 | 211 | 1094084452032 | 5185234296 | 88616485584 | 1464657744 | 31934953776 | 1060684840512 | 8 | 70656 | 8832.0000 | 119 | 113152 | 950.8571 | |
innodb/innodb_data_file | 1765 | 1076408473008 | 609862968 | 216016924992 | 245416165104 | 40935819408 | 790056488496 | 1280 | 26083328 | 20377.6000 | 278 | 18825216 | 67716.6043 | |
innodb/innodb_temp_file | 96 | 428204020992 | 4460458464 | 29796809328 | 0 | 2834584896 | 425369436096 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog_index | 38 | 52280884128 | 1375812504 | 31810602912 | 379883328 | 0 | 51901000800 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 97 | 37070963952 | 382174848 | 16373781600 | 936243792 | 46280784 | 36088439376 | 21 | 680 | 32.3810 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 13680718128 | 547228704 | 3720434784 | 6549511056 | 0 | 7131207072 | 15 | 1531208 | 102080.5333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 782074656 | 52138152 | 714263088 | 0 | 0 | 782074656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 707314080 | 141462816 | 682972224 | 684798048 | 0 | 22516032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 490237440 | 122559360 | 423382608 | 423382608 | 0 | 66854832 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 258325584 | 86108352 | 231950400 | 231950400 | 0 | 26375184 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48771360 | 16257120 | 37691808 | 0 | 8592672 | 40178688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 2 | 25324464 | 12662232 | 19603584 | 0 | 0 | 25324464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 15009984 | 15009984 | 15009984 | 0 | 0 | 15009984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|