mysql.conf配置笔记

[client]
#password=123456
[mysqld]

max_connections = 10000
innodb_buffer_pool_size = 1G

#指定单个查询可以使用的缓冲区的大小，一般默认值是1M
query_cache_limit = 4M

#查询的缓存大小设置
#query_cache_size = 1024M

character_set_server    =    utf8mb4
collation_server    =    utf8mb4_unicode_ci 
default-time_zone    =     '+8:00'

pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
#log-error      = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0