MYSQL配置
[mysqld]
character_set_server=utf8
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql
symbolic-links=0
old_passwords = 1 -- 密码不能是原密码
lower_case_table_names = 1 -- 忽略表的大小写
character-set-server = utf8 -- 服务端的设置字符编码
default-storage-engine = MYISAM -- 默认数据库引擎
expire_logs_days = 30
ft_min_word_len = 4
back_log = 512
max_allowed_packet = 64M
max_connections = 1000
max_connect_errors = 100
join_buffer_size = 8M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
table_open_cache = 1000
thread_cache_size = 256
max_heap_table_size = 64M
tmp_table_size = 64M
thread_stack = 192K
thread_concurrency = 8
local-infile = 0
skip-show-database
skip-name-resolve
skip-external-locking
connect_timeout = 600
interactive_timeout = 600
wait_timeout = 600
#### MyISAM
key_buffer_size = 1024M
bulk_insert_buffer_size =64M
myisam_sort_buffer_size = 512M
myisam_max_sort_file_size = 1G
myisam_repair_threads = 1
concurrent_insert = 2
myisam_recover
table_cache = 2048
max_allowed_packet = 32M
max_heap_table_size = 128M
sort_buffer_size = 16M
join_buffer_size= 16M
thread_cache_size = 16
thread_concurrency = 8
query_cache_size = 128M
ft_min_word_len = 8
thread_stack = 512K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 128M
[mysqld_safe]
log-error=/data/mysql/mysqld.log
pid-file=/data/mysql/mysqld.pid
[client]
default-character-set = utf8
[mysql]
default-character-set = utf8
