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$waits_global_by_latency`
events total total_latency avg_latency max_latency
wait/io/file/innodb/innodb_log_file 8100 40868776972848 5045527872 919435474320
wait/io/file/innodb/innodb_data_file 11685 14586577431888 1248316344 232021741776
wait/io/file/innodb/innodb_temp_file 442 927812148912 2099122344 35850292368
wait/io/file/sql/binlog 609 927403568784 1522830144 35429138448
wait/lock/metadata/sql/mdl 3 292396086048 97465361928 204532791936
wait/io/table/sql/handler 27033 78134145936 2890272 4318423296
wait/io/file/sql/binlog_index 38 47470518480 1249223976 29062866096
wait/io/file/sql/ERRMSG 80 44672602656 558407520 4029245088
wait/io/file/sql/io_cache 496 10307598576 20781288 693027984
wait/lock/table/sql/handler 3976 4415734752 1110384 416643744
wait/io/file/csv/metadata 8 3181118160 397639704 1977272880
wait/io/file/mysys/cnf 5 1649662080 329932416 1621887168
wait/io/file/myisam/kfile 8 1284808272 160600968 975839040
wait/io/file/sql/casetest 15 738594912 49239432 669116976
wait/io/file/myisam/dfile 6 601599504 100266408 564436224
wait/io/file/csv/data 17 401985408 23645952 263191632
wait/io/file/mysys/charset 3 246056448 82018728 234769920
wait/io/file/sql/misc 6 104542944 17423736 37932576
wait/io/file/sql/pid 3 49460400 16486800 38805360
Query results operations