将文件拖动至此

SQL upload ( 0 ) x-

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
当前所选内容没有包含唯一字段。单元格编辑、复选框、编辑、复制和删除无法正常使用。文档
正在显示第 0 - ... 此视图的行数最少有这么多。请参阅档案。 行 (查询花费 0.0057 秒。)
SELECT * FROM `SYSTEM_VARIABLES`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
VARIABLE_NAMESESSION_VALUEGLOBAL_VALUEGLOBAL_VALUE_ORIGINDEFAULT_VALUEVARIABLE_SCOPEVARIABLE_TYPEVARIABLE_COMMENTNUMERIC_MIN_VALUENUMERIC_MAX_VALUENUMERIC_BLOCK_SIZEENUM_VALUE_LISTREAD_ONLYCOMMAND_LINE_ARGUMENT
HAVE_OPENSSL NULL NO COMPILE-TIME NULL GLOBAL VARCHAR Comparing have_openssl with have_ssl will indicate... NULL NULL NULL NULL YES NULL
INSERT_ID 0 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED The value to be used by the following INSERT or AL... 0 18446744073709551615 1 NULL NO NULL
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 NULL NULL NULL REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_S... NO REQUIRED
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE NULL -1 COMPILE-TIME -1 GLOBAL INT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... -1 1048576 1 NULL YES REQUIRED
INNODB_LOG_ARCHIVE NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Set to 1 if you want to have logs archived. NULL NULL NULL OFF,ON NO OPTIONAL
PERFORMANCE_SCHEMA_MAX_COND_CLASSES NULL 80 COMPILE-TIME 80 GLOBAL INT UNSIGNED Maximum number of condition instruments. 0 256 1 NULL YES REQUIRED
CONCURRENT_INSERT NULL AUTO COMPILE-TIME AUTO GLOBAL ENUM Use concurrent insert with MyISAM NULL NULL NULL NEVER,AUTO,ALWAYS NO OPTIONAL
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL INT Maximum number of instrumented condition objects. ... -1 1048576 1 NULL YES REQUIRED
INNODB_BUFFER_POOL_SIZE NULL 16777216 CONFIG 134217728 GLOBAL BIGINT The size of the memory buffer InnoDB uses to cache... 5242880 9223372036854775807 1048576 NULL YES REQUIRED
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES NULL 40 COMPILE-TIME 40 GLOBAL INT UNSIGNED Maximum number of rwlock instruments. 0 256 1 NULL YES REQUIRED
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
MAX_HEAP_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED Don't allow creation of heap tables bigger than th... 16384 18446744073709551615 1024 NULL NO REQUIRED
INNODB_LOG_FILE_SIZE NULL 5242880 CONFIG 50331648 GLOBAL BIGINT Size of each log file in a log group. 1048576 9223372036854775807 1048576 NULL YES REQUIRED
INNODB_TRACK_CHANGED_PAGES NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Track the redo log for changed pages and output a ... NULL NULL NULL OFF,ON YES NONE
MAX_SP_RECURSION_DEPTH 0 0 COMPILE-TIME 0 SESSION INT UNSIGNED Maximum stored procedure recursion depth 0 255 1 NULL NO OPTIONAL
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL INT Maximum number of instrumented MUTEX objects. Use ... -1 104857600 1 NULL YES REQUIRED
OPTIMIZER_PRUNE_LEVEL 1 1 COMPILE-TIME 1 SESSION INT UNSIGNED Controls the heuristic(s) applied during query opt... 0 1 1 NULL NO REQUIRED
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL INT Maximum number of instrumented RWLOCK objects. Use... -1 104857600 1 NULL YES REQUIRED
VERSION NULL 10.1.38-MariaDB COMPILE-TIME NULL GLOBAL VARCHAR Server version number. It may also include a suffi... NULL NULL NULL NULL YES NULL
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES NULL 200 COMPILE-TIME 200 GLOBAL INT UNSIGNED Maximum number of mutex instruments. 0 256 1 NULL YES REQUIRED
INNODB_STATS_TRANSIENT_SAMPLE_PAGES NULL 8 COMPILE-TIME 8 GLOBAL BIGINT UNSIGNED The number of leaf index pages to sample when calc... 1 18446744073709551615 0 NULL NO REQUIRED
FLUSH_TIME NULL 0 COMPILE-TIME 0 GLOBAL INT UNSIGNED A dedicated thread is created to flush all tables ... 0 31536000 1 NULL NO REQUIRED
SLOW_LAUNCH_TIME NULL 2 COMPILE-TIME 2 GLOBAL INT UNSIGNED If creating the thread takes longer than this valu... 0 31536000 1 NULL NO REQUIRED
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE NULL -1 COMPILE-TIME -1 GLOBAL INT Maximum number of instrumented user@host accounts.... -1 1048576 1 NULL YES REQUIRED
BINLOG_FORMAT STATEMENT STATEMENT COMPILE-TIME STATEMENT SESSION ENUM What form of binary logging the master will use: e... NULL NULL NULL MIXED,STATEMENT,ROW NO REQUIRED

|
|
|
行数：
过滤行:
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出 显示图表 显示图表 新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签