1
serial-weber
Excessive querries in Xoops web site

Hi,

I received a notice, saying that my account is consuming excessive resources on database servers of my host. To maintain my account, I must reduce the amount of databases
queries on my website immediately.

I have created an account on which I am hosting my 25 web site files and data bases.

I don't know what web site or module I must uninstall to resolve the problem.

Please I need help

Thanks

2
Mamba
Re: Excessive querries in Xoops web site
  • 2011/4/6 21:43

  • Mamba

  • Moderator

  • Posts: 11366

  • Since: 2004/4/23


I had recently major problems with piCal and had to remove it, otherwise the host was threatening me with shutting down my VPS account.

piCal was causing a very heavy load on CPU, but didn't have the time to figure out what was the problem.
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

3
zyspec
Re: Excessive querries in Xoops web site
  • 2011/4/7 2:50

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


I previously had a similar problem with piCal. As I recall you can add some "nofollow" headers to some of the templates so the bots don't traverse the entire calendar.

You might check your server log activity to tell whether this is the problem you're seeing.

The header would look something like:
<meta name="robots" content="nofollow" />

4
serial-weber
Re: Excessive querries in Xoops web site

Hi,

In one of my web site, Protector Module has this kind of line:

7/4/2011 2:39:45 Invité(s) 79.142.65.199
IE 6.0Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) URI SPAM /modules/news/comment_post.php SPAM POINT: 10

These lines were about 771500 yesterday, I deleted some but I notice that another are added since this night.

How can I forbid Protector register all these lines??

My host told me yesterday that my account is still consuming excessive resources on their database servers. To maintain my account, I must reduce the amount of databases queries on my website immediately. If my usage of database queries is not significantly immdiately, they will be forced to suspend my account, as their hosting accounts are not intended for such extreme usage of queries.

I am really in problems

Thank you

5
serial-weber
Re: Excessive querries in Xoops web site

Hi,

All my web site have been suspended because of these excessive querries.

Can some one help me to resolve this problem?
Here are websites:

www.xavierahotel.com
www.camerounboutique.com
www.tchangue.com

Thank you

6
zyspec
Re: Excessive querries in Xoops web site
  • 2011/4/7 13:37

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


This doesn't look like a problem with Protector but instead looks like your site is being attacked by a spammer. If the IP address above is the same in all/most of the comments you could try and add it to the bad IP list in Admin>Preferences>General Preferences.

Another, less desirable, option could be to disable comments in news - at least for a while to see if that will help.

The IP above traces back to a company out of Belize, you might try contacting them to see if they can trace it and put a stop to it from their side.

7
JulioNC
Re: Excessive querries in Xoops web site
  • 2011/4/7 20:25

  • JulioNC

  • Quite a regular

  • Posts: 239

  • Since: 2004/10/8


First. What XOOPS version are you using?

don't forget use cache for all. [1] And also use only modules that work, any unuseful module will be remove.

Other tools that you have to use are: firebug + Yslow extension for firefox, then catch what module or xoops' section are slow...

CDN is another solution for static files in your site.

[1]https://xoops.org/modules/smartfaq/faq.php?faqid=771

8
JulioNC
Re: Excessive querries in Xoops web site
  • 2011/4/7 20:30

  • JulioNC

  • Quite a regular

  • Posts: 239

  • Since: 2004/10/8



Take care! Your hosting is reseller. [1] Be careful with overselling.

[1]http://www.whoishostingthis.com/startlogic.com

9
wishcraft
Re: Excessive querries in Xoops web site

The other option is to use the ADODb PDO for XOOPS 2.x series, it needs a minor adjustment which i can't put on the SVN to work, for the fetchArray() and fetchBoth() functions.. However it has a query cache as well so for long queries or queries anyway you can cache them with a file store.

See:http://xoops.svn.sourceforge.net/viewvc/xoops/ThirdParty/adodb/releases/0.20/

for example in version 0.21 there is the following change that fixes this issue of compatibility the other advantage of the PDO is the amount of database's XOOPS Supports as well as being able to use Store Proceedures.

1440        /**
1441         * Get a result row as an enumerated array
1442         *
1443         * @param resource $result
1444         * @return array
1445         */
1446        function fetchRow($result)
1447        {
1448            return @$result->FetchRow();
1449        }
1450    
1451        
/**
1452         * Fetch a result row as an associative array
1453         *
1454         * @return array
1455         */
1456        function fetchArray($result)
1457        {
1458            @$this->setFetchMode(ADODB_FETCH_DEFAULT)
1458            return (array)@$result->FetchObject();
1459        }
1460    
1461        
/**
1462         * Fetch a result row as an associative array
1463         *
1464         * @return array
1465         */
1466        function fetchBoth($result)
1467        {
1468            @$this->setFetchMode(ADODB_FETCH_DEFAULT)
1468            return (array)@$result->FetchObject();
1469        }
1470    
1471        
/**
1472         * XoopsMySQL_ADODBDatabase::fetchObjected()
1473         *
1474         * @param mixed $result
1475         * @return
1476         */
1477        function fetchObject($result)
1478        {
1479            @$this->setFetchMode(ADODB_FETCH_DEFAULT);
1480            return @$result->FetchObject();
1481        }
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts

10
crumpysale56
Re: Excessive querries in Xoops web site

I also have the sam problem..All my web site have been suspended because of these excessive querries.

Can you help me to resolve this problem?

Login

Who's Online

154 user(s) are online (78 user(s) are browsing Support Forums)


Members: 0


Guests: 154


more...

Donat-O-Meter

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

Latest GitHub Commits