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 | 2414 | 2358493738656 | 0 | 977006448 | 236187373488 | 1314 | 26640384 | 20274.2648 | 782 | 34783232 | 44479.8363 | 61423616 | |
sql/ERRMSG | 50 | 30897960720 | 2570304 | 617959056 | 2710292112 | 30 | 3075955 | 102531.8333 | 0 | 0 | 0.0000 | 3075955 | |
innodb/innodb_temp_file | 137 | 693259635552 | 0 | 5060289168 | 30553214736 | 0 | 0 | 0.0000 | 60 | 2752512 | 45875.2000 | 2752512 | |
innodb/innodb_log_file | 663 | 4625209656144 | 240240 | 6976183368 | 869506803792 | 8 | 70656 | 8832.0000 | 391 | 371200 | 949.3606 | 441856 | |
mysys/charset | 3 | 267424080 | 2101968 | 89141184 | 253567248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 215 | 118940274288 | 0 | 553210416 | 21899576688 | 48 | 788 | 16.4167 | 8 | 1616 | 202.0000 | 2404 | |
sql/binlog_index | 38 | 45355342560 | 0 | 1193561424 | 24723950064 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1486515888 | 1059168 | 185814288 | 671764896 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 704810304 | 156288 | 140962008 | 688654032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49288800 | 2826384 | 16429512 | 38732496 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 725129328 | 0 | 48341832 | 660550176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 288466992 | 0 | 96155664 | 238509216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 345783504 | 0 | 86445744 | 288782736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|