centos 下 mysql 5.7 参考配置文件 

 1 [client]
 2 port = 3306
 3 socket = /data/tmp/mysql/mysql.sock
 4 
 5 [mysqld]
 6 port = 3306
 7 socket = /data/tmp/mysql/mysql.sock
 8 user = mysql
 9 
10 basedir = /data/app/mysql
11 datadir = /data/appdata/mysql
12 pid-file = /data/tmp/mysql/mysql.pid
13 
14 log_error = /data/logs/mysql/mysql-error.log
15 slow_query_log = 1
16 long_query_time = 1
17 slow_query_log_file = /data/logs/mysql/mysql-slow.log
18 
19 general_log = OFF
20 general_log_file = /data/logs/mysql/general.log
21 
22 skip-external-locking
23 key_buffer_size = 32M
24 max_allowed_packet = 256M
25 table_open_cache = 128
26 sort_buffer_size = 768K
27 net_buffer_length = 8K
28 read_buffer_size = 768K
29 read_rnd_buffer_size = 512K
30 myisam_sort_buffer_size = 8M
31 thread_cache_size = 16
32 query_cache_size = 16M
33 tmp_table_size = 32M
34 performance_schema_max_table_instances = 1000
35 
36 explicit_defaults_for_timestamp = true
37 #skip-networking
38 max_connections = 500
39 max_connect_errors = 100
40 open_files_limit = 65535
41 
42 server_id   = 1
43 log_bin= /data/appdata/mysql/mysql-bin
44 binlog_format = mixed
45 expire_logs_days = 10
46 early-plugin-load = ""
47 
48 default_storage_engine = InnoDB
49 innodb-file-per-table = 1
50 innodb_buffer_pool_size = 128M
51 innodb_log_file_size = 32M
52 innodb_log_buffer_size = 8M
53 innodb_flush_log_at_trx_commit = 1
54 innodb_lock_wait_timeout = 50
55 
56 [mysqldump]
57 quick
58 max_allowed_packet = 256M
59 
60 [myisamchk]
61 key_buffer_size = 32M
62 sort_buffer_size = 768K
63 read_buffer = 2M
64 write_buffer = 2M
65 
66 [mysql]
67 #no-auto-rehash
68 auto-rehash
69 prompt=\\u@\\d \\R:\\m  mysql>
70 default-character-set=utf8

 

posted @ 2023-10-05 23:40  gzhq  阅读(73)  评论(0)    收藏  举报