my.cnf 796 B

123456789101112131415161718192021222324252627
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. # Disabling symbolic-links is recommended to prevent assorted security risks
  5. symbolic-links=0
  6. # Settings user and group are ignored when systemd is used.
  7. # If you need to run mysqld under a different user or group,
  8. # customize your systemd unit file for mariadb according to the
  9. # instructions in http://fedoraproject.org/wiki/Systemd
  10. # skip domain name resolve
  11. skip_name_resolve
  12. # auto delete binlog older than 30 days
  13. expire_logs_days=30
  14. innodb_file_per_table=ON
  15. max_connections = 300
  16. max_allowed_packet=20M
  17. group_concat_max_len=20M
  18. default_time_zone='+00:00'
  19. [mysqld_safe]
  20. log-error=/var/log/mariadb/mariadb.log
  21. pid-file=/var/run/mariadb/mariadb.pid
  22. #
  23. # include all files from the config directory
  24. #
  25. !includedir /etc/my.cnf.d