| 123456789101112131415161718192021222324252627282930313233343536373839 | # Percona Server template configuration[mysqld]## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockcharacter-set-server=utf8lower_case_table_names=1# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-error=/var/lib/mysql/error.logslow_query_log=on;slow-query-log-file=/var/lib/mysql/mysql-slow.logpid-file=/var/run/mysqld/mysqld.pidsql_mode = STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION[mysql]default-character-set=utf8[client]default-character-set=utf8
 |