MySQL Forums
Forum List  »  Performance

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

Written By
April 13, 2016 11:55AM
Re: Configuration review requested
April 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.