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 | 4951 | 4418831824704 | 0 | 892512984 | 212631757008 | 1347 | 27181056 | 20178.9577 | 3088 | 108216320 | 35044.1451 | 135397376 | |
sql/ERRMSG | 65 | 32394130032 | 2818464 | 498371016 | 3273138528 | 39 | 4000044 | 102565.2308 | 0 | 0 | 0.0000 | 4000044 | |
innodb/innodb_temp_file | 108 | 422965598352 | 0 | 3916348128 | 33093629184 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | 1736704 | |
innodb/innodb_log_file | 2382 | 11929181869440 | 242880 | 5008052808 | 116273443968 | 8 | 70656 | 8832.0000 | 1454 | 1108992 | 762.7180 | 1179648 | |
mysys/charset | 3 | 256080528 | 2235552 | 85360176 | 241688304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 1758 | 41955273360 | 0 | 23865336 | 17067959568 | 437 | 2491 | 5.7002 | 3 | 156 | 52.0000 | 2647 | |
sql/binlog_index | 38 | 55465122240 | 0 | 1459608480 | 33946737792 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 901218384 | 695904 | 112652232 | 462227040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1721957424 | 183744 | 344391432 | 1704012288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12593856 | 707520 | 4197864 | 10365168 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 973536432 | 0 | 64902288 | 910188048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3222384 | 0 | 3222384 | 3222384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 44618640 | 0 | 11154528 | 21905664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|