1
Parafal
XOOPS causing performance problems!
  • 2008/12/18 2:05

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


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|-

2
ghia
Re: XOOPS causing performance problems!
  • 2008/12/18 2:44

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


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.

3
Parafal
Re: XOOPS causing performance problems!
  • 2008/12/18 3:33

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


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|-

4
Parafal
Re: XOOPS causing performance problems!
  • 2008/12/18 3:40

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


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|-

5
sailjapan
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.

6
ghia
Re: XOOPS causing performance problems!
  • 2008/12/18 10:19

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


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?

7
trabis
Re: XOOPS causing performance problems!
  • 2008/12/18 14:03

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


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)

8
Parafal
Re: XOOPS causing performance problems!
  • 2008/12/18 21:45

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


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|-

9
pipwax
Re: XOOPS causing performance problems!
  • 2009/2/11 17:45

  • pipwax

  • Not too shy to talk

  • Posts: 132

  • Since: 2005/9/12


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

Login

Who's Online

213 user(s) are online (131 user(s) are browsing Support Forums)


Members: 0


Guests: 213


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