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