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 | 1899 | 1404722283888 | 0 | 739716648 | 271443446208 | 1322 | 26771456 | 20250.7231 | 338 | 20496384 | 60640.1893 | 47267840 | |
sql/ERRMSG | 60 | 26626274928 | 3175920 | 443771064 | 2920952496 | 36 | 3688432 | 102456.4444 | 0 | 0 | 0.0000 | 3688432 | |
innodb/innodb_temp_file | 168 | 704464632432 | 0 | 4193241624 | 26088800496 | 0 | 0 | 0.0000 | 85 | 3555328 | 41827.3882 | 3555328 | |
innodb/innodb_log_file | 304 | 1566874672176 | 234960 | 5154192912 | 35218724112 | 8 | 70656 | 8832.0000 | 172 | 147968 | 860.2791 | 218624 | |
mysys/charset | 3 | 357985056 | 3336432 | 119328264 | 337427376 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 561 | 71285611056 | 0 | 127068744 | 20077345728 | 136 | 1140 | 8.3824 | 5 | 641 | 128.2000 | 1781 | |
myisam/kfile | 4 | 768789648 | 599280 | 192197280 | 753280704 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 46342342992 | 0 | 1219535328 | 30257495136 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 7374002592 | 890736 | 921750192 | 5718896832 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 704923824 | 154704 | 140984712 | 686681424 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12311376 | 571296 | 4103616 | 9988176 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1359983328 | 0 | 90665520 | 1270184784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 29356272 | 0 | 9785424 | 13901712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 257528304 | 0 | 64381944 | 207963888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 18180096 | 8781696 | 9090048 | 9398400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|