首页 > 数据库技术 > 详细

mysql配置文件my.cnf整理

时间:2014-06-22 10:52:58      阅读:419      评论:0      收藏:0      [点我收藏+]

随时修改:

 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

 

mysql配置文件my.cnf整理,布布扣,bubuko.com

mysql配置文件my.cnf整理

原文:http://www.cnblogs.com/nortorm/p/3801741.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!