Sub Menu
Links Menu
Online Users

In total there are 340 users online :: 2 registered, 0 hidden and 338 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot] based on users active over the past 60 minutes

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 9: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
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: database issue and long quearys HEELLLLLPPPPPPPP PLZ

PostAuthor: Helter » Thu Jun 10, 2010 10: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?
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3


Return to IntegraMOD 140

Who is online

Registered users: Bing [Bot], Google [Bot]

cron