MySQL 基础配置文件

此配置文件摘自 《高性能MySQL》

[mysqld]                                             
# GENRAL

datadir                               = /var/lib/mysql

socket                                      =/var/lib/mysql/mysql.sock

pid_file                                     = /var/lib/mysql/mysql.pid

user                                         = mysql

port                                           = 3306

default_storage_engine         = InnoDB

# INNODB
innodb_buffer_pool_size        = <value>

innodb_log_file_size               = <value>
innodb_file_per_table             = 1
innodb_flush_method             = 0_DIRECT

# MyISAM

key_buffer_size                        = <value>

log_error                                   = /var/lib/mysql/mysql-error.log

slow_query_log                        =/var/lib/mysql/mysql-show.log

# OTHER

tmp_table_size                         = 32M

max_heap_table_size              = 32M

query_cache_type                  = 0
query_cache_size                    = 0
max_connections                    = <value> 
thread_cache                           = <value>
open_files_limit                       = 65535

[client]

socket                                      =/var/lib/mysql/mysql.sock

port                                           = 3306

我们现在用的my.cnf

[mysql]
default-character-set                 = utf8mb4

# CLIENT #
port                                            = 3306
socket                                        = /var/lib/mysql/mysql.sock

[mysqld]
character-set-server                  = utf8mb4

# GENERAL #
user                                          = mysql
default-storage-engine             = InnoDB
socket                                       = /var/lib/mysql/mysql.sock
pid-file                                      = /var/lib/mysql/mysql.pid

# MyISAM #
key-buffer-size                         = 32M
myisam-recover                       = FORCE,BACKUP

# SAFETY #
max-allowed-packet                 = 16M
max-connect-errors                  = 1000000

# DATA STORAGE #
datadir                                      = /var/lib/mysql/

# BINARY LOGGING #
log-bin                                      = /var/lib/mysql/mysql-bin
expire-logs-days                       = 14
sync-binlog                               = 1

# CACHES AND LIMITS #
tmp-table-size                          = 32M
max-heap-table-size                = 32M
query-cache-type                     = 0
query-cache-size                     = 0
max-connections                     = 500
thread-cache-size                    = 50
open-files-limit                         = 65535
table-definition-cache              = 1024
table-open-cache                    = 2048

# INNODB #
innodb-flush-method                   = O_DIRECT
innodb-log-files-in-group             = 2
innodb-log-file-size                      = 128M
innodb-flush-log-at-trx-commit    = 1
innodb-file-per-table                    = 1
innodb-buffer-pool-size               = 1456M

# LOGGING #
log-error                                     = /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes   = 1
slow-query-log                           = 1
slow-query-log-file                     = /var/lib/mysql/mysql-slow.log


#  IDLE timeout
wait_timeout                             = 2880000
interactive-timeout                   = 2880000

skip-name-resolve

推荐一个网站，可以根据你输入的服务器参数帮你生成一个MySQL的配置文件

https://tools.percona.com/