xoops forums

Parafal

Just popping in
Posted on: 2008/12/18 2:05
Parafal
Parafal (Show more)
Just popping in
Posts: 98
Since: 2003/6/7 2
#1

XOOPS causing performance problems!

Hi,

I'm using Blueost since 2006 but in 2008 my problens started.

Today I received this message here:

Quote:
This is why the account was suspended. A performance issue: "Exdessive MySQL usage, must fix. mywebsite_website 40600.129812 85799993?


I see the CPU_log and mysql_log but I can't figure out where is the problem because I only know how to install XOOPS and that's it.

What can be the problem?

I didn't hack XOOPS and I use the last update 2.3.2b

Any idea or what can I do for someone to help me?

Should I change for a dedicated webhost?
-|Parafal|-

ghia

Community Support Member
Posted on: 2008/12/18 2:44
ghia
ghia (Show more)
Community Support Member
Posts: 4954
Since: 2008/7/3 1
#2

Re: XOOPS causing performance problems!

If you set the debug on in the admin preferences, then you can see how much and which queries are done for each page generation.
The number depends greatly on the complexity of the site. The number and kind of modules may introduce a lot of queries.
Most important is the number of blocks displayed on each page. Check if each possible block needs to be on each page. find a compromise between useful and need, and plain simplicity.

I don't know the number of pages and visitors or the requests allowed, but you may count on 15 to 20 SQL requests per page.
When hosters start to complain about this, they have mosttimes overloaded their servers (300+ domains) and are only interested in low traffic, static page domains. If your hoster can not accomodate a reasonable amount, then there is nothing left than to move on.

Parafal

Just popping in
Posted on: 2008/12/18 3:33
Parafal
Parafal (Show more)
Just popping in
Posts: 98
Since: 2003/6/7 2
#3

Re: XOOPS causing performance problems!

Thanks for your reply.
I'll ask them to put my website online again to check these debugs informations.
I'm getting about 800 visits daily on my XOOPS site.

Do you think it's time to migrate for a more professional host? like dedicated one?
-|Parafal|-

Parafal

Just popping in
Posted on: 2008/12/18 3:40
Parafal
Parafal (Show more)
Just popping in
Posts: 98
Since: 2003/6/7 2
#4

Re: XOOPS causing performance problems!

Here are some infos I took from the CPU log:

Quote:

CPU Exceeded Log For Wed Dec 17 16:45:49 2008

Wed Dec 17 16:45:49 2008: used 1486.00 seconds of cpu time for mysql query
Wed Dec 17 16:45:47 2008: used 0.12 seconds of cpu time for /ramdisk/bin/php5 /home/tac/public_html/mysite/html/index.php
Wed Dec 17 16:45:47 2008: used 0.15 seconds of cpu time for /ramdisk/bin/php5 /home/tac/public_html/mysite/html/modules/news/article.php
Wed Dec 17 16:45:39 2008: used 0.03 seconds of cpu time for HTTP Request: www.mysite.com : GET /favicon.ico HTTP/1.1
Wed Dec 17 16:45:00 2008: used 0.11 seconds of cpu time for /ramdisk/bin/php5 /home/tac/public_html/mysite/html/index.php


-|Parafal|-

sailjapan

Moderator
Posted on: 2008/12/18 8:35
sailjapan
sailjapan (Show more)
Moderator
Posts: 1672
Since: 2005/11/16
#5

Re: XOOPS causing performance problems!

Quote:
Wed Dec 17 16:45:49 2008: used 1486.00 seconds of cpu time for MySQL query

That's about 24 minutes over 24hrs... doesn't seem excessive to me... then again, if they have 300+ sites on a server...

Time to go find a better host, methinks.
Never let a man who does not believe something can be done, talk to a man that is doing it.

ghia

Community Support Member
Posted on: 2008/12/18 10:19
ghia
ghia (Show more)
Community Support Member
Posts: 4954
Since: 2008/7/3 1
#6

Re: XOOPS causing performance problems!

Quote:
That's about 24 minutes over 24hrs... doesn't seem excessive to me.
It means that he is using 1.7% of the CPU, which means that with 30 sites like that the server gets in trouble.

You can reduce the needed CPU power by switching caching on for some (all) modules.

You may also try to implement this hack by Trabis to display the loading time for each query.
This way you can see which queries takes the most time and see if there is optimisation possible, by eg restate the query or adding or following some indexes in the table.

But at a certain moment, if your site is very successful, you can do it no longer with the cheapest hosting and you need a better hosting.
What is the IP of your site?

trabis

Core Developer
Posted on: 2008/12/18 14:03
trabis
trabis (Show more)
Core Developer
Posts: 2268
Since: 2006/9/1 1
#7

Re: XOOPS causing performance problems!

800 visits day is not much, I only moved to dedicated when I got 8000. You should think in moving to a better 'shared' hosting like Godaddy or Surpass (or any other, lol)

Parafal

Just popping in
Posted on: 2008/12/18 21:45
Parafal
Parafal (Show more)
Just popping in
Posts: 98
Since: 2003/6/7 2
#8

Re: XOOPS causing performance problems!

Hi,

I put cache everywhere. Everything seams to be ok. So far, so good.

I find out that my SQL had about 23Mb in Private Messages. I deleted them, too.

I'll keep looking this weekend and if the problem starts again I'll let you know.

Thank you for the tip about cache, I never used it before!

-|Parafal|-

pipwax

Not too shy to talk
Posted on: 2009/2/11 17:45
pipwax
pipwax (Show more)
Not too shy to talk
Posts: 132
Since: 2005/9/12
#9

Re: XOOPS causing performance problems!

I think that I may be having a similar problem. I am hosting on Godaddy using xoop 2.18.2.
I received this email from my hosting company today
Quote:
It has come to our attention that your hosting account for yourdomian.com is causing an overload of the shared resources on this server. This, in turn, affects the server performance for other customers. We have migrated your site to a new server to provide you time to resolve the issue. Unfortunately, we are not able to troubleshoot custom scripting, and therefore, we are not able to provide specific solutions. However, your site has generated over 30,000 processes and over 11,000 process seconds in a 10 hour period. Keep in mind, these processes may not be the root cause of this issue.

How would I know if I have been hacked?
Because just before this incident my hosting permissions were mysteriously changed to prevent viewing of the site.
pipwax1@bellsouth.net
Quote:
To win in life one must be fluid like water, taking the shape needed to prevail


aspring IT Professional