时间戳

首页 > 解决方案 > 选项文件不影响 MySQL 5.6 客户端

mysql - 选项文件不影响 MySQL 5.6 客户端

问题描述

我创建了一个选项文件 C:\my.ini

[mysqld]
basedir=C:\Program Files\MySQL\MySQL Server 5.6
datadir=C:\Program Files\MySQL\MySQL Server 5.6\data
innodb_buffer_pool_size=6710886400
innodb_file_per_table=ON
innodb_file_format=Barracuda
innodb_large_prefix=ON
local_infile=ON

我可以看到设置在mysqld.exe --help --verbose.

但是，当我从 MySQL 客户端查询系统变量时，设置无效。

mysql> select
    ->
    -> @@innodb_large_prefix as innodb_large_prefix,
    -> @@innodb_file_format as innodb_file_format,
    -> @@innodb_file_per_table as innodb_file_per_table,
    -> @@local_infile as local_infile;
+---------------------+--------------------+-----------------------+--------------+
| innodb_large_prefix | innodb_file_format | innodb_file_per_table | local_infile |
+---------------------+--------------------+-----------------------+--------------+
|                   0 | Antelope           |                     1 |            1 |
+---------------------+--------------------+-----------------------+--------------+
1 row in set (0.00 sec)

我在 Windows 10 上安装了 MySQL 5.6 作为 Windows 服务。

标签： mysql

解决方案

推荐阅读