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 | 2785 | 3093974798112 | 0 | 1110942360 | 272441499264 | 1517 | 29966336 | 19753.6823 | 872 | 37568512 | 43083.1560 | 67534848 | |
innodb/innodb_temp_file | 187 | 483310115376 | 0 | 2584546008 | 30937918704 | 0 | 0 | 0.0000 | 124 | 2883584 | 23254.7097 | 2883584 | |
sql/ERRMSG | 40 | 25961998128 | 3370752 | 649049808 | 2660720304 | 24 | 2453985 | 102249.3750 | 0 | 0 | 0.0000 | 2453985 | |
sql/io_cache | 38 | 1592304384 | 0 | 41902608 | 633580992 | 10 | 968558 | 96855.8000 | 18 | 968558 | 53808.7778 | 1937116 | |
innodb/innodb_log_file | 688 | 4054373009808 | 222288 | 5892983976 | 135693157248 | 8 | 70656 | 8832.0000 | 414 | 438784 | 1059.8647 | 509440 | |
mysys/charset | 3 | 274162944 | 1792560 | 91387560 | 260076960 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 275 | 169401130272 | 0 | 616003872 | 22818188976 | 62 | 844 | 13.6129 | 10 | 2951 | 295.1000 | 3795 | |
myisam/kfile | 4 | 540259632 | 467808 | 135064776 | 526864272 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 62767454112 | 0 | 1651774872 | 38291124960 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1424947392 | 614592 | 178118424 | 643473072 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 3195084288 | 619344 | 639016752 | 3161430624 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 44066880 | 2550768 | 14688960 | 33640464 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1039070736 | 0 | 69271224 | 971360544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 742803072 | 0 | 247600848 | 485995488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 346693248 | 0 | 86673312 | 321675552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 7088400 | 366432 | 3544200 | 6721968 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|