Site running very slow... Parse time

[sfklaas]

The last two days, my site has ran slow for about 3 hours. I get stats like:

Parse Time: 25.027 - Number of Queries: 248 - Query Time: 24.2209453734

Parse Time: 29.655 - Number of Queries: 240 - Query Time: 26.4118395432

And those are good times.

My queries are low compared to what I've read on the forum. Anyone have suggestions on where to look? I only had 14,000 rows in my database. Thanks.

(not sure where to put this thread)

[HelpMeSell]

Looks like you need a new host

[sfklaas]

I am using one of the certified hosts. Why do I need to leave one of zen carts certified hosts?

[Ajeh]

Look in the Tools ... Server Info ... what does the line that starts with:
Server Up Time:

read for you?

Do you have an URL that we could perhaps peek at to see if we can locate what might be the slow down?

[sfklaas]

url is woodstarproducts.com.

that line says: Server Up Time: 08:46:44 up 20 days, 13:02, 5 users, load average: 51.28, 56.60, 67.04

Thanks for looking into this.

[sfklaas]

just trying to give more details, I have a tmp file thats called mySQL_slow_queries. The file sizes are pretty large for this morning up to 1 MB.

Inputs look like this:

# Tue Jan 18 08:00:54 2011
# Query_time: 2.349588 Lock_time: 0.000100 Rows_sent: 0 Rows_examined: 1
use mydatabase_name;
update counter set counter = '3929797'

There are hundreds of similar but different entries. Not sure if this helps.