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 | 3909 | 5182756343424 | 0 | 1325852088 | 260930042736 | 1304 | 26476544 | 20304.0982 | 2095 | 75808768 | 36185.5695 | 102285312 | |
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 | 1821 | 9777654365424 | 236544 | 5369387232 | 64113849360 | 8 | 70656 | 8832.0000 | 1092 | 868352 | 795.1941 | 939008 | |
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 |
|