将文件拖动至此

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.0037 秒。)
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
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 NULLizhp39hn5gsepj8ayfapbgz COMPILE-TIME izhp39hn5gsepj8ayfapbgz GLOBAL VARCHAR Name of this node. This name can be used in wsrep_... 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.2n  7 Dec 2017 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

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

将此 SQL 查询加为书签 将此 SQL 查询加为书签
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
使用配置文件中定义的控制用户连接失败。