mysql配置文件my.cnf整理

随时修改：

 1 [mysqld]
 2 #basedir=
 3 datadir=/var/lib/mysql
 4 #mysql.default_port=3306
 5 #mysql.default_socket=/tmp/mysql.sock
 6 socket=/var/lib/mysql/mysql.sock
 7 #socket=/tmp/mysql.sock
 8 user=mysql
 9 # Disabling symbolic-links is recommended to prevent assorted security risks
10 symbolic-links=0
11 max_allowed_packet=32M
12 event_scheduler = 0
13 character-set-server = utf8
14 collation-server = utf8_general_ci
15 character-set-server = utf8
16 collation-server = utf8_general_ci
17 net_read_timeout = 60
18 interactive_timeout = 1000
19 wait_timeout = 1000
20 open_files_limit = 8192
21 back_log = 1024
22 max_connections = 1000
23 max_connect_errors = 100000
24 log-output=file
25 slow_query_log = 1
26 slow_query_log_file = slow.log
27 log-error = error.log
28 log_warnings = 2
29 pid-file = mysql.pid
30 long_query_time = 1
31 log-slow-admin-statements = 0
32 log-queries-not-using-indexes = 0
33 log-slow-slave-statements = 0
34 sort_buffer_size = 2M
35 join_buffer_size = 2M
36 thread_cache_size = 256
37 thread_stack = 192K
38 key_buffer_size = 8M
39 read_buffer_size = 2M
40 read_rnd_buffer_size = 16M
41 bulk_insert_buffer_size = 64M
42 
43 
44 [mysqld_safe]
45 log-error=/var/log/mysqld.log
46 pid-file=/var/run/mysqld/mysqld.pid
47 default-character-set = utf8
48 
49 
50 [mysql]
51 prompt = "\\u@\\h \\R:\\m:\\s [\\d]&get: "
52 pager = "less -i -n -S"
53 no-auto-rehash
54 tee = "/var/log/mysql/tee.log"
55 default-character-set = utf8
56 
57 [mysql.server]
58 default-character-set = utf8
59 
60 [client]
61 default-character-set = utf8

 

转载于:https://www.cnblogs.com/nortorm/p/3801741.html