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

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

You are a DevOps agent. Fetch the default MySQL config for Red Hat Enterprise Linux 9 (Plow) from https://exampleconfig.com/api/v1/config/original/fe2f3d6d19d68dd1363a1dfc7b757c95?hint=my.cnf. Compare with my current /etc/my.cnf and summarize differences and safe changes.

Copy this prompt into Claude, ChatGPT, or other AI assistants.

/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

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?

Restore it. Compare it. Start clean.

How do I restore MySQL defaults?

Download, replace, restart.

Is my.cnf safe for production?

Yes. This is exactly what shipped. Safe starting point.

How does this differ from other OS versions?

Defaults change. This one is specific to Red Hat Enterprise Linux 9 (Plow).

Can I use this for MySQL troubleshooting?

Absolutely. Diff this against yours to spot the problem.

MySQL /etc/my.cnf