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 risks10 symbolic-links=011 max_allowed_packet=32M12 event_scheduler = 013 character-set-server = utf814 collation-server = utf8_general_ci15 character-set-server = utf816 collation-server = utf8_general_ci17 net_read_timeout = 6018 interactive_timeout = 100019 wait_timeout = 100020 open_files_limit = 819221 back_log = 102422 max_connections = 100023 max_connect_errors = 10000024 log-output=file25 slow_query_log = 126 slow_query_log_file = slow.log27 log-error = error.log28 log_warnings = 229 pid-file = mysql.pid30 long_query_time = 131 log-slow-admin-statements = 032 log-queries-not-using-indexes = 033 log-slow-slave-statements = 034 sort_buffer_size = 2M35 join_buffer_size = 2M36 thread_cache_size = 25637 thread_stack = 192K38 key_buffer_size = 8M39 read_buffer_size = 2M40 read_rnd_buffer_size = 16M41 bulk_insert_buffer_size = 64M42 43 44 [mysqld_safe]45 log-error=/var/log/mysqld.log46 pid-file=/var/run/mysqld/mysqld.pid47 default-character-set = utf848 49 50 [mysql]51 prompt = "\\u@\\h \\R:\\m:\\s [\\d]&get: "52 pager = "less -i -n -S"53 no-auto-rehash54 tee = "/var/log/mysql/tee.log"55 default-character-set = utf856 57 [mysql.server]58 default-character-set = utf859 60 [client]61 default-character-set = utf8