MySQL Forums :: Performance :: Configuration review requested

Advanced Search

Re: Configuration review requested
Posted by: Rick James ()
Date: April 14, 2016 01:39PM

Windows --> *nix.

VM --> dedicated server

datadir="D:/MySQL/data\" -- D: is SSD?

Were your tables MyISAM on the old machine, but InnoDB on new?

How big was the VM?

innodb_buffer_pool_size=8G --> 70% of available RAM

innodb_thread_concurrency=6 -- Why? Try 0

Generally, the settings look good. I don't see anything that can explain the performance problem you are seeing.

Since you have the slowlog turned on, let's check there. Do one of these:
mysqlslowdump -s t
Then, let's discuss the 'worst' queries.

Options: ReplyQuote

Subject Views Written By Posted
Configuration review requested 943 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested 372 Rick James 04/14/2016 01:39PM

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.