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 | 3665 | 5023034325936 | 0 | 1370541216 | 260930042736 | 1304 | 26476544 | 20304.0982 | 1864 | 68403200 | 36696.9957 | 94879744 | |
sql/ERRMSG | 65 | 37636970976 | 2812128 | 579030144 | 5902461312 | 39 | 3988885 | 102279.1026 | 0 | 0 | 0.0000 | 3988885 | |
innodb/innodb_temp_file | 126 | 598216865136 | 0 | 4747752768 | 41151824208 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | 2326528 | |
innodb/innodb_log_file | 1708 | 9204470382096 | 236544 | 5389034112 | 64113849360 | 8 | 70656 | 8832.0000 | 1023 | 813568 | 795.2766 | 884224 | |
mysys/charset | 3 | 344316192 | 1445136 | 114771888 | 330950928 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 193 | 139162812096 | 0 | 721050792 | 24264501360 | 42 | 764 | 18.1905 | 9 | 1732 | 192.4444 | 2496 | |
sql/binlog_index | 38 | 51666919392 | 0 | 1359655704 | 32769960432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 3593651952 | 670560 | 449206296 | 1890788064 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1362985536 | 231792 | 272596896 | 1344145968 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46878480 | 2699664 | 15626160 | 36913536 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766368240 | 0 | 51091128 | 704028336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 284475840 | 0 | 56895168 | 225640800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 46 | 668803872 | 0 | 14539008 | 417266256 | 18 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|