Site Slow - Bluehost says SQL queries are too big?

[phlipper]

2 days ago our site at www.kwmagic.com started running very slowly.

After reading through the forums, I have

Optimized the Database

Turned off catagory count

turned on GZIP

Installed the add-on 'query-cache'

now it seems slower than ever... Bluehost says this is my problem and I should look at the slow-queries tmp/log

I did, but other than telling me everything is slow there is not much else there.

Hoping that someone can guide me in the right direction

thank-you

Phil

[phlipper]

A little more research and it looks like once again I am being hammered by Slurp and google bot

would this cause the slowdown ?

[ebaobao]

I don't know about the slow problem. But I've had bluehost said that my sql queries took a long time and also told me to look in the temp/log folder too. They even shut down my website until I fixed the problem. The problem was because a lot of the sql queries were slow. I didn't bother finding out what was the true cause that made these queries slow. Instead I just removed all the queries that I don't necessary need to use. For example, I removed the whos online query and some other search results queries. After removing those queries, I haven't had a problem for over 1.5 years now.

I would suggest that you go look at those logs and see which queries are taking a long time to process and see if possible to just code out those queries or modify them a bit so that it doesn't have to scan so many tables.

This is not a very good solution but it worked for me. So its up to you to decide what sort of time you want to put into hunting the problem.

[phlipper]

Thanks... I have been looking at the logs

it seems all queries are taking too long, the website takes over a minute to load.

this just started 2 days ago.

[dbltoe]

something is trying to transfer from i3DOTytimgDOTcom and taking forever.

[CJPinder]

Phil,

In Admin go to the Configuration menu, select Logging and then set 'Display Page Parse Time' to 'True'. This will show the number of SQL queries and the time taken at the bottom of each page. This will make it a bit easier to diagnose the problem.

The next thing to do is the create a new database and install a fresh copy of Zen Cart into a sub-directory on your site. If the fresh install of Zen Cart runs slow then it is Bluehost's issue.

Regards,
Christian.

[ebaobao]

For some reason, I'm not able to find my older post where I had problems with sql queries taking a long time. Otherwise, I would post a link to that post and you can see the queries that I've modified. MODS do certain posts get deleted or something?

In any case, when you say it takes a long time, what is the seconds in the sql query logs say? 2 seconds, 9 seconds, 30 seconds? What is the average you are seeing? Maybe data_digger can come in and help out.

[dbltoe]

I think I would investigate the i3DOT problem first. I don't find anything in your source that's calling the URL, but the system is sure trying to load something from there.

[phlipper]

Thanks for the replies, I am still having a ton of issues, I am going to try the above ideas this morning (it looks like they are blaming the poblems on my two zen cart websites):


I got this from Bluehost this morning:

It looks like www.canadamagicsupply.com/index.php and possibly www.kwmagic.com/index.php is responsible for causing cpu throttling the last time it was throttled.
[6:31:14 AM] Enter a user to check cpu throttling for or Ctrl+C to quit
> kwmagicc

Writing kwmagicc's domains to domains.txt...
Generating cpud.log...

Last 10 of 11 lines from cpud.log...
/var/log/cpud:Wed Jun 9 05:50:24 2010 1276084224.612 User in Jail uid=4093 progs=1,1 mysql=0,0 non-mysql=1,1 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:24 2010 1276084224.962 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:25 2010 1276084225.477 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:25 2010 1276084225.963 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:26 2010 1276084226.456 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:26 2010 1276084226.954 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:27 2010 1276084227.458 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:27 2010 1276084227.975 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:28 2010 1276084228.457 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg
/var/log/cpud:Wed Jun 9 05:50:28 2010 1276084228.986 User in Jail uid=4093 progs=1,0 mysql=0,0 non-mysql=1,0 mysqljail=0 rss=15.67Meg

Enter a timestamp pattern to search apache logs for (eg. 09:..:..):
> 05:50:..

Generating raw_logs.txt for the given timestamp...

Results...
6 www.canadamagicsupply.com/index.php
> 4 www.kwmagic.com/index.php
> 1 www.canadamagicsupply.com/
> 1 canadamagicsupply.com/

[phlipper]

This is the information now at the bottom of the page:

Parse Time: 25.228 - Number of Queries: 170 - Query Time: 24.9976063934