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
pt-query-digest
Then, let's discuss the 'worst' queries.

Options: ReplyQuote


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