Ervik's picture


I'm using the turnkeylinux for Joomla. I use the Xen image, running on XenServer. Been doing so for 1,5 years now, no issues.

I recently upgraded to Joomla 2.5.4, and now mysql is going thru the roof, at a staggering 135-150% CPU, yes I have 2 vcpus attached to the virtual machine.

Now, my question is, is there any way to upgrade MySql inside this Turnkeylinux? Or are you planning to release a Joomla 2.5.x version of it soon?

Please help out! I think this is releated to mysql or php...

Jeremy Davis's picture

Hopefully soon after the official release of Ubuntu 12.04/Precise (in 2 weeks) we will see updated v12 TKL appliances rolled out. I would assume that the v12 Joomla appliance will have the latest stable version of Joomla included - that seems to be the way the TKL releases go. How soon after Ubuntu 12.04 release 'soon after' is though, is anybody's guess.

But whether an updated appliance will solve your problems or not, who knows... (Let's hope so).

I know nothing about Joomla (or MySQL really either...) so I'm only guessing but I suspect that the database layout may be different between the versions. My guess is that updating the DB schema has introduced (or left behind) some cruft in your DB which is triggering some sort of edge case MySQL (or Joomla) bug. My first inclination would be to do a backup of your DB and have a play in phpMyAdmin and see if there are empty records that can be deleted.

Perhaps you could approach it from another direction and create a fresh Joomla 2.5.4 instance (ie update Joomla in a clean TKL v11.3 Joomla appliance) and see if that exhibits similar behaviour (with no end user data). If not, import your DB bit by bit testing as you go so you can try to pin down the problematic parts of your DB (assuming that is the problem).

Bert Mul's picture

I use the LAMP appliance v11.3 as a test host on an old Dell C640 laptop with 1Gb memory, and I have absolutely no problems with any version  of Joomla from 1.5 up.

I configured 9 virtual interfaces to eth0 and also configured 9 virtual hosts in apache, each with their own document root. And yes, 9 additional MySQL databases.

8 of these virtual web servers runs some version of Joomla. At this moment, I have 3 instances of Joomla 2.5.4, 1 instance of Joomla 2.5.0, 2 instances of Joomla 1.7.5, 1 instance of Joomla 1.6.6 and 1 instance of Joomla 1.5.26.

Sometimes, up to 6 people are simultaneously testing nasty things with these Joomla sites and I cannot remember the processor utilisation being any higher than about 80% (during short peaks)

There are only 2 things that make the processor busy, and they are manipulating pictures (I installed php5-gd) and uploading an archive and extraxting it after upload.

If someone's processor gets hot after installing/upgrading Joomla 2.5, there must be something weird with their Joomla installation.

Add new comment