Help! 15 users causing 100% CPU Usage by MySQL 5.7 in Windows 2012 R2
Posted by: Ben HACKNEY
Date: May 22, 2017 04:52PM

Greetings,

I am having some issues with our MySQL deployment and it seems to be coming to a head. Our MYSQL deployment has always been a hog! And the CPU runs at 100%. It seems to have only got worse after a move to a new server.

I am running MYSQL 5.7 on a VMWare ESXI 6.5 host.

VM Specs:
64 bit
4 CPU @ Xeon E5-2450 v2 @ 2.5Ghz
8GB Ram

I started out as 2 CPU, and it wouldn't even run. I upped it to 4 CPU, and it would at least get off the ground. However it's slow and pegging CPU resources at 100%. I have posted my.ini at the end of this post. My deployment is just servicing about 15 users on a homebrew ticketing application so I can't for the life of me figure out why this thing is eating up so much resources.

Would you please review my ini and offer any recommendations? If you need any other information to help me troubleshoot, lay it on me.

Thanks in Advance for any help!
-ben

[client]
port=3306
[mysql]
no-beep
default-character-set=utf8
[mysqld]
port=3306
datadir=C:/ProgramData/MySQL/MySQL Server 5.7\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="TMSRV.log"
slow-query-log=1
slow_query_log_file="TMSRV-slow.log"
long_query_time=10
log-error="TMSRV.err"
server-id=1
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"
max_connections=200
query_cache_size=512M
table_open_cache=2000
tmp_table_size=252M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=24M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=3G
innodb_log_file_size=48M
innodb_thread_concurrency=0
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=100M
max_connect_errors=100
open_files_limit=4161
query_cache_type=0
sort_buffer_size=5M
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000

Options: ReplyQuote


Subject
Written By
Posted
Help! 15 users causing 100% CPU Usage by MySQL 5.7 in Windows 2012 R2
May 22, 2017 04:52PM


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.