Translate
Sub Menu
Links Menu
Online Users

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

Most users ever online was 372 on Thu May 09, 2019 3:50 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
viragotech
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?
Image
Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4125
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa


Return to IntegraMOD 140

Who is online

Registered users: No registered users

cron