MySQL Server 5.1 max output

[Sugihono Budiman]

Good day. Need your expertise. I have 256GB Windows 2016 server with 250GB SSD for OS and 2TB SATA drive for storage. Network bandwidth is 500GB up and down.

Some reason with these settings, my IIS hosting 50 sites and max 4 fast-cgi are hitting brick wall and I could not think of anything else to optimize them. Please share your past experience with high performance server with multiple sites hosted on IIS10.0


[client]

port=3306

[mysql]

default-character-set=UTF8

[mysqld]
port=3306
#skip-name-resolve
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
character-set-server=UTF8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=10000
key-buffer-size=600M
join_buffer_size=10M
wait_timeout=40
interactive_timeout=50
connect_timeout=43200
max_allowed_packet=2048M
long_query_time=5
skip-external-locking
open_files_limit=32768
thread_stack=256K
innodb_max_dirty_pages_pct=0
net_buffer_length=512M
open_files_limit = 65535
table_open_cache=8000
query_cache_size=128M
query_cache_limit=128M
query_cache_type=1
table_cache=3000
tmp_table_size=2000M
max_heap_table_size=2000M
max_tmp_tables=300
thread_cache_size=20000
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=35M
key_buffer_size=32768M
read_buffer_size=10M
read_rnd_buffer_size=256K
sort_buffer_size=10M


#*** INNODB Specific options ***
#skip-innodb
transaction-isolation=READ-COMMITTED
#innodb_buffer_pool_instances=4
innodb_file_per_table=ON
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=1024M
innodb_buffer_pool_size=12000M
innodb_log_file_size=24M
innodb_thread_concurrency=66
#innodb_buffer_pool_size_instances=16

[mysqld_safe]
max_open_files=2048
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid