MySQL Forums
Forum List  »  Quality Assurance

Fine Tuning Assistance
Posted by: Wayne Bui
Date: August 25, 2015 10:03AM

Hello, I have been tuning the database and was hoping to get some assistance. We get roughly 2000-3000 active live users on the site and round about 1.5 million requests within an hour. The MYSQL server resource is not taxed at all. We've tuned it and everytime we tuned it, it's faster for like a week or so. My setting is below. Any suggestion would help.

[client]
no-beep
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
datadir=C:/ProgramData/MySQL/MySQL Server 5.6/Data
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
log-output=FILE
general-log=0
general_log_file="SPU1-2-4-9.log"
slow-query-log=1
slow_query_log_file = "SPU1-2-4-9slowquery.log"
long_query_time = 5
log-error="SPU1-2-4-9.err"
max_connections = 30000
query_cache_limit=6G
query_cache_size = 1G
query_cache_type = 1
table_open_cache = 524288
max_heap_table_size=4294967295
tmp_table_size=4294967295
thread_cache_size = 64
myisam_max_sort_file_size=100G
myisam_sort_buffer_size = 64M
key_buffer_size = 64M
read_buffer_size = 256K
read_rnd_buffer_size = 2G
sort_buffer_size = 8M
innodb_additional_mem_pool_size = 40M
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 16M
innodb_buffer_pool_size = 30G
innodb_log_file_size = 256M
innodb_thread_concurrency = 8
innodb_autoextend_increment=64
innodb_buffer_pool_instances = 12
innodb_concurrency_tickets=8000
innodb_old_blocks_time=1000
innodb_open_files=4000
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log = 100
flush_time = 0
join_buffer_size = 4M
max_allowed_packet = 2G
max_connect_errors = 10000
open_files_limit=8161
table_definition_cache = 1200
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
performance_schema = off
max_user_connections = 0

Options: ReplyQuote


Subject
Views
Written By
Posted
Fine Tuning Assistance
1372
August 25, 2015 10:03AM
930
September 25, 2015 11:55AM


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.