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 | 2643 | 1913358521712 | 0 | 723934200 | 257144420016 | 1563 | 30720000 | 19654.5106 | 675 | 31211520 | 46239.2889 | 61931520 | |
sql/io_cache | 120 | 3807446544 | 0 | 31728576 | 636047280 | 32 | 2231296 | 69728.0000 | 48 | 2196304 | 45756.3333 | 4427600 | |
sql/ERRMSG | 70 | 36082502544 | 2986368 | 515464224 | 5482193904 | 42 | 4287726 | 102088.7143 | 0 | 0 | 0.0000 | 4287726 | |
innodb/innodb_temp_file | 102 | 427356573072 | 0 | 4189770288 | 25396792080 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
innodb/innodb_log_file | 628 | 3983242146576 | 245520 | 6342742032 | 401036126832 | 8 | 70656 | 8832.0000 | 367 | 306688 | 835.6621 | 377344 | |
mysys/charset | 3 | 311044800 | 3703920 | 103681512 | 288396240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 12 | 1217104416 | 513216 | 101425368 | 589410096 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog | 213 | 41944852224 | 0 | 196923936 | 20608325760 | 50 | 796 | 15.9200 | 3 | 156 | 52.0000 | 952 | |
sql/binlog_index | 38 | 57556736160 | 0 | 1514650896 | 38714797968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2332897248 | 812592 | 291612024 | 1676556816 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 658543248 | 255024 | 131708544 | 639557424 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 56113728 | 2895024 | 18704400 | 34063392 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1757603760 | 0 | 117173496 | 1654189152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12440736 | 0 | 12440736 | 12440736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 51520656 | 0 | 12880032 | 28599648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 8 | 59000304 | 272448 | 7374840 | 16949328 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|