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 `VARIABLE_COMMENT` 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 Descending Ascending 1 NUMERIC_MIN_VALUE NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
COLUMN_COMPRESSION_ZLIB_LEVEL 6 6 COMPILE-TIME 6 SESSION INT UNSIGNED zlib compression level (1 gives best speed, 9 give... 0 9 1 NULL NO REQUIRED
UPDATABLE_VIEWS_WITH_LIMIT YES YES COMPILE-TIME YES SESSION ENUM YES = Don't issue an error message (warning only) ... NULL NULL NULL NO,YES NO REQUIRED
SSL_KEY NULL COMPILE-TIME GLOBAL VARCHAR X509 key in PEM format (implies --ssl) NULL NULL NULL NULL YES REQUIRED
SSL_CERT NULL COMPILE-TIME GLOBAL VARCHAR X509 cert in PEM format (implies --ssl) NULL NULL NULL NULL YES REQUIRED
LOG_SLOW_RATE_LIMIT 1 1 COMPILE-TIME 1 SESSION INT UNSIGNED Write to slow log every #th slow query. Set to 1 t... 1 4294967295 1 NULL NO REQUIRED
CORE_FILE NULL ON COMPILE-TIME ON GLOBAL BOOLEAN Write core on crashes NULL NULL NULL OFF,ON YES OPTIONAL
INNODB_FLUSH_LOG_AT_TIMEOUT NULL 1 COMPILE-TIME 1 GLOBAL INT UNSIGNED Write and flush logs every (n) second. 0 2700 0 NULL NO OPTIONAL
INNODB_FLUSH_METHOD NULL unbuffered COMPILE-TIME unbuffered GLOBAL ENUM With which method to flush data. NULL NULL NULL fsync,O_DSYNC,littlesync,nosync,O_DIRECT,O_DIRECT_... YES REQUIRED
INNODB_RANDOM_READ_AHEAD NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Whether to use read ahead for random access within... NULL NULL NULL OFF,ON NO NONE
INNODB_FT_ENABLE_DIAG_PRINT NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Whether to enable additional FTS diagnostic printo... NULL NULL NULL OFF,ON NO OPTIONAL
INNODB_DISABLE_SORT_FILE_CACHE NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Whether to disable OS system file cache for sort I... NULL NULL NULL OFF,ON NO OPTIONAL
IN_TRANSACTION 0 NULL COMPILE-TIME NULL SESSION ONLY BIGINT UNSIGNED Whether there is an active transaction 0 1 1 NULL YES NULL
REPLICATE_EVENTS_MARKED_FOR_SKIP NULL REPLICATE COMPILE-TIME REPLICATE GLOBAL ENUM Whether the slave should replicate events that wer... NULL NULL NULL REPLICATE,FILTER_ON_SLAVE,FILTER_ON_MASTER NO REQUIRED
LOG_BIN NULL OFF COMPILE-TIME NULL GLOBAL BOOLEAN Whether the binary log is enabled NULL NULL NULL OFF,ON YES NULL
LOG_BIN_COMPRESS NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Whether the binary log can be compressed NULL NULL NULL OFF,ON NO OPTIONAL
ARIA_USED_FOR_TEMP_TABLES NULL ON COMPILE-TIME NULL GLOBAL BOOLEAN Whether temporary tables should be MyISAM or Aria NULL NULL NULL OFF,ON YES NULL
LARGE_FILES_SUPPORT NULL ON COMPILE-TIME NULL GLOBAL BOOLEAN Whether mysqld was compiled with options for large... NULL NULL NULL OFF,ON YES NULL
GTID_IGNORE_DUPLICATES NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN When set, different master connections in multi-so... NULL NULL NULL OFF,ON NO OPTIONAL
READ_RND_BUFFER_SIZE 524288 524288 CONFIG 262144 SESSION INT UNSIGNED When reading rows in sorted order after a sort, th... 1 2147483647 1 NULL NO REQUIRED
STRICT_PASSWORD_VALIDATION NULL ON COMPILE-TIME ON GLOBAL BOOLEAN When password validation plugins are enabled, reje... NULL NULL NULL OFF,ON NO OPTIONAL
DELAYED_QUEUE_SIZE NULL 1000 COMPILE-TIME 1000 GLOBAL INT UNSIGNED What size queue (in rows) should be allocated for ... 1 4294967295 1 NULL NO REQUIRED
BINLOG_FORMAT MIXED MIXED COMPILE-TIME MIXED SESSION ENUM What form of binary logging the master will use: e... NULL NULL NULL MIXED,STATEMENT,ROW NO REQUIRED
RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE NULL ON COMPILE-TIME ON GLOBAL BOOLEAN Wait until timeout when no semi-synchronous replic... NULL NULL NULL OFF,ON NO OPTIONAL
INNODB_MAX_PURGE_LAG_WAIT NULL 4294967295 COMPILE-TIME 4294967295 GLOBAL INT UNSIGNED Wait until History list length is below the specif... 0 4294967295 0 NULL NO REQUIRED
SYSTEM_VERSIONING_ALTER_HISTORY ERROR ERROR COMPILE-TIME ERROR SESSION ENUM Versioning ALTER TABLE mode. ERROR: Fail ALTER wit... NULL NULL NULL ERROR,KEEP 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