Thread

Hi all,

I have a site that uses ed_imageresizer for ecommerce (lots of little thumbnails per page), and the mysql database CPU load shoots through the roof when I put it live.

How can I ascertain what the issue is and correct it.

Is it down to the amount if times I am using the image resizer?

The site is http://www.houseofbatteries.co.uk

Thanks for you help.
Ian

AFAIK, ed_imageresizer does not make any use of the database. So I can’t imagine the two are directly related.

Hmm, can anyone help me isolate what the problem is?

8243 localhost ee_houseofbatteriescouk Sleep 20
8258 localhost ee_houseofbatteriescouk Sleep 18
8259 localhost ee_houseofbatteriescouk Query 0 SHOW PROCESSLIST
8260 localhost ee_houseofbatteriescouk Sleep 20
8261 localhost ee_houseofbatteriescouk Sleep 203
8262 localhost ee_houseofbatteriescouk Sleep 20
8263 localhost ee_houseofbatteriescouk Sleep 123
8266 localhost ee_houseofbatteriescouk Sleep 1
8267 localhost ee_houseofbatteriescouk Sleep 54
8270 localhost ee_houseofbatteriescouk Sleep 29
8271 localhost ee_houseofbatteriescouk Sleep 47
8275 localhost ee_houseofbatteriescouk Sleep 18
8298 localhost ee_houseofbatteriescouk Sleep 54
8378 localhost ee_houseofbatteriescouk Sleep 10

And this is the plesk health graph for mysql:

http://www.ianryde.co.uk/plesk_health.jpg

Thanks,
Ian

Do you use persistent or non-persistent connections?

http://ellislab.com/expressionengine/user-guide/cp/admin/database_settings.html

Hi there,

I’ve set it to non-persistent as recommended, but still no change.

955 localhost ee_houseofbatteriescouk Sleep 2951
956 localhost ee_houseofbatteriescouk Sleep 2771
970 localhost ee_houseofbatteriescouk Sleep 2696
971 localhost ee_houseofbatteriescouk Sleep 2926
977 localhost ee_houseofbatteriescouk Sleep 2672
987 localhost ee_houseofbatteriescouk Sleep 2905
988 localhost ee_houseofbatteriescouk Sleep 2877
989 localhost ee_houseofbatteriescouk Sleep 2709
990 localhost ee_houseofbatteriescouk Sleep 2693
992 localhost ee_houseofbatteriescouk Sleep 2678
1002 localhost ee_houseofbatteriescouk Sleep 2801
1003 localhost ee_houseofbatteriescouk Sleep 2739
1009 localhost ee_houseofbatteriescouk Sleep 2738
1020 localhost ee_houseofbatteriescouk Sleep 2712
1021 localhost ee_houseofbatteriescouk Sleep 2712
1022 localhost ee_houseofbatteriescouk Sleep 2712

Thanks,
Ian

Hi Ian,

In order to get a under-the-hood look at this, I’ll need you to enable some debugging options.

First of all, can you provide the template code for the template that is causing the trouble?

Now, in the Control Panel, navigate to Admin->System Administration->Output and Debugging. Set “Display Output Profiler?” and “Display Template Debugging?” to “Yes” and click Submit. This output will only be shown to logged in Super Admins.

Once you have that on, visit the template in question and look for the area regarding SQL queries. It will tell you how many queries have run to generate the page and give you the option to see the queries that were run.

You can post that here too, so we might see if anything stands out.

Cheers,

Hi and thanks Dan,

I’m not sure which template is causing the issue. Is there any way of isolating which template it is?

For now i’ll take a guess at one of the high traffic templates. It’s an ecommerce shop so there may be a few.

I am just trying to upgrade and running into problems…

http://ellislab.com/forums/viewthread/211531/

Ian

Hi Dan,

Tried to PM you but your inbox is full. Would it be better to PM you a login, as the templates are to large to post.

Thanks for you help thus far.

Ian

Can anyone help?

I posted this twice, this thread can be closed, as the active one is over here.

http://ellislab.com/forums/viewthread/207678/

Thanks,
Ian

Hi Ian,

Looks like you are getting some good attention on that thread. I will close this one out.

Regards,