卖了一台配置牛X服务器，32核CPU，32G内存，装的是mysql5.6.21版本，windows2003。myisam和innodb共用，设置my.ini参数时，innodb_buffer_pool_size这个参数一般都说设成物理内存的70%-80%，本人开始设16G，mysql启动不了，然后一直减小测试，只有设到300M左右，mysql才能启动成功，大了mysql就启动不了。还是win2003下innodb_buffer_pool_size只能很小，这不太浪费了吗？
下面是本人的ini文件
[mysqld]
#绑定IPv4和3306端口
bind-address = 0.0.0.0
port=3306
skip-external-locking
skip-name-resolve
#myisam-recover=BACKUP,FORCE
basedir=E:/k8Serv/MySQL5.6/
datadir=E:/k8Serv/MySQL5.6/data/
character_set_server = utf8
collation-server = utf8_general_ci
thread_concurrency = 8
concurrent_insert = 2
max_write_lock_count = 1
##low-priority-updates=1
default-storage-engine=MYISAM
# Set the SQL mode to strict
sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
max_connections = 3000
max_connect_errors = 100
query_cache_size = 512M
query_cache_limit = 2M
query_cache_type = 1
query_cache_wlock_invalidate = 1
table_open_cache=1200
tmp_table_size=256M
thread_cache_size=800
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=256M
myisam_repair_threads = 1
key_buffer_size=512M
read_buffer_size=8M
read_rnd_buffer_size=16M
bulk_insert_buffer_size = 64M
sort_buffer_size=2M
join_buffer_size=2M
back_log = 600
#log-slow-queries=mysql-slow.log
#long_query_time=2
log-error=mysql.err
##*** INNODB Specific options ***
innodb_additional_mem_pool_size=12M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=3M
##innodb_buffer_pool_size与key_buffer一样，可以是内存60-80%
innodb_buffer_pool_size=6G
innodb_log_file_size=512M
innodb_log_files_in_group=3
innodb_flush_neighbors=0
##log-bin=mysql-bin
##innodb_thread_concurrency  Linux环境设置为0
innodb_thread_concurrency = 100
innodb_file_io_threads=4
innodb_thread_sleep_delay=40
wait_timeout=100
interactive_timeout=100
connect_timeout = 10
max_allowed_packet = 32M