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=/home/mysql/docker-data/3307/data
    21. #socket=/home/mysql/docker-data/3307/mysql.sock
    23. character_set_server=utf8
    24. init_connect='SET NAMES utf8'
    26. # Disabling symbolic-links is recommended to prevent assorted security risks
    27. symbolic-links=0
    29. #log-error=/home/mysql/docker-data/3307/logs/mysqld.log
    30. #pid-file=/home/mysql/docker-data/3307/mysqld.pid
    31. lower_case_table_names=1
    32. server-id=1403311
    33. log-bin=mysql-bin
    34. auto_increment_increment=2
    35. auto_increment_offset=1
    37. #rpl_semi_sync_master_enabled=1
    38. #rpl_semi_sync_master_timeout=10000