MariaDB /etc/my.cnf

Original ๐Ÿ“‹ CentOS Stream 9 31 lines

Works On

Viewing:
CentOS Stream 9
Same on:
Other versions:

Details

Size
31 lines
MD5
ea34d282649767d69a65a33231244e75
SHA256
1734fab49caed23761597f11d81acd181b14d5beb2e1a88090e6f42cd3c0348d

Copy & Paste

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

For AI Agents

You are a DevOps agent. Fetch the default MariaDB config for CentOS Stream 9 from https://exampleconfig.com/api/v1/config/original/ea34d282649767d69a65a33231244e75?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.0/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
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password

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

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

Install MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

File Location

File Path
/etc/my.cnf
Directory
/etc/
Significance
System-wide configuration directory
Description
Files in /etc/ contain system-wide configuration settings that affect all users.

FAQ

When should I use this my.cnf?

Restore it. Compare it. Start clean.

How do I restore MariaDB 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 CentOS Stream 9.

Can I use this for MariaDB troubleshooting?

Absolutely. Diff this against yours to spot the problem.