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 | 367 | 1927582156896 | 5252267328 | 32772645840 | 1039289328 | 39638255712 | 1886904611856 | 8 | 70656 | 8832.0000 | 211 | 253952 | 1203.5640 | |
innodb/innodb_data_file | 2192 | 1697385137184 | 774354504 | 189355468896 | 180047786160 | 32695999776 | 1484641351248 | 1368 | 28606464 | 20911.1579 | 441 | 23871488 | 54130.3583 | |
innodb/innodb_temp_file | 181 | 739259361456 | 4084305720 | 28535898864 | 0 | 3658909056 | 735600452400 | 0 | 0 | 0.0000 | 94 | 3964928 | 42180.0851 | |
sql/binlog | 421 | 92088848544 | 218738256 | 16857269616 | 7206421728 | 1734341664 | 83148085152 | 106 | 71865 | 677.9717 | 7 | 1302 | 186.0000 | |
sql/ERRMSG | 60 | 62066652912 | 1034444136 | 19049263200 | 26369113584 | 0 | 35697539328 | 36 | 3694825 | 102634.0278 | 0 | 0 | 0.0000 | |
sql/io_cache | 258 | 12075051648 | 46802448 | 2791029648 | 587168208 | 4039014144 | 7448869296 | 112 | 6128264 | 54716.6429 | 106 | 6128264 | 57813.8113 | |
sql/binlog_index | 23 | 1905983376 | 82868808 | 1276998096 | 226020960 | 0 | 1679962416 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 814425216 | 54294768 | 713752512 | 0 | 0 | 814425216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 471800736 | 78633456 | 266141040 | 269329632 | 0 | 202471104 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 271732032 | 67933008 | 194608128 | 194608128 | 0 | 77123904 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 231193248 | 77064240 | 206145456 | 206145456 | 0 | 25047792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 209423280 | 41884656 | 184578768 | 186120000 | 0 | 23303280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 167170080 | 83585040 | 162687888 | 0 | 0 | 167170080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48384864 | 16128288 | 37736688 | 0 | 7765824 | 40619040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|