1 # For advice on how to change settings please see

  2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

  3 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

  4 # *** default location during install, and will be replaced if you

  5 # *** upgrade to a newer version of MySQL.

  6

  7 [mysqld]

  8

  9 # Remove leading # and set to the amount of RAM for the most important data

 10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

 11 # innodb_buffer_pool_size = 128M

 12

 13 # Remove leading # to turn on a very important data integrity option: logging

 14 # changes to the binary log between backups.

 15 # log_bin

 16

 17 # These are commonly set, remove the # and set as required.

 18 # basedir = .....

 19 # datadir = .....

 20 # port = .....

 21 # server_id = .....

 22 # socket = .....

 23

 24 # Remove leading # to set options mainly useful for reporting servers.

 25 # The server defaults are faster for transactions and fast SELECTs.

 26 # Adjust sizes as needed, experiment to find the optimal values.

 27 # join_buffer_size = 128M

 28 # sort_buffer_size = 2M

 29 # read_rnd_buffer_size = 2M

 30

 31

 32 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

 33