"Copying to tmp table" queries puts huge load on server

Discussion regarding Joomla! 2.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
puneetjain87
Joomla! Explorer
Joomla! Explorer
Posts: 337
Joined: Mon Feb 16, 2009 4:38 am

"Copying to tmp table" queries puts huge load on server

Postby puneetjain87 » Wed Apr 04, 2012 5:35 pm

mysql queries are causing server troubles for me.

Here is how it started.

I migrated from 1.5 to 1.7 and then to 2.5
I did a fresh install of 1.7 and just imported my articles and users from 1.5 to 1.7 (I did not use jupgrade)
I used J2XML to export my files from joomla 1.5
and used
J2XML Importer to import into Joomla 1.7

So, after I started using Joomla 1.7 all the trouble started.

Upgrading to 2.5 from 1.7 was easy, did it with a hit on a button.

When this issue happens?
It happens every time I clear the cache or it get automatically cleared. After cache is cleared a query "Copying to tmp table" starts these queries cause lots of server load causing it to stop working.

I read a few thread where it was suggested that asset table is causing this issue, however in my case I checked the asset tablet twice and it exactly same as what is suggested here http://docs.joomla.org/Fixing_the_assets_table

If anybody has any solution for this, please share. I will be really grateful.

puneetjain87
Joomla! Explorer
Joomla! Explorer
Posts: 337
Joined: Mon Feb 16, 2009 4:38 am

Re: "Copying to tmp table" queries puts huge load on server

Postby puneetjain87 » Sat Apr 07, 2012 2:48 pm

I am still looking for a possible solution and while searching I landed on this https://groups.google.com/forum/#!topic ... -9HOB7zEN4
It's seems to be a Joomla issue for sure. It's there on Joomlacode as well, but it seems there are very less people who are bothered to get it working.

PS: my jos_content is a heavy one. Over 4000 articles and its size is around 18MB

puneetjain87
Joomla! Explorer
Joomla! Explorer
Posts: 337
Joined: Mon Feb 16, 2009 4:38 am

Re: "Copying to tmp table" queries puts huge load on server

Postby puneetjain87 » Wed Apr 25, 2012 1:32 pm

I spend lots of my time to read about Joomla 2.5 performance issues, as the new versions are a blunder for website having huge amount of content.

Anyways, I was trying to figure out how to get over this copy to tmp table query and in the process I realized what was causing it. It was the Recent Articles module, I disabled it and those slow queries are now gone. Though I am testing it from last few hours, so it's bit early to claim, still I feel it is the cause of the stupid heavy mysql usage.

If you are having the same issue, please try this and share your experience here.

User avatar
codigoaberto
Joomla! Apprentice
Joomla! Apprentice
Posts: 41
Joined: Tue Apr 24, 2012 8:49 am
Contact:

Re: "Copying to tmp table" queries puts huge load on server

Postby codigoaberto » Fri Apr 27, 2012 10:14 am

try change the sql query directly of the module to your needs if you know that
Joomla Enterprise Projects Manager and Developer
JoomlaPT! administrator

puneetjain87
Joomla! Explorer
Joomla! Explorer
Posts: 337
Joined: Mon Feb 16, 2009 4:38 am

Re: "Copying to tmp table" queries puts huge load on server

Postby puneetjain87 » Sat Apr 28, 2012 6:25 am

I won't be able to do that. However my mysql heavy usage issue is not resolved. It was a buggy module which was causing it.

ervik
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 170
Joined: Fri Nov 30, 2007 8:39 pm

Re: "Copying to tmp table" queries puts huge load on server

Postby ervik » Fri May 04, 2012 8:45 am

Which module was causing the heavy usage issue? I see similar problems with copying to tmp table. I have about 3100 articles and at a size of 14 MB.

puneetjain87
Joomla! Explorer
Joomla! Explorer
Posts: 337
Joined: Mon Feb 16, 2009 4:38 am

Re: "Copying to tmp table" queries puts huge load on server

Postby puneetjain87 » Fri May 04, 2012 12:19 pm

Ervik which all modules are you using?


Return to “Performance - Joomla! 2.5”

Who is online

Users browsing this forum: No registered users and 3 guests