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 | 1985 | 11477364122928 | 5782047216 | 143450778240 | 1342941600 | 251077173600 | 11224944007728 | 8 | 70656 | 8832.0000 | 1210 | 1503744 | 1242.7636 | |
innodb/innodb_data_file | 4206 | 7753694718000 | 1843484016 | 223438213680 | 239322097344 | 93768067008 | 7420604553648 | 1410 | 28213248 | 20009.3957 | 1888 | 68567040 | 36317.2881 | |
innodb/innodb_temp_file | 126 | 546815460576 | 4339805184 | 29315733744 | 0 | 1511864640 | 545303595936 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | |
sql/binlog | 373 | 535577896128 | 1435865640 | 28273359840 | 976236624 | 1504836432 | 533096823072 | 74 | 892 | 12.0541 | 35 | 11533 | 329.5143 | |
sql/binlog_index | 38 | 42022989360 | 1105868016 | 22791255696 | 1487261952 | 0 | 40535727408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 28624510992 | 477074928 | 2436430128 | 17284883088 | 0 | 11339627904 | 36 | 3694707 | 102630.7500 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 3683301072 | 460412568 | 3074863440 | 3629752368 | 0 | 53548704 | 4 | 869 | 217.2500 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 1210833888 | 40361112 | 179997312 | 80480928 | 739498848 | 390854112 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
csv/metadata | 4 | 872643024 | 218160624 | 727260336 | 727260336 | 0 | 145382688 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 838369488 | 55891176 | 764037648 | 0 | 0 | 838369488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 37 | 661223904 | 17870688 | 535164432 | 544764000 | 0 | 116459904 | 25 | 975 | 39.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 554001360 | 110800272 | 528143088 | 529241856 | 0 | 24759504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 336593664 | 112197888 | 304763184 | 304763184 | 0 | 31830480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 329794608 | 54965592 | 276205776 | 0 | 0 | 329794608 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 9 | 117138912 | 13015200 | 44250096 | 41934288 | 0 | 75204624 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12648240 | 4216080 | 10181424 | 0 | 1799424 | 10848816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|