确定正在使用的 MySQL 配置文件

2021-11-20 00:00:00 configuration mysql

是否有命令可以确定 MySQL 5.0 当前使用的是哪个配置文件?

Is there a command to determine which configuration file MySQL 5.0 is currently using?

推荐答案

如果你在 Linux 上，那么用 strace 启动 'mysqld'，例如 strace ./mysqld.

If you are on Linux, then start the 'mysqld' with strace, for eg strace ./mysqld.

在所有其他系统调用中，您会发现如下内容:

Among all the other system calls, you will find something like:

stat64("/etc/my.cnf", 0xbfa3d7fc)       = -1 ENOENT (No such file or directory)
stat64("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=4227, ...}) = 0
open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3

所以，如您所见..它列出了它尝试使用并最终使用的 .cnf 文件.

So, as you can see..it lists the .cnf files, that it attempts to use and finally uses.

相关文章