Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 `INNODB_SYS_INDEXES` ORDER BY `MERGE_THRESHOLD` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
INDEX_ID NAME TABLE_ID TYPE N_FIELDS PAGE_NO SPACE MERGE_THRESHOLD Descending Ascending 1
195 PRIMARY 138 3 1 3 123 50
1246 PRIMARY 625 3 1 3 610 50
499 PRIMARY 313 3 1 3 298 50
1882 policy_type_id 891 0 1 4 876 50
515 PRIMARY 319 3 1 3 304 50
1898 idx_ip_address 897 0 1 6 882 50
531 category 326 0 1 4 311 50
18 PRIMARY 16 3 4 3 2 50
547 PRIMARY 333 3 1 3 318 50
34 PRIMARY 28 3 3 3 14 50
563 PRIMARY 340 3 1 3 325 50
179 PRIMARY 130 3 1 3 115 50
1230 questions 619 0 1 5 604 50
1237 PRIMARY 622 3 1 3 607 50
202 contest_id 141 0 1 4 126 50
1873 question_id 887 0 1 4 872 50
506 product_id 315 2 1 4 300 50
1889 PRIMARY 895 3 1 3 880 50
522 PRIMARY 323 3 1 3 308 50
1905 idx_user 900 0 1 5 885 50
538 PRIMARY 330 3 1 3 315 50
25 PRIMARY 21 3 1 3 7 50
554 category_id 335 0 1 5 320 50
41 PRIMARY 34 3 2 3 20 50
570 PRIMARY 344 3 1 3 329 50
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query