my.cnf 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. # For advice on how to change settings please see
  2. # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
  3. [mysqld]
  4. #
  5. # Remove leading # and set to the amount of RAM for the most important data
  6. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  7. # innodb_buffer_pool_size = 128M
  8. #
  9. # Remove leading # to turn on a very important data integrity option: logging
  10. # changes to the binary log between backups.
  11. # log_bin
  12. #
  13. # Remove leading # to set options mainly useful for reporting servers.
  14. # The server defaults are faster for transactions and fast SELECTs.
  15. # Adjust sizes as needed, experiment to find the optimal values.
  16. # join_buffer_size = 128M
  17. # sort_buffer_size = 2M
  18. # read_rnd_buffer_size = 2M
  19. skip-host-cache
  20. skip-name-resolve
  21. datadir=/var/lib/mysql
  22. socket=/var/lib/mysql/mysql.sock
  23. secure-file-priv=/var/lib/mysql-files
  24. user=mysql
  25. # Disabling symbolic-links is recommended to prevent assorted security risks
  26. symbolic-links=0
  27. log-error=/var/log/mysqld.log
  28. pid-file=/var/run/mysqld/mysqld.pid
  29. server-id=2
  30. relay-log=/var/lib/mysql/mysql-relay-bin.log
  31. log_bin=/var/lib/mysql/mysql-bin.log
  32. binlog_do_db=xbrlgen