[root@rocky9 ~]# cat /etc/my.cnf
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include *.cnf from the config directory
#
#!includedir /etc/my.cnf.d
[mysqld]

## General
ignore-db-dirs                        = lost+found
datadir                               = /var/lib/mysql
socket                                = /var/lib/mysql/mysql.sock
tmpdir                                = /var/lib/mysqltmp
optimizer-switch                      = "index_merge_intersection=off"
sql-mode                              = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

## Cache
table-definition-cache                = 8192
table-open-cache                      = 8192
thread-cache-size                     = 64
query-cache-size                      = 0
query-cache-type                      = 0

## Per-thread Buffers
#join-buffer-size                     = 512K
#read-buffer-size                     = 512K
#read-rnd-buffer-size                 = 512K
#sort-buffer-size                     = 512K

## Temp Tables
#max-heap-table-size                  = 64M
#tmp-table-size                       = 32M

## Networking
#interactive-timeout                  = 3600
max-connections                       = 2048
max-connect-errors                    = 1000000
max-allowed-packet                    = 16M
skip-name-resolve
wait-timeout                          = 600

## MyISAM
key-buffer-size                       = 32M
#myisam-recover                        = FORCE,BACKUP
myisam-recover-options                = FORCE,BACKUP
myisam-sort-buffer-size               = 512M

## InnoDB
innodb-adaptive-hash-index-parts      = 8
innodb-buffer-pool-size               = 128M
#innodb-buffer-pool-populate           = 1
innodb-checksum-algorithm             = crc32
innodb-file-format                    = Barracuda
innodb-file-per-table                 = 1
innodb-flush-method                   = O_DIRECT
innodb-flush-neighbors                = 0
innodb-io-capacity                    = 500
innodb-io-capacity-max                = 2500
innodb-log-file-size                  = 1G
innodb-lru-scan-depth                 = 2500
innodb-open-files                     = 8192
innodb-purge-threads                  = 4
innodb-sort-buffer-size               = 4M
innodb-stats-on-metadata              = 0
innodb-undo-tablespaces               = 4

## Replication and PITR
binlog-format                         = ROW
binlog-row-image                      = minimal
expire-logs-days                      = 2
log-bin                               = /var/lib/mysqllogs/bin-log
log-slave-updates                     = 1
max-binlog-size                       = 8M
#read-only                            = 1
relay-log                             = /var/lib/mysqllogs/relay-log
relay-log-recovery                    = ON
slave-net-timeout                     = 5
server-id                             = 133061
sync-binlog                           = 1
#skip-slave-start  = 1

## Logging
log-output                            = FILE
log-slow-admin-statements
log-slow-slave-statements
#log-warnings                         = 0
long-query-time                       = 5
log-slow-verbosity                    = 'innodb,query_plan'
slow-query-log                        = 1
slow-query-log-file                   = /var/lib/mysqllogs/slow-log

log-error                             = /var/log/mysqld.log

[mysqld_safe]
log-error                             = /var/log/mysqld.log
open-files-limit                      = 16000

[mysql]
no-auto-rehash