CentOS系统MySQL的配置文件my.cnf

龙 宇 2016-7-27 微信营销 0 0

这篇文章主要内容是前文 《2015博客升级记(四):CentOS 7.1编译安装mysql5.7.7rc》 提到的MySQL的配置文件my.cnf。

需要注意的是my.cnf中的一些配置需要和MySQL5.7.7rc编译安装时的一些配置保持一致。例如,MySQL的socket文件 /var/run/mysql/mysql.sock 路径在MySQL5.7.7rc编译安装时,需要创建 /var/run/mysql/ 文件路径。也就是my.cnf的配置是由编译MySQL时配置的内容决定的。

由于MySQL的配置明细不多,所以这里就直接将my.cnf的全部内容贴出来了。

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [client] port=3306 socket=/var/run/mysql/mysql.sock [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 # These are commonly set, remove the # and set as required. user = mysql basedir = /usr/local/mysql datadir = /mydata/mysql/data port=3306 server-id = 1 socket=/var/run/mysql/mysql.sock character-set-server = utf8 log-error = /var/log/mysql/error.log pid-file = /var/log/mysql/mysql.pid general_log = 1 skip-name-resolve #skip-networking back_log = 300 max_connections = 1000 max_connect_errors = 6000 open_files_limit = 65535 table_open_cache = 128 max_allowed_packet = 4M binlog_cache_size = 1M max_heap_table_size = 8M tmp_table_size = 16M read_buffer_size = 2M read_rnd_buffer_size = 8M sort_buffer_size = 8M join_buffer_size = 28M key_buffer_size = 4M thread_cache_size = 8 query_cache_type = 1 query_cache_size = 8M query_cache_limit = 2M ft_min_word_len = 4 log_bin = mysql-bin binlog_format = mixed expire_logs_days = 30 performance_schema = 0 explicit_defaults_for_timestamp #lower_case_table_names = 1 myisam_sort_buffer_size = 8M myisam_repair_threads = 1 interactive_timeout = 28800 wait_timeout = 28800 # 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 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Recommended in standard MySQL setup sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 8M sort_buffer_size = 8M read_buffer = 4M write_buffer = 4M

和前文 《2015博客升级记(六):Nginx配置HTTPS和SPDY实战》 的Nginx配置文件 nginx.conf 一样,这个MySQL的配置文件 my.cnf 也托管在下面这两个 LNMP配置工程 上,以后有任何的修改都会更新到这上面。

GitHub地址: https://github.com/vfhky/mylnmp ;

Coding地址: https://coding.net/u/vfhky/p/mylnmp/git 。

本文数据库(mysql)相关术语:navicat for mysql mysql workbench mysql数据库 mysql 存储过程 mysql安装图解 mysql教程 mysql 管理工具

原文地址:http://www.77169.com/classical/HTML/203521.shtm

转载请注明来自华盟网,本文标题:《CentOS系统MySQL的配置文件my.cnf》

喜欢 (0) 发布评论
发表评论