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 | 2314 | 2111361544512 | 0 | 912429144 | 233296477920 | 1291 | 26263552 | 20343.5724 | 720 | 32489472 | 45124.2667 | 58753024 | |
sql/io_cache | 592 | 103357553376 | 0 | 174590328 | 86838969888 | 234 | 13445568 | 57459.6923 | 248 | 13445568 | 54216.0000 | 26891136 | |
innodb/innodb_temp_file | 396 | 886421203536 | 0 | 2238437256 | 232762062720 | 0 | 0 | 0.0000 | 324 | 6750208 | 20833.9753 | 6750208 | |
sql/ERRMSG | 35 | 18677904432 | 2923008 | 533654352 | 3769126944 | 21 | 2153817 | 102562.7143 | 0 | 0 | 0.0000 | 2153817 | |
sql/binlog | 232 | 362481070512 | 0 | 1562418264 | 41573934336 | 31 | 720 | 23.2258 | 81 | 491419 | 6066.9012 | 492139 | |
myisam/dfile | 3353 | 2893970112 | 255024 | 863016 | 22671264 | 0 | 0 | 0.0000 | 3338 | 490724 | 147.0114 | 490724 | |
innodb/innodb_log_file | 577 | 3221880669216 | 250272 | 5583848424 | 105948853824 | 8 | 70656 | 8832.0000 | 333 | 302080 | 907.1471 | 372736 | |
mysys/charset | 3 | 273181920 | 3851232 | 91060464 | 252586224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/SDI | 6 | 127043136 | 2683824 | 21173856 | 49788288 | 0 | 0 | 0.0000 | 2 | 14641 | 7320.5000 | 14641 | |
myisam/kfile | 51 | 2296979520 | 313632 | 45038664 | 594682176 | 10 | 1938 | 193.8000 | 25 | 1627 | 65.0800 | 3565 | |
sql/binlog_index | 38 | 42034233120 | 0 | 1106163960 | 22641224496 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 564948384 | 669504 | 70618416 | 287829696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 419504448 | 208032 | 83900784 | 397463088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13537392 | 631488 | 4512288 | 10782288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
csv/data | 4 | 625429200 | 0 | 156357168 | 344532672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 351234576 | 0 | 50176368 | 269687088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/casetest | 15 | 869730048 | 0 | 57981792 | 788290272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|