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
