SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 3416 | 5923116526800 | 0 | 1733933256 | 249015879552 | 1481 | 29376512 | 19835.5922 | 1248 | 47333376 | 37927.3846 | 76709888 | |
sql/ERRMSG | 75 | 64194236832 | 2752464 | 855923112 | 12219940128 | 45 | 4608216 | 102404.8000 | 0 | 0 | 0.0000 | 4608216 | |
innodb/innodb_temp_file | 141 | 757747274592 | 0 | 5374094088 | 41033392224 | 0 | 0 | 0.0000 | 65 | 2768896 | 42598.4000 | 2768896 | |
sql/io_cache | 15 | 584218800 | 0 | 38947920 | 321264768 | 4 | 278912 | 69728.0000 | 6 | 274538 | 45756.3333 | 553450 | |
innodb/innodb_log_file | 1090 | 6655675804272 | 236016 | 6106124376 | 55243094016 | 8 | 70656 | 8832.0000 | 619 | 457216 | 738.6365 | 527872 | |
mysys/charset | 3 | 299744016 | 2241360 | 99914496 | 285890352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 481 | 52109108304 | 0 | 108334776 | 18634366080 | 117 | 1064 | 9.0940 | 3 | 156 | 52.0000 | 1220 | |
myisam/kfile | 8 | 2080711776 | 641520 | 260088840 | 1728404304 | 4 | 854 | 213.5000 | 0 | 0 | 0.0000 | 854 | |
sql/binlog_index | 38 | 54051888000 | 0 | 1422418008 | 35907392400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 971590752 | 463056 | 121448712 | 634352928 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 5931128544 | 281952 | 1186225656 | 5909642640 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 26496096 | 1514304 | 8831856 | 20144256 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 948474384 | 0 | 63231432 | 878210256 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12678336 | 0 | 12678336 | 12678336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 45 | 245112912 | 0 | 5446848 | 33681120 | 18 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 38002800 | 282480 | 9500568 | 29517840 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|