MySQL Forums
Forum List  »  Performance

Re: Recent Upgrade from MySQL 5.1 to 5.5
Posted by: Alex Titley
Date: December 08, 2016 05:07AM

The plan is to eventually move to 5.7 but with us being on 5.1 in the first instance it was too much of a risk to move to 5.7 straight away so we went to 5.5 first.

We are seeing a loss in performance since the upgrade though. Most of the configs have stayed the same other than key_buffer_size has been increased to 10% of available RAM and we have increase max_heap_table_size to 512M and tmp_table_size to 512M.

I'd have thought with a better machine you shouldn't see a decrease in performance even with the same configs or am I wrong here?

Options: ReplyQuote


Subject
Views
Written By
Posted
370
December 07, 2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5
184
December 08, 2016 05:07AM


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.