Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
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
Query results operations