博客
关于我
强烈建议你试试无所不能的chatGPT，快点击我
mysql系统变量
阅读量：5970 次
发布时间：2019-06-19

本文共 9517 字，大约阅读时间需要 31 分钟。

 

Table 5.2 System Variable Summary

Name Cmd-Line Option File System Var Var Scope Dynamic
Yes Yes Yes Global No
Yes Yes Yes Global No
    Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
    Yes Both Yes
    Yes Both Yes
Yes Yes Yes Varies Yes
    Yes Global Yes
    Yes Global No
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Varies Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
    Yes Both Yes
    Yes Both Yes
    Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Global No
Yes Yes     No
- Variable:      Yes Global No
    Yes Both Yes
    Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
    Yes Varies No
    Yes Varies No
Yes Yes Yes Both Yes
    Yes Varies Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Session No
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global Yes
    Yes Session No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
    Yes Varies Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Session Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Varies
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
    Yes Global No
Yes Yes Yes Global No
    Yes Session Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
    Yes Global No
    Yes Global No
Yes Yes     No
- Variable:      Yes Global No
    Yes Session Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes     No
- Variable:      Yes Global No
    Yes Both Yes
    Yes Global No
    Yes Global Yes
Yes Yes Yes Both Yes
    Yes Global No
Yes Yes Yes Global Yes
    Yes Global No
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Global Yes
log-bin-trust-routine-creators Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
    Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
    Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
    Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
    Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
    Yes Both Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
Yes   Yes Both Yes
Yes   Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
    Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
    Yes Global Yes
Yes Yes Yes Global No
    Yes Session Yes
    Yes Session Yes
    Yes Both No
    Yes Both Yes
Yes Yes Yes Both Yes
    Yes Global No
    Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
    Yes Global No
Yes   Yes Both Yes
Yes   Yes Both Yes
    Yes Global Yes
Yes   Yes Both Yes
Yes   Yes Both Yes
    Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Both Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Both Yes
    Yes Varies Yes
Yes Yes Yes Both Yes
    Yes Global No
    Yes Session No
    Yes Session Yes
    Yes Session Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
    Yes Session Yes
    Yes Session Yes
Yes Yes Yes Both Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
    Yes Global Yes
    Yes Global Yes
    Yes Global Yes
    Yes Global Yes
    Yes Global Yes
    Yes Global Yes
    Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global No
    Yes Global No
Yes Yes Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
    Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes     Yes
- Variable:      Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Both Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Session Yes
    Yes Both Yes
    Yes Both Yes
Yes Yes     Yes
- Variable:      Yes Both Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Varies Yes
    Yes Both Yes
    Yes Global Yes
    Yes Varies Yes
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
Yes Yes     No
- Variable:      Yes Global No
    Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global Yes
    Yes Global No
    Yes Global Yes
Yes Yes Yes Global Yes
    Yes Global Yes
    Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Global No
Yes Yes Yes Both Yes
Yes Yes Yes Global Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Global Yes
Yes Yes Yes Global No
    Yes Varies No
    Yes Both Yes
Yes Yes Yes Global Yes
    Yes Session Yes
Yes Yes Yes Both Yes
Yes Yes Yes Global No
Yes Yes Yes Both Yes
    Yes Session Yes
Yes Yes Yes Both Yes
    Yes Both Yes
    Yes Varies Yes
Yes Yes Yes Both Yes
    Yes Global No
    Yes Global No
    Yes Global No
    Yes Global No
Yes Yes Yes Both Yes
    Yes Session No

This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.

This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.

转载地址：http://odwox.baihongyu.com/

你可能感兴趣的文章
Linux mail 命令
查看>>
Spring中的BeanPostProcessor接口
查看>>
查看索引使用的情况
查看>>
Javascript中的0,false,null,undefined,空字符串对比
查看>>
Ansi与Unicode及慎用W2A等
查看>>
IDEA 连接 GIT OSCHINA 提交本地已存在的项目
查看>>
（转）编程思想之多线程与多进程(1)——以操作系统的角度述说线程与进程
查看>>
Skynet 初探（2） 之 snax 版的 echo 复读机
查看>>
EFI分区如何删除
查看>>
<JUnit>单元测试用例
查看>>
【Java集合源码剖析】TreeMap源码剖析
查看>>
读取oracle注释
查看>>
二叉树
查看>>
Laravel 5.1 artisan 的使用
查看>>
Maven 学习之旅
查看>>
C Primer Plus 第5章 运算符、表达式和语句 编程练习及答案
查看>>
Python点滴
查看>>
WINDOWS 几种坐标系
查看>>
运行gulp项目报错：AssertionError: Task function must be specified。
查看>>
大豆和黄豆芽还能吃吗？
查看>>
喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！-- 愿君每日到此一游！
当前时间: 2024-12-29 06:59:49   当前IP: 3.145.85.123   联系邮箱:javaeecc@qq.com     Copyright © 2020 - 2022 baihongyu.com 京ICP备2021015314号-2
强烈建议你试试无所不能的CHAT-GPT，快点击我
强烈建议你试试无所不能的CHAT-GPT，快点击我