将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `SYSTEM_VARIABLES` ORDER BY `VARIABLE_TYPE` ASC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
过滤行:
VARIABLE_NAME SESSION_VALUE GLOBAL_VALUE GLOBAL_VALUE_ORIGIN DEFAULT_VALUE VARIABLE_SCOPE VARIABLE_TYPE 递增 递减 1 VARIABLE_COMMENT NUMERIC_MIN_VALUE NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
READ_BINLOG_SPEED_LIMIT NULL 0 COMPILE-TIME 0 GLOBAL BIGINT UNSIGNED Maximum speed(KB/s) to read binlog from master (0 ... 0 4294967295 1 NULL NO 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
TMP_MEMORY_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED If an internal in-memory temporary table exceeds t... 1024 18446744073709551615 1 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
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
TMP_TABLE_SIZE 16777216 16777216 COMPILE-TIME 16777216 SESSION BIGINT UNSIGNED Alias for tmp_memory_table_size. If an internal in... 1024 18446744073709551615 1 NULL NO REQUIRED
IDENTITY 0 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Synonym for the last_insert_id variable 0 18446744073709551615 1 NULL NO NULL
JOIN_BUFFER_SIZE 262144 262144 COMPILE-TIME 262144 SESSION BIGINT UNSIGNED The size of the buffer that is used for joins 128 18446744073709551615 128 NULL NO REQUIRED
RAND_SEED2 454199824 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Sets the internal state of the RAND() generator fo... 0 4294967295 1 NULL NO NULL
SORT_BUFFER_SIZE 524288 524288 CONFIG 2097152 SESSION BIGINT UNSIGNED Each thread that needs to do a sort allocates a bu... 1024 18446744073709551615 1 NULL NO REQUIRED
JOIN_BUFFER_SPACE_LIMIT 2097152 2097152 COMPILE-TIME 2097152 SESSION BIGINT UNSIGNED The limit of the space for all join buffers used b... 2048 18446744073709551615 2048 NULL NO REQUIRED
RAND_SEED1 700259039 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED Sets the internal state of the RAND() generator fo... 0 4294967295 1 NULL NO NULL
BULK_INSERT_BUFFER_SIZE 8388608 8388608 COMPILE-TIME 8388608 SESSION BIGINT UNSIGNED Size of tree cache used in bulk insert optimisatio... 0 18446744073709551615 1 NULL NO REQUIRED
PSEUDO_THREAD_ID 38595 NULL COMPILE-TIME 0 SESSION ONLY BIGINT UNSIGNED This variable is for internal server use 0 18446744073709551615 1 NULL NO NULL
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
KEY_CACHE_DIVISION_LIMIT NULL 100 COMPILE-TIME 100 GLOBAL BIGINT UNSIGNED The minimum percentage of warm blocks in key cache 1 100 1 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_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
ARIA_SORT_BUFFER_SIZE 268434432 268434432 COMPILE-TIME 268434432 SESSION BIGINT UNSIGNED The buffer that is allocated when sorting the inde... 16376 1152921504606846975 1 NULL NO REQUIRED
KEY_BUFFER_SIZE NULL 16777216 CONFIG 134217728 GLOBAL BIGINT UNSIGNED The size of the buffer used for index blocks for M... 0 18446744073709551615 4096 NULL NO REQUIRED
INNODB_MAX_UNDO_LOG_SIZE NULL 10485760 COMPILE-TIME 10485760 GLOBAL BIGINT UNSIGNED Desired maximum UNDO tablespace size in bytes 10485760 281474976710656 0 NULL NO OPTIONAL
MAX_ROWID_FILTER_SIZE 131072 131072 COMPILE-TIME 131072 SESSION BIGINT UNSIGNED The maximum size of the container of a rowid filte... 1024 18446744073709551615 1 NULL NO REQUIRED
QUERY_CACHE_SIZE NULL 1048576 COMPILE-TIME 1048576 GLOBAL BIGINT UNSIGNED The memory allocated to store results from old que... 0 4294967295 1024 NULL NO REQUIRED
INNODB_STATS_SAMPLE_PAGES NULL 8 COMPILE-TIME 8 GLOBAL BIGINT UNSIGNED Deprecated, use innodb_stats_transient_sample_page... 1 18446744073709551615 0 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
|
|
|
|
过滤行:
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签