SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 823 | 4583520410304 | 5569283544 | 30501678240 | 1460765328 | 107425986624 | 4474633658352 | 8 | 70656 | 8832.0000 | 489 | 474112 | 969.5542 | |
innodb/innodb_data_file | 3154 | 3491711610816 | 1107073968 | 239370326448 | 326009992704 | 43696742496 | 3122004875616 | 1591 | 31178752 | 19596.9529 | 1020 | 42024960 | 41200.9412 | |
innodb/innodb_temp_file | 96 | 400190098176 | 4168646856 | 32421161520 | 0 | 2918442912 | 397271655264 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog | 237 | 127869756960 | 539534688 | 18253375008 | 1547851536 | 2668505664 | 123653399760 | 53 | 808 | 15.2453 | 9 | 1920 | 213.3333 | |
sql/binlog_index | 38 | 49207881888 | 1294944024 | 29845286592 | 805317216 | 0 | 48402564672 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 38352228288 | 639203664 | 2484134928 | 22045832688 | 0 | 16306395600 | 36 | 3695608 | 102655.7778 | 0 | 0 | 0.0000 | |
myisam/dfile | 16616 | 9920212368 | 596904 | 854241696 | 9550550592 | 0 | 369661776 | 14604 | 985792 | 67.5015 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 6129411024 | 766176312 | 4844449104 | 1162334448 | 0 | 4967076576 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2565686112 | 160355184 | 867047280 | 2425601376 | 0 | 140084736 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1321886544 | 264377256 | 1293979632 | 1296758496 | 0 | 25128048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1015261632 | 67684056 | 953103360 | 0 | 0 | 1015261632 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 304400976 | 101466816 | 291216816 | 291216816 | 0 | 13184160 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 237914688 | 59478672 | 206926368 | 0 | 0 | 237914688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 53362848 | 13340712 | 32247600 | 0 | 0 | 53362848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 43640256 | 14546664 | 33995280 | 0 | 7339200 | 36301056 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|