Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: information_schema »View: SYSTEM_VARIABLES
Page-related settingsClick 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 :
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0070 seconds.)
SELECT * FROM `SYSTEM_VARIABLES`
VARIABLE_NAME SESSION_VALUE GLOBAL_VALUE GLOBAL_VALUE_ORIGIN DEFAULT_VALUE VARIABLE_SCOPE VARIABLE_TYPE VARIABLE_COMMENT NUMERIC_MIN_VALUE NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
KEY_CACHE_SEGMENTS NULL0 COMPILE-TIME 0 GLOBAL BIGINT UNSIGNED The number of segments in a key cache 0 64 1 NULLNO REQUIRED
WSREP_NODE_NAME NULLxserver COMPILE-TIME xserver GLOBAL VARCHAR Node name NULLNULLNULLNULLNO REQUIRED
SQL_MODE NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION COMPILE-TIME NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SESSION SET Sets the sql mode NULLNULLNULLREAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_S... NO REQUIRED
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... -1 1048576 1 NULLYES REQUIRED
BASEDIR NULL/opt/lampp CONFIG GLOBAL VARCHAR Path to installation directory. All paths are usua... NULLNULLNULLNULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_COND_CLASSES NULL80 COMPILE-TIME 80 GLOBAL BIGINT UNSIGNED Maximum number of condition instruments. 0 256 1 NULLYES REQUIRED
SOCKET NULL/opt/lampp/var/mysql/mysql.sock CONFIG GLOBAL VARCHAR Socket file to use for connection NULLNULLNULLNULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented condition objects. ... -1 1048576 1 NULLYES REQUIRED
INNODB_LOG_BLOCK_SIZE NULL512 COMPILE-TIME 512 GLOBAL BIGINT UNSIGNED ###EXPERIMENTAL###: The log block size of the tran... 512 65536 0 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES NULL40 COMPILE-TIME 40 GLOBAL BIGINT UNSIGNED Maximum number of rwlock instruments. 0 256 1 NULLYES REQUIRED
INNODB_FLUSH_LOG_AT_TIMEOUT NULL1 COMPILE-TIME 1 GLOBAL INT UNSIGNED Write and flush logs every (n) second. 0 2700 0 NULLNO OPTIONAL
VERSION_SSL_LIBRARY NULLOpenSSL 1.0.2j  26 Sep 2016 COMPILE-TIME NULLGLOBAL VARCHAR Version of the used SSL library NULLNULLNULLNULLYES NULL
INNODB_SCRUB_LOG NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable background redo log (ib_logfile0, ib_logfil... NULLNULLNULLOFF,ON YES OPTIONAL
INNODB_FT_SERVER_STOPWORD_TABLE NULLCOMPILE-TIME GLOBAL VARCHAR The user supplied stopword table name. NULLNULLNULLNULLNO OPTIONAL
MAX_SP_RECURSION_DEPTH 0 0 COMPILE-TIME 0 SESSION BIGINT UNSIGNED Maximum stored procedure recursion depth 0 255 1 NULLNO OPTIONAL
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented MUTEX objects. Use ... -1 104857600 1 NULLYES REQUIRED
REPORT_PORT NULL3306 AUTO 0 GLOBAL INT UNSIGNED Port for connecting to slave reported to the maste... 0 4294967295 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented RWLOCK objects. Use... -1 104857600 1 NULLYES REQUIRED
INNODB_USE_SYS_MALLOC NULLON COMPILE-TIME ON GLOBAL BOOLEAN DEPRECATED. This option may be removed in future r... NULLNULLNULLOFF,ON YES NONE
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES NULL200 COMPILE-TIME 200 GLOBAL BIGINT UNSIGNED Maximum number of mutex instruments. 0 256 1 NULLYES REQUIRED
INNODB_STATS_TRANSIENT_SAMPLE_PAGES NULL8 COMPILE-TIME 8 GLOBAL BIGINT UNSIGNED The number of leaf index pages to sample when calc... 1 18446744073709551615 0 NULLNO REQUIRED
THREAD_POOL_SIZE NULL1 AUTO 8 GLOBAL INT UNSIGNED Number of thread groups in the pool. This paramete... 1 100000 1 NULLNO REQUIRED
SLOW_LAUNCH_TIME NULL2 COMPILE-TIME 2 GLOBAL BIGINT UNSIGNED If creating the thread takes longer than this valu... 0 31536000 1 NULLNO REQUIRED
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented user@host accounts.... -1 1048576 1 NULLYES REQUIRED
BINLOG_FORMAT STATEMENT STATEMENT COMPILE-TIME STATEMENT SESSION ENUM What form of binary logging the master will use: e... NULLNULLNULLMIXED,STATEMENT,ROW NO REQUIRED