[root@sf106131 logs]# which mysqld
/usr/sbin/mysqld
[root@sf106131 logs]# /usr/sbin/mysqld --verbose --help |grep -A 1 'Default options'
2020-05-12 08:44:03 0 [Warning] Using unique option prefix thread_cache instead of thread_cache_size is deprecated and will be removed in a future release. Please use the full name instead.
2020-05-12 08:44:03 4184 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
1 首先通过which mysqld 查看mysqld位置。
2 mysqld路径 --verbose --help |grep -A 1 'Default options'
/usr/sbin/mysqld --verbose --help |grep -A 1 'Default options'