2
0

mysqld.cnf 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. # Percona Server template configuration
  2. [mysqld]
  3. #
  4. # Remove leading # and set to the amount of RAM for the most important data
  5. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  6. # innodb_buffer_pool_size = 128M
  7. #
  8. # Remove leading # to turn on a very important data integrity option: logging
  9. # changes to the binary log between backups.
  10. # log_bin
  11. #
  12. # Remove leading # to set options mainly useful for reporting servers.
  13. # The server defaults are faster for transactions and fast SELECTs.
  14. # Adjust sizes as needed, experiment to find the optimal values.
  15. # join_buffer_size = 128M
  16. # sort_buffer_size = 2M
  17. # read_rnd_buffer_size = 2M
  18. datadir=/var/lib/mysql
  19. socket=/var/lib/mysql/mysql.sock
  20. character-set-server=utf8
  21. lower_case_table_names=1
  22. # Disabling symbolic-links is recommended to prevent assorted security risks
  23. symbolic-links=0
  24. log-error=/var/lib/mysql/error.log
  25. slow_query_log=on;
  26. slow-query-log-file=/var/lib/mysql/mysql-slow.log
  27. pid-file=/var/run/mysqld/mysqld.pid
  28. sql_mode = STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION
  29. [mysql]
  30. default-character-set=utf8
  31. [client]
  32. default-character-set=utf8