什么时候该用这个 mariadb.cnf?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
# The MariaDB configuration file # # The MariaDB/MySQL tools read configuration files in the following order: # 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read. # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults, # 2. "/etc/mysql/conf.d/*.cnf" to set global options. # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options. # 4. "~/.my.cnf" to set user-specific options. # # If the same option is defined multiple times, the last one will apply. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/ # # This group is read both by the client and the server # use it for options that affect everything # [client-server] # Port or socket location where to connect # port = 3306 socket = /run/mysqld/mysqld.sock # Import all .cnf files from configuration directory !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mariadb.conf.d/
curl https://exampleconfig.com/api/v1/config/original/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf
wget -O mariadb.cnf https://exampleconfig.com/api/v1/config/original/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf
<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/f78499dd07dccc3238cc15dd937b87bb?hint=mariadb.cnf' /><config><app>MariaDB</app><os>Ubuntu 24.04 LTS (Noble Numbat)</os><location>/etc/mysql/mariadb.cnf</location><lines>29</lines><md5>f78499dd07dccc3238cc15dd937b87bb</md5><sha256>65084b5344fcbae09425c648a9bfb1ff99c1fd0d83f1eff5bc08bf8032de8981</sha256></config></prompt>
粘贴到 Claude、ChatGPT 或任何 AI 助手里。
sudo apk add mariadb
sudo apt update && sudo apt install mariadb-server
sudo yum install mariadb-server
sudo apt update && sudo apt install mariadb-server
什么时候该用这个 mariadb.cnf?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
怎么恢复 MariaDB 的默认配置?
下载文件,把 /etc/mysql/mariadb.cnf 里的当前配置备份好,替换掉,然后 reload 或 restart MariaDB。
mariadb.cnf 适合直接上生产吗?
这是 Ubuntu 24.04 LTS (Noble Numbat) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。
和其他 OS 版本有什么不同?
默认值会随发行版和版本变化,这份对应 Ubuntu 24.04 LTS (Noble Numbat)。
我可以用它来排查 MariaDB 吗?
可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。