Works On

Viewing:

Red Hat Enterprise Linux 9 (Plow)

Same on:

Other versions:

Red Hat Enterprise Linux 8 (Ootpa) CentOS Stream 9

Details

Size: 26 lines
MD5: fe2f3d6d19d68dd1363a1dfc7b757c95
SHA256: 9c8b66aec85e40c595bd1b3324db589622aed377cc56bb69d237baeba4fcb302

/etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Copy & Paste

curl:

curl https://exampleconfig.com/api/v1/config/original/fe2f3d6d19d68dd1363a1dfc7b757c95?hint=my.cnf

wget:

wget -O my.cnf https://exampleconfig.com/api/v1/config/original/fe2f3d6d19d68dd1363a1dfc7b757c95?hint=my.cnf

For AI Agents

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/fe2f3d6d19d68dd1363a1dfc7b757c95?hint=my.cnf' /><config><app>MySQL</app><os>Red Hat Enterprise Linux 9 (Plow)</os><location>/etc/my.cnf</location><lines>26</lines><md5>fe2f3d6d19d68dd1363a1dfc7b757c95</md5><sha256>9c8b66aec85e40c595bd1b3324db589622aed377cc56bb69d237baeba4fcb302</sha256></config></prompt>

Paste into Claude, ChatGPT, or any AI assistant.

Install 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

File Location

File Path

/etc/my.cnf

FAQ

When should I use this my.cnf?

Use it to restore a missing default, confirm what shipped, or diff against your current MySQL config.

How do I restore MySQL defaults?

Download the file, back up the current one in /etc/my.cnf, replace it, then reload or restart MySQL.

Is my.cnf safe for production?

It is the vendor default for Red Hat Enterprise Linux 9 (Plow). Treat it as a baseline and review security and performance settings before production use.

How does this differ from other OS versions?

Defaults vary by distro and version. This copy matches Red Hat Enterprise Linux 9 (Plow).

Can I use this for MySQL troubleshooting?

Yes. Diff it against yours to find drift, then restore only the sections you need.

MySQL /etc/my.cnf