Sub Menu
Links Menu
Online Users

In total there are 55 users online :: 0 registered, 0 hidden and 55 guests

Most users ever online was 561 on Fri Mar 20, 2020 1:13 am

Registered users: No registered users based on users active over the past 60 minutes

Last Online
In order to view the online list you have to be registered and logged in.

We are a free and open
community, all are welcome.

Click here to Register

database issue and long quearys HEELLLLLPPPPPPPP PLZ

Support for IntegraMOD 140

Moderator: Integra Moderator

database issue and long quearys HEELLLLLPPPPPPPP PLZ

PostAuthor: viragotech » Wed Jun 09, 2010 10:57 pm

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. "
User avatar
Sr Integra Member
Sr Integra Member
Posts: 292
Joined: Wed Jul 04, 2007 11:30 am

Re: database issue and long quearys HEELLLLLPPPPPPPP PLZ

PostAuthor: Helter » Thu Jun 10, 2010 11:07 pm

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?
Please do not PM for support
User avatar
Posts: 4126
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa

Return to IntegraMOD 140

Who is online

Registered users: No registered users