MySQL /etc/mysql/conf.d/mysql.cnf

原始 📋 Debian 10 (Buster) 29 行

详情

大小
29 行
MD5
1185fcf42327b869472c3a0d36d44f22
SHA256
c9823922daeae30ae72a463ba435a85d915711410d8626fb67a7b8ba2a0c1523
/etc/mysql/conf.d/mysql.cnf
# Copyright (c) 2015, 2023, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms,
# as designated in a particular file or component or in included license
# documentation.  The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA

#
# The MySQL  Client configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysql]

复制粘贴

curl:
curl https://exampleconfig.com/api/v1/config/original/1185fcf42327b869472c3a0d36d44f22?hint=mysql.cnf
wget:
wget -O mysql.cnf https://exampleconfig.com/api/v1/config/original/1185fcf42327b869472c3a0d36d44f22?hint=mysql.cnf

给 AI Agent 用

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/1185fcf42327b869472c3a0d36d44f22?hint=mysql.cnf' /><config><app>MySQL</app><os>Debian 10 (Buster)</os><location>/etc/mysql/conf.d/mysql.cnf</location><lines>29</lines><md5>1185fcf42327b869472c3a0d36d44f22</md5><sha256>c9823922daeae30ae72a463ba435a85d915711410d8626fb67a7b8ba2a0c1523</sha256></config></prompt>

粘贴到 Claude、ChatGPT 或任何 AI 助手里。

安装 MySQL

Debian

sudo apt update && sudo apt install mysql-server

Red Hat Enterprise Linux

sudo yum install mysql-server

Ubuntu

sudo apt update && sudo apt install mysql-server

文件位置

文件路径
/etc/mysql/conf.d/mysql.cnf
目录
/etc/mysql/conf.d/
用途
系统级配置目录
说明
/etc/ 里的文件是系统级配置,影响所有用户。

FAQ

什么时候该用这个 mysql.cnf?

用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MySQL config 做 diff。

怎么恢复 MySQL 的默认配置?

下载文件,把 /etc/mysql/conf.d/mysql.cnf 里的当前配置备份好,替换掉,然后 reload 或 restart MySQL。

mysql.cnf 适合直接上生产吗?

这是 Debian 10 (Buster) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。

和其他 OS 版本有什么不同?

默认值会随发行版和版本变化,这份对应 Debian 10 (Buster)。

我可以用它来排查 MySQL 吗?

可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。