MYSQL5.5.38的my.cnf参数选项设置问题：

doondroar

MYSQL5.5.38的my.cnf参数选项设置问题：
目前我们公司搭建mysql服务器的测试环境，电子商务应用，在64位linux平台上，4核CPU，16G内存，申请的是阿里云服务器ECS.前期估计有1W商家，10~30W用户，业务高峰期大概5000~3万的访问量，请问一下需要怎么配置my.cnf中的参数呢？

yoon

ibdata1:2G;ibdata2:2G:autoextend

innodb_buffer_pool_size = 2G

自己根据自己的空间和内存改下。

yoon

没有固定的，自己调：

[client]
port = 3306
socket = /export/servers/mysql/tmp/mysql.sock


[mysqld]
port = 3306
socket = /export/servers/mysql/tmp/mysql.sock
datadir = /export/servers/mysql/data


#--- GLOBAL ---#
character-set-server = utf8
lower_case_table_names = 1
log-output = FILE
log-error = /export/servers/mysql/log/error.log
#general_log
#general_log_file = /export/servers/mysql/log/mysql.log
pid-file = /export/servers/mysql/tmp/mysql.pid
slow-query-log
slow_query_log_file = /export/servers/mysql/log/slow.log
tmpdir = /export/servers/mysql/tmp/
long_query_time = 0.1
#sync_binlog = 1

#--------------#

thread_concurrency = 16
thread_cache_size = 512
table_open_cache = 16384
table_definition_cache = 16384
sort_buffer_size = 2M
join_buffer_size = 2M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
tmp_table_size = 256M
max_heap_table_size = 256M
open_files_limit = 65535
#query_cache_size = 2G


#--- NETWORK ---#
back_log = 1024
max_allowed_packet = 16M
interactive_timeout = 2147483
wait_timeout = 2147483
skip-external-locking
max-connections = 510
max_user_connections = 500
skip-name-resolve

#--- REPL ---#
server-id = 360360
#log-bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
relay-log = relay-log
replicate-ignore-db = test
log_slave_updates
skip-slave-start


#--- INNODB ---#
default-storage-engine = INNODB
innodb_data_home_dir = /export/servers/mysql/data
innodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextend
innodb_autoextend_increment = 500
innodb_log_group_home_dir = /export/servers/mysql/data
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 128M
innodb_log_files_in_group = 3
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120
innodb_flush_method = O_DIRECT
innodb_max_dirty_pages_pct = 75
innodb_io_capacity = 1000
innodb_thread_concurrency = 32
innodb_open_files = 65535
innodb_file_per_table = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=utf8

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

doondroar

谢谢，以后有不懂的在问你，我是杭州的