MySQL Forums
Forum List  »  Performance

MySQL Server 5.1 max output
Posted by: Sugihono Budiman
Date: February 07, 2020 10:34AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Server 5.1 max output
302
February 07, 2020 10:34AM
142
February 07, 2020 12:19PM
167
February 08, 2020 08:37AM
145
February 08, 2020 10:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.