MySQL常用配置點

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[client] #default-character-set = utf8 character-set-server = utf8 # 解決 mysqlbinlog unknown variable 'default-character-set=utf8'[mysqldump] # 導出db時，可以省去密碼操作 user=<用戶名> password=<密碼>[mysqld] port=<端口號> # 更改之后，記得修改防火墻端口 #default-storage-engine = INNODB character-set-server = utf8 collation-server = utf8_general_ci #collation-server = utf8_bin #collation-server = utf8_unicode_ci # 最大用戶連接數 4 # max_user_connections 4 # 禁止MySQL對本地文件存取 # local-infile=0# 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 = 512M# Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. log-bin=/var/lib/mysql/binlog.index server-id=1 # 主從復制格式(mixed[易查看], statement,row, 默認為statement) binlog_format=MIXED # 要同步的數據庫 binlog-do-db= db1 binlog-do-db= db2 # 忽略同步的數據庫 binlog-ignore-db=mysql # 二進制日志自動刪除/過期的天數.默認值0,表示不刪除 expire_logs_days=15# 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=/var/lib/mysql socket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0log-error=/var/log/mysqld.log # log=/home/indirection/log/mysql/.mysql_history pid-file=/var/run/mysqld/mysqld.pid# slow query log slow_query_log=ON #slow_query_log_file=/home/indirection/log/mysql/slow_query.log long_query_time=0.1 log_output=table # table:日志記錄存在mysql.slow_log表中 log-queries-not-using-indexes # 不使用索引的查詢捕獲到日志中bind-address=:: max_allowed_packet = 20M# 禁止域名解析,解決連接慢的問題 skip-name-resolve innodb_flush_log_at_trx_commit=0 sync_binlog=0

總結

以上是生活随笔為你收集整理的【MySQL】常用配置的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。