database issue and long quearys HEELLLLLPPPPPPPP PLZ

[viragotech]

Tech support sent me this after a CPU over load that got us shut down. Happened twice in less then 60 days which is bad.
[I know 141, 141 but the upgrade fails every time.]

Any help would be great. I don't know much about php but if I have a direction, I Can stumble my way through.


"Before you do anything. This actually might be a database issue. Looking at your query logs, you have many queries that have been killed off due to some selects running for over 100 seconds in some cases.

I can't give you the entire query, since we have it in a logging format which only goes a certain length. Here is what I have...

SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_t

SELECT p.forum_id, p.topic_id, p.post_time, p.post_username, u.username, u.user_id, t.topic_last_pos

Both of those queries seem to be running for a long period of time. "

[Helter]

are you running 140 and cant upgrade to 141? What is the failure code?
If you want, I can probably do the upgrade for you, or at least find out why its not working. If the update is not working, you may have a db issue that may also be causing your excessive server load. What is the size of your current db?