Re: Xoops overloading my Server [XOOPS general usage questions]

21

Re: Xoops overloading my Server

2005/4/30 13:21
Mithrandir
XOOPS is my life!
Posts: 6320
Since: 2003/6/21

Quote:

LazyBadger wrote:
Just to note (unrealated to overload thing) - I went on site and have admin's rights on News module (see links "Edit" and "Delete" on front page)

Probably just caching that is causing that. I'm sure you wouldn't be able to actually edit or delete anything.

22

Re: Xoops overloading my Server

2005/4/30 17:50
Skythe
Just popping in
Posts: 99
Since: 2004/7/2 2

Quote:

Mithrandir wrote:
Sorry - missed that one.

I get
Quote:
Page generated in 0.354 Seconds | 32 Queries

as anonymous. Where do you reach 1000+ queries? Is it only when logged in?

I think it was Dave_L's script. The # of querries have gone down to 30 for me too now that I removed it. Oo

@LazyBadger
I'm seeing the same thing when not logged in. You cant actually edit or delete, but Id really like to remove it of course. Any ideas? How does this work anyway, I thought it would generate and store 1 page for each visitor based on their ranks. Not my admin version for everyone...

23

Re: Xoops overloading my Server

2005/4/30 17:58
Mithrandir
XOOPS is my life!
Posts: 6320
Since: 2003/6/21

Currently, the caching system looks solely at two things:

1) Requested URI
2) Cache time

If the cache time is set to more than zero, it will save a cache file with the output and serve that, the next time the URI is requested. Regardless of who is viewing it - unless the module developer has overridden it in his code (it is possible to perform a check to see if the user is a privileged one and if so, turn off caching - it will still cache for non-privileged users). This works fine for some modules, but e.g. not for newbb where each post in a thread can have different options available depending on who is viewing it and therefore caching is not much use there.

XOOPS 2.1.0 will have the possibility of creating "cache groups" in the module code, so you can have one cached version for anonymous users, one for news moderators and one for regular registered users - if implemented in the module.

24

Re: Xoops overloading my Server

2005/5/1 10:29
Skythe
Just popping in
Posts: 99
Since: 2004/7/2 2

Okay so the only way to remove edit / delete is to remove <{$story.adminlink}> from the template? grr :(

Thanks a lot mithrandir!

25

Re: Xoops overloading my Server

2005/5/5 22:20
FlySwatter
Just popping in
Posts: 71
Since: 2004/6/2 1

<Lurking>

Quote:

I edited that FAQ to clarify the instructions.

Not quite clear enough for a country boy

Quote:

(function queryF in class XoopsMySQLDatabase)

Is the above line something that refers to a needed entry or can I just paste the script at the end of the file?

Thanks - Lance

26

Re: Xoops overloading my Server

2005/5/5 22:36
Dave_L
XOOPS is my life!
Posts: 2277
Since: 2003/11/7

Quote:

class/database/mysqldatabase.php (function queryF in class XoopsMySQLDatabase)

That simply tells you where to put the code (highlighted in red).


class XoopsMySQLDatabase extends XoopsDatabase

...

function &queryF($sql, $limit=0, $start=0)

...

      $sql = $sql. ' LIMIT '.(int)$start.', '.(int)$limit;

   }

   [color=ff0000]>>> code goes here <<<[/color]

   $result =& mysql_query($sql, $this->conn);

...

27

Re: Xoops overloading my Server

2005/5/5 23:41
brash
Friend of XOOPS
Posts: 2206
Since: 2003/4/10

Quote:

Skythe wrote:
http://www.planetsmilies.com/

see my first post

When I first load the page I get this;

Quote:

Page generated in 0.436 Seconds | 52 Queries

However after clicking the "main" link a few times I get this;

Quote:

Page generated in 44.839 Seconds | 18278 Queries

You've got a SERIOUS quiries monster in there somewhere. This kind of load WILL NOT be coming from the XOOPS core (otherwise their would be a lot more compliants), which pretty much leaves us with modules. Can you list exactly what version of the News and NewBB modules you are using Skythe? Have you made any modifications?

28

Re: Xoops overloading my Server

2005/5/6 17:30
Skythe
Just popping in
Posts: 99
Since: 2004/7/2 2

Quote:

brash wrote:

When I first load the page I get this;

Quote:

Page generated in 0.436 Seconds | 52 Queries

However after clicking the "main" link a few times I get this;

Quote:

Page generated in 44.839 Seconds | 18278 Queries

You've got a SERIOUS quiries monster in there somewhere. This kind of load WILL NOT be coming from the XOOPS core (otherwise their would be a lot more compliants), which pretty much leaves us with modules. Can you list exactly what version of the News and NewBB modules you are using Skythe? Have you made any modifications?

Yeah I know I was going to post the same right now. Today I'm getting things like 170.288 Seconds | 20972 Queries.

News v1.1
NewBB v1

Cant be NewBB imho, 0.157 Seconds | 49 Queries there.

The only change I did to News (apart from templates) that I can think of is that I removed the news category link in the title bar. There might have been others I dont remember now though.

I also changed some things in misc.php and one file in kernel or class to change the way tables are done by XOOPS (globally). When you enter blocks or some module's preferences in the Admin area the page displayed there will show the changes. Like I added the links "back to main" and "top" to the bottom of every table that is generated by XOOPS (not templated) and they also show in the admin area now. I did this ages ago though.

EDIT: Found it: \class\xoopsform\themeform.php
I'll gonna try with an unaltered backup now and see if that changes anything.

29

Re: Xoops overloading my Server

2005/5/6 17:46
Skythe
Just popping in
Posts: 99
Since: 2004/7/2 2

Hmm now with the original file its back down to 0.817 Seconds | 57 Queries for me. Could be just another caper though. A said before the number of querries seems to go up and down for no obvious reason these last few weeks. t.t

30

Re: Xoops overloading my Server

2005/5/7 3:26
brash
Friend of XOOPS
Posts: 2206
Since: 2003/4/10

Now getting this;

Quote:

Page generated in 37.128 Seconds | 22874 Queries

If you're not 100% sure of all the modification you did, then my advice would be to backup, and then upload a new and unaltered version of Xoops, News and NewBB. Pain in the rear end, but your shooting in the dark otherwise.

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Re: Xoops overloading my Server

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}