MySQL Forums
Forum List  »  Performance

Re: MySQL 5.5.31 cripplingly slow
Posted by: Rick James
Date: January 15, 2014 02:12PM

> I run a very basic VPS with 256MB of RAM.

That is extremely tiny by today's standards. Use the link that Peter gave you to compute the buffer sizes, then cut them in half. After that, monitor swapping. If your tiny RAM is swapping, you will need to decrease things further.

Set query_cache_type=OFF.

Turn on the slowlog; see what shows up in it; then we can discuss specific queries. Granted, this does not address your original question about the upgrade, but it may lead to better performance.

If you do these after being up a few hours, and present the outputs here, I can dig further:
SHOW VARIABLES;
SHOW GLOBAL STATUS;

I can't judge the buffer settings without knowing whether you are using MyISAM or InnoDB. Note that the default has change from MyISAM to InnoDB; this _may_ have affected your tables. If so, we should look at SHOW CREATE TABLE together with the details in the script to see if something is worse because of the engine change. Further tips in that direction:
http://mysql.rjweb.org/doc.php/myisam2innodb

Options: ReplyQuote


Subject
Views
Written By
Posted
2676
January 15, 2014 07:16AM
1124
January 15, 2014 11:44AM
Re: MySQL 5.5.31 cripplingly slow
1185
January 15, 2014 02:12PM
3438
January 17, 2014 05:52AM
1450
January 17, 2014 07:56AM
1215
January 17, 2014 11:23AM
1247
January 17, 2014 11:29AM
1316
January 17, 2014 02:03PM
1092
January 17, 2014 02:43PM
1242
January 17, 2014 05:13PM
1485
January 18, 2014 09:53AM
1164
January 18, 2014 04:00PM
1142
January 18, 2014 08:55PM


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.