3 comments
Comment from: jkwarren Member
Comment from: Aaron Visitor
Have you noticed any performance hit on the MySQL 5.5 upgrade? SELECTs seem ok, but I have a few apps that are an order of magnitude slower (MyISAM or InnoDB), approx 30x slower.
For now I’ve spun up a 10.04 server VM running MySQL 5.0 along with an stunnel from localhost:mysql to VM:mysql.
I’ve been able to reproduce this on a few different machines, so I’d be curious to see if others notice it as well.
Comment from: jkwarren Member
I’ve not noticed anything, especially on the scale of thirty times slower! I’m running this blog, a few other copies of this blog software (for other domains), a black-hole e-mail web app, and a half-dozen other web apps written by others. Additionally, the database is completely dumped twice a day for back-up purposes. No one is complaining about the performance, and none of the automated processes seem to be taking any longer than usual.
I wonder if your experience isn’t from being inside a VM or tunneling into the VM. Why not just open the VM’s MySQL to accept connections from the VM network, and connect directly?
Brief post-install update. After a “regular” system update forced a reboot, all of the services mentioned (that did not start correctly after the distribution upgrade) restarted just fine.
There were 56 updates today, and after restarting (it said it must), I checked the vitals, and all was fine.