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 :
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 `SYSTEM_VARIABLES` ORDER BY `NUMERIC_MIN_VALUE` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
VARIABLE_NAME SESSION_VALUE GLOBAL_VALUE GLOBAL_VALUE_ORIGIN DEFAULT_VALUE VARIABLE_SCOPE VARIABLE_TYPE VARIABLE_COMMENT NUMERIC_MIN_VALUE Descending Ascending 1 NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
ARIA_LOG_FILE_SIZE NULL 1073741824 COMPILE-TIME 1073741824 GLOBAL INT UNSIGNED Limit for transaction log size 8388608 4294967295 8192 NULL NO REQUIRED
BINLOG_FILE_CACHE_SIZE NULL 16384 COMPILE-TIME 16384 GLOBAL BIGINT UNSIGNED The size of file cache for the binary log 8192 18446744073709551615 4096 NULL NO REQUIRED
MAX_SESSION_MEM_USED 9223372036854775807 9223372036854775807 COMPILE-TIME 9223372036854775807 SESSION BIGINT UNSIGNED Amount of memory a single user session is allowed ... 8192 18446744073709551615 1 NULL NO REQUIRED
READ_BUFFER_SIZE 262144 262144 CONFIG 131072 SESSION INT UNSIGNED Each thread that does a sequential scan allocates ... 8192 2147483647 4096 NULL NO REQUIRED
MRR_BUFFER_SIZE 262144 262144 COMPILE-TIME 262144 SESSION INT UNSIGNED Size of buffer to use when using MRR with range ac... 8192 2147483647 1 NULL NO REQUIRED
MYISAM_MMAP_SIZE NULL 18446744073709551615 COMPILE-TIME 18446744073709551615 GLOBAL BIGINT UNSIGNED Restricts the total memory used for memory mapping... 7 18446744073709551615 1 NULL YES REQUIRED
INNODB_SORT_BUFFER_SIZE NULL 1048576 COMPILE-TIME 1048576 GLOBAL INT UNSIGNED Memory buffer size for index creation 65536 67108864 0 NULL YES REQUIRED
INNODB_ONLINE_ALTER_LOG_MAX_SIZE NULL 134217728 COMPILE-TIME 134217728 GLOBAL BIGINT UNSIGNED Maximum modification log file size for online inde... 65536 18446744073709551615 0 NULL NO REQUIRED
MAX_SORT_LENGTH 1024 1024 COMPILE-TIME 1024 SESSION INT UNSIGNED The number of bytes to use when sorting BLOB or TE... 64 8388608 1 NULL NO REQUIRED
INNODB_LOG_WRITE_AHEAD_SIZE NULL 8192 COMPILE-TIME 8192 GLOBAL INT UNSIGNED Redo log write ahead unit size to avoid read-on-wr... 512 16384 512 NULL NO REQUIRED
KEY_CACHE_BLOCK_SIZE NULL 1024 COMPILE-TIME 1024 GLOBAL BIGINT UNSIGNED The default size of key cache blocks 512 16384 512 NULL NO REQUIRED
INNODB_OLD_BLOCKS_PCT NULL 37 COMPILE-TIME 37 GLOBAL INT UNSIGNED Percentage of the buffer pool to reserve for 'old'... 5 95 0 NULL NO REQUIRED
RANGE_ALLOC_BLOCK_SIZE 4096 4096 COMPILE-TIME 4096 SESSION INT UNSIGNED Allocation block size for storing ranges during op... 4096 4294967295 1024 NULL NO REQUIRED
BINLOG_STMT_CACHE_SIZE NULL 32768 COMPILE-TIME 32768 GLOBAL BIGINT UNSIGNED The size of the statement cache for updates to non... 4096 18446744073709551615 4096 NULL NO REQUIRED
MAX_BINLOG_SIZE NULL 1073741824 COMPILE-TIME 1073741824 GLOBAL INT UNSIGNED Binary log will be rotated automatically when the ... 4096 1073741824 4096 NULL NO REQUIRED
MAX_BINLOG_CACHE_SIZE NULL 18446744073709547520 COMPILE-TIME 18446744073709547520 GLOBAL BIGINT UNSIGNED Sets the total size of the transactional cache 4096 18446744073709551615 4096 NULL NO REQUIRED
MAX_BINLOG_STMT_CACHE_SIZE NULL 18446744073709547520 COMPILE-TIME 18446744073709547520 GLOBAL BIGINT UNSIGNED Sets the total size of the statement cache 4096 18446744073709551615 4096 NULL NO REQUIRED
BINLOG_CACHE_SIZE NULL 32768 COMPILE-TIME 32768 GLOBAL BIGINT UNSIGNED The size of the transactional cache for updates to... 4096 18446744073709551615 4096 NULL NO REQUIRED
ARIA_BLOCK_SIZE NULL 8192 COMPILE-TIME 8192 GLOBAL INT UNSIGNED Block size to be used for Aria index pages. 4096 32768 1024 NULL YES REQUIRED
INNODB_PAGE_SIZE NULL 16384 COMPILE-TIME 16384 GLOBAL INT UNSIGNED Page size to use for all InnoDB tablespaces. 4096 65536 0 NULL YES OPTIONAL
MAX_RELAY_LOG_SIZE 1073741824 1073741824 AUTO 1073741824 SESSION BIGINT UNSIGNED relay log will be rotated automatically when the s... 4096 1073741824 4096 NULL NO REQUIRED
MYISAM_SORT_BUFFER_SIZE 8388608 8388608 CONFIG 134216704 SESSION BIGINT UNSIGNED The buffer that is allocated when sorting the inde... 4096 1152921504606846975 1 NULL NO REQUIRED
TABLE_DEFINITION_CACHE NULL 400 AUTO 400 GLOBAL INT UNSIGNED The number of cached table definitions 400 2097152 1 NULL NO REQUIRED
GROUP_CONCAT_MAX_LEN 1048576 1048576 COMPILE-TIME 1048576 SESSION INT UNSIGNED The maximum length of the result of function GROUP... 4 4294967295 1 NULL NO REQUIRED
MAX_LENGTH_FOR_SORT_DATA 1024 1024 COMPILE-TIME 1024 SESSION INT UNSIGNED Max number of bytes in sorted records 4 8388608 1 NULL NO REQUIRED
|
|
|
|
Filter rows:
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