MySQL Variables lower_case_file_system 数据库 参数变量解释及正确配置使用
本站中文解释
MySQL参数lower_case_file_system指的是数据库字段文件名是否小写。这个参数允许MySQL索引文件系统中的索引文件名字是否为小写。
设置此参数的值是通过my.cnf配置文件来完成的,其语法如下:
[mysqld]
lower_case_file_system=Value
Value的取值有以下三种:
0:启用混合大小写文件名;
1:只允许小写文件名;
2:只允许小写文件名,并且不允许大写字母和特殊字符;
lower_case_file_system参数最好在安装MySQL时设置,因为在MySQL服务器运行时,修改此参数将会影响系统中数据文件的完整性。
官方英文解释
lower_case_file_system
System Variable | lower_case_file_system |
---|---|
Scope | Global |
Dynamic | No |
Type | Boolean |
This variable describes the case sensitivity of file names on
the file system where the data directory is located.
OFF
means file names are case-sensitive,
ON
means they are not case-sensitive. This
variable is read only because it reflects a file system
attribute and setting it would have no effect on the file
system.