将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `SYSTEM_VARIABLES`
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
过滤行:
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
COLUMN_COMPRESSION_THRESHOLD 100 100 COMPILE-TIME 100 SESSION INT UNSIGNED Minimum column data length eligible for compressio... 0 4294967295 1 NULL NO REQUIRED
PERFORMANCE_SCHEMA NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable the performance schema. NULL NULL NULL OFF,ON YES OPTIONAL
SQL_MODE STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_... STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_... COMPILE-TIME STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_... 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 BIGINT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... -1 1048576 1 NULL YES REQUIRED
ARIA_PAGECACHE_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
PERFORMANCE_SCHEMA_MAX_COND_CLASSES NULL 90 COMPILE-TIME 90 GLOBAL BIGINT UNSIGNED Maximum number of condition instruments. 0 256 1 NULL YES REQUIRED
BINLOG_CACHE_SIZE NULL 32768 COMPILE-TIME 32768 GLOBAL BIGINT UNSIGNED The size of the transactional cache for updates to... 4096 18446744073709551615 4096 NULL NO REQUIRED
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented condition objects. ... -1 1048576 1 NULL YES REQUIRED
INNODB_DEFRAGMENT NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable/disable InnoDB defragmentation (default FAL... NULL NULL NULL OFF,ON NO REQUIRED
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES NULL 40 COMPILE-TIME 40 GLOBAL BIGINT 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_SORT_LENGTH 1024 1024 COMPILE-TIME 1024 SESSION BIGINT UNSIGNED The number of bytes to use when sorting BLOB or TE... 64 8388608 1 NULL NO REQUIRED
INNODB_ENCRYPT_TEMPORARY_TABLES NULL OFF COMPILE-TIME OFF GLOBAL BOOLEAN Enrypt the temporary table data. NULL NULL NULL OFF,ON YES OPTIONAL
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
PERFORMANCE_SCHEMA_HOSTS_SIZE NULL -1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented hosts. Use 0 to dis... -1 1048576 1 NULL YES REQUIRED
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented MUTEX objects. Use ... -1 104857600 1 NULL YES REQUIRED
MAX_INSERT_DELAYED_THREADS 20 20 COMPILE-TIME 20 SESSION BIGINT UNSIGNED Don't start more than this number of threads to ha... 0 16384 1 NULL NO NULL
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES NULL -1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented RWLOCK objects. Use... -1 104857600 1 NULL YES REQUIRED
WSREP_TRX_FRAGMENT_UNIT bytes bytes COMPILE-TIME bytes SESSION ENUM Unit for streaming replication transaction fragmen... NULL NULL NULL bytes,rows,statements NO REQUIRED
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES NULL 200 COMPILE-TIME 200 GLOBAL BIGINT 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
NET_WRITE_TIMEOUT 60 60 COMPILE-TIME 60 SESSION BIGINT UNSIGNED Number of seconds to wait for a block to be writte... 1 31536000 1 NULL NO REQUIRED
SLOW_LAUNCH_TIME NULL 2 COMPILE-TIME 2 GLOBAL BIGINT 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 BIGINT Maximum number of instrumented user@host accounts.... -1 1048576 1 NULL YES REQUIRED
HAVE_RTREE_KEYS NULL YES COMPILE-TIME NULL GLOBAL VARCHAR If RTREE indexes (used for spatial indexes) are av... NULL NULL NULL NULL YES NULL
|
|
|
|
过滤行:
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签