将文件拖动至此

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.0041 秒。) [VARIABLE_TYPE: BIGINT... - BIGINT...]
SELECT * FROM `SYSTEM_VARIABLES`  
ORDER BY `SYSTEM_VARIABLES`.`VARIABLE_TYPE` ASC
VARIABLE_NAMESESSION_VALUEGLOBAL_VALUEGLOBAL_VALUE_ORIGINDEFAULT_VALUEVARIABLE_SCOPEVARIABLE_TYPE 递增 递减 1VARIABLE_COMMENTNUMERIC_MIN_VALUENUMERIC_MAX_VALUENUMERIC_BLOCK_SIZEENUM_VALUE_LISTREAD_ONLYCOMMAND_LINE_ARGUMENT
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
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented condition objects. ... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented MUTEX objects. Use ... -1 104857600 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
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented user@host accounts.... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows per thread in EVENTS_WAITS_HISTORY.... -1 1024 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows per thread in EVENTS_STAGES_HISTORY... -1 1024 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented threads. Use 0 to d... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use ... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH NULL1024 COMPILE-TIME 1024 GLOBAL BIGINT Maximum length considered for digest text, when st... 0 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_DIGESTS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Size of the statement digest. Use 0 to disable, -1... -1 200 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Size of session attribute string buffer per thread... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows per thread in EVENTS_STATEMENTS_HIS... -1 1024 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_USERS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented users. Use 0 to dis... -1 1048576 1 NULLYES REQUIRED
INNODB_AUTOINC_LOCK_MODE NULL1 COMPILE-TIME 1 GLOBAL BIGINT The AUTOINC lock modes supported by InnoDB:       ... 0 2 0 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented files. Use 0 to dis... -1 1048576 1 NULLYES REQUIRED
INNODB_MTFLUSH_THREADS NULL8 COMPILE-TIME 8 GLOBAL BIGINT Number of multi-threaded flush threads 1 64 0 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of opened instrumented sockets. Use... -1 1048576 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_HOSTS_SIZE NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented hosts. Use 0 to dis... -1 1048576 1 NULLYES REQUIRED
INNODB_LOG_BUFFER_SIZE NULL8388608 CONFIG 16777216 GLOBAL BIGINT The size of the buffer which InnoDB uses to write ... 262144 9223372036854775807 1024 NULLYES REQUIRED
PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Maximum number of instrumented tables. Use 0 to di... -1 1048576 1 NULLYES REQUIRED
INNODB_MIRRORED_LOG_GROUPS NULL1 COMPILE-TIME 0 GLOBAL BIGINT Number of identical copies of log groups we keep f... 0 10 0 NULLYES REQUIRED
INNODB_BUFFER_POOL_INSTANCES NULL8 COMPILE-TIME 0 GLOBAL BIGINT Number of buffer pool instances, set to higher val... 0 64 1 NULLYES REQUIRED
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_... NULL-1 COMPILE-TIME -1 GLOBAL BIGINT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. ... -1 1048576 1 NULLYES REQUIRED
INNODB_OPEN_FILES NULL300 COMPILE-TIME 0 GLOBAL BIGINT How many files at the maximum InnoDB keeps open at... 0 9223372036854775807 0 NULLYES REQUIRED


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