31
ajaxbr
Re: Xoops overloading my Server
  • 2005/5/7 5:24

  • ajaxbr

  • Quite a regular

  • Posts: 276

  • Since: 2003/10/25


Try removing the Poll block (could be checking against dupe votes?). Also, try turning off Adverts, New Members and Affiliates one at a time.

Wait, is that huge image list at left a module? A menu module? if it is, there you go...

Good luck

32
Skythe
Re: Xoops overloading my Server
  • 2005/5/7 13:16

  • Skythe

  • Just popping in

  • Posts: 99

  • Since: 2004/7/2 2


Quote:

ajaxbr wrote:
Try removing the Poll block (could be checking against dupe votes?). Also, try turning off Adverts, New Members and Affiliates one at a time.

Wait, is that huge image list at left a module? A menu module? if it is, there you go...

Good luck


Ads, Affiliates and Smilies are all custom blocks. Plain HTML, no XOOPS or db stuff.

I removed the Poll now lets see if that helps. T.T My guess would be theme.html....

33
Skythe
Re: Xoops overloading my Server
  • 2005/5/10 12:54

  • Skythe

  • Just popping in

  • Posts: 99

  • Since: 2004/7/2 2


Ok the site is now down more oftn than not and it seems like a clean install is the only way out

if i am to take a new XOOPS installation and use a backup from the current database, could that 'infest' the new xoops? Guess not but doesnt hurt asking ^^

oh and i havent tried with persistent connection yet. what about that?

34
pegasus00321
Re: Xoops overloading my Server

I dont think you need to reinstall it. It can be relatively easily made to use less queries.

I dont exactly have the time to help you do that, but I'm sure someone here at the forums can help you if you give them admin and they can go in and check your cache settings.

35
brash
Re: Xoops overloading my Server
  • 2005/5/11 3:30

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


First step would be to know which module is producing them, and I cannot see a default install of NewBB 1 or News 1.1 doing this. Doesn't Daves hack posted on the first page log all the MySQL queries to a file? This would be a first step in find where the hell they are all coming from.

36
karuna
Re: Xoops overloading my Server
  • 2005/5/11 5:34

  • karuna

  • Not too shy to talk

  • Posts: 171

  • Since: 2002/5/29


turn on the mysql&block debug to see where these queries come from

37
danMAN
Re: Xoops overloading my Server
  • 2005/5/11 9:09

  • danMAN

  • Just popping in

  • Posts: 41

  • Since: 2004/3/13


Quote:
Page generated in 39.349 Seconds | 39574 Queries


This is some bad luck, no? Sorry can't help (because I'm new to php), but hope you have some luck in finding out what's causing your issue.

38
highlander
Re: Xoops overloading my Server
  • 2005/5/11 10:33

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Like Karuna said; try turning on MySQL debug and record its output. It will tell you were the queries are coming from.

I suggest running it as user who is not logged in; as a user who is logged in and as an admin and compare the results for a specif set af pages (make an excel-file)

This should make it possible for you to find out where all these queries are coming from..

good luck; Highlander

39
Skythe
Re: Xoops overloading my Server
  • 2005/5/11 12:35

  • Skythe

  • Just popping in

  • Posts: 99

  • Since: 2004/7/2 2


Quote:

karuna wrote:
turn on the mysql&block debug to see where these queries come from


While the site is online? What will that do?

40
Skythe
Re: Xoops overloading my Server
  • 2005/5/15 21:15

  • Skythe

  • Just popping in

  • Posts: 99

  • Since: 2004/7/2 2


?

Login

Username:
Password:

Lost Password? Register now!

Who's Online

72 user(s) are online (36 user(s) are browsing Support Forums)


Members: 0


Guests: 72


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits