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