本文介绍了如何使用mysqld命令来查看MySQL服务器的实际配置及参数设置。通过运行特定命令，可以获取服务器使用的默认配置文件路径及各项参数的具体值。此外，还提供了运行中MySQL服务器参数查询的方法。
尝试运行mysqld --verbose --help以查看mysqld实际读取的配置文件以及使用的参数和值。
输出将如下所示：
mysqld Ver 5.0.51a-24-log for debian-linux-gnu on x86_64 ((Debian))
Copyright (C) 2000 MySQL AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Default options are read from the following files in the given order:
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf
The following groups are read: mysql_cluster mysqld server mysqld-5.0
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
...
To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
