将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: information_schema »视图: SYSTEM_VARIABLES
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 记录数: 用时:
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: 查询时间:

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. 文档
正在显示第 0 - ... 此视图的行数最少有这么多。请参阅档案 行 (查询花费 0.0031 秒。)
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
INNODB_FT_SORT_PLL_DEGREE NULL2 COMPILE-TIME 2 GLOBAL BIGINT UNSIGNED InnoDB Fulltext search parallel sort degree, will ... 1 16 0 NULLYES REQUIRED
WSREP_NODE_NAME NULLubuntu-s-1vcpu-2gb-blr1-01 COMPILE-TIME ubuntu-s-1vcpu-2gb-blr1-01 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
IDENTITY 0 NULLCOMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Synonym for the last_insert_id variable 0 18446744073709551615 1 NULLNO NULL
PERFORMANCE_SCHEMA_MAX_COND_CLASSES NULL80 COMPILE-TIME 80 GLOBAL BIGINT UNSIGNED Maximum number of condition instruments. 0 256 1 NULLYES REQUIRED
INNODB_FT_MAX_TOKEN_SIZE NULL84 COMPILE-TIME 84 GLOBAL BIGINT UNSIGNED InnoDB Fulltext search maximum token size in chara... 10 84 0 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented condition objects. ... -1 1048576 1 NULLYES REQUIRED
SSL_KEY NULLCOMPILE-TIME GLOBAL VARCHAR X509 key in PEM format (implies --ssl) NULLNULLNULLNULLYES 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
TABLE_OPEN_CACHE NULL64 CONFIG 2000 GLOBAL BIGINT UNSIGNED The number of cached open tables 1 524288 1 NULLNO REQUIRED
INNODB_FILE_FORMAT_MAX NULLAntelope COMPILE-TIME Antelope GLOBAL VARCHAR The highest file format in the tablespace. 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
RAND_SEED2 383917217 NULLCOMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Sets the internal state of the RAND() generator fo... 0 18446744073709551615 1 NULLNO NULL
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