Mysql常用配置文件参数设置 [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 = 2M datadir=http://www.likecs.com/var/lib/mysql socket=http://www.likecs.com/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 slave_skip_errors=1396 log-error=http://www.likecs.com/var/log/mysqld.log pid-file=http://www.likecs.com/var/run/mysqld/mysqld.pid character-set-server=utf8 collation-server=utf8_general_ci max_connections=2000 key_buffer_size=512M innodb_buffer_pool_size=90G innodb_log_buffer_size=32M read_buffer_size=4M sort_buffer_size=32M read_rnd_buffer_size=64M thread_cache_size=128 query_cache_type=1 query_cache_size=512M query_cache_limit=10M max_allowed_packet=256M log-bin=mysql-bin server-id=1 replicate-ignore-db=information_schema replicate-ignore-db=mysql replicate-ignore-db=performance_schema replicate-ignore-db=sys master-info-repository=table relay-log-info-repository=table sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION