1
irmob
CPU over loaded problem
  • 2009/1/26 19:16

  • irmob

  • Just popping in

  • Posts: 25

  • Since: 2005/10/2


Hello,
I am using XOOPS for 4th year, but I have a continual problem with cpu load until I have forced to provide a dedicated server for my site.
I have 50 user online with 16000 hit per day.
my server information:
Quote:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz
Processor #1 speed: 2527.000 MHz
Processor #1 cache size: 3072 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz
Processor #2 speed: 1596.000 MHz
Processor #2 cache size: 3072 KB


Also I using XOOPS 2.0.18

Now I receive this message from server:
Quote:
..
This is cPanel cpuwatch on ....!
While processing, the cpu has been
maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is
10:06:21 up 6 days, 22:19, 0 users, load average: 2.44, 0.90, 0.50
You should check the server to see why the load is so high and take steps to lower the load. ...


I don't Know how can I decrease CPU load or optimize the xoops.

Are you can help me?

2
trabis
Re: CPU over loaded problem
  • 2009/1/26 19:29

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


I had the same problem even with dedicated server. I had to upgrade CPU a week ago to solve my problem. My problem is to much queries and big tables.
You can find this useful, I did, it saved my life a couple of times:
http://www.xuups.com/modules/publisher/article.php?storyid=12

This hack will enable you to see what queries are taking to long. By knowing that you may take providences like, changing the query or set up indexes.

The problem may also be in some module function.
Please check timers on your debug and see if you have a module taking to much time to load.

In my case the cpu load has not much to do with the number of page requests, it is more related with the size of the tables. For each item added the more slow it gets.

3
irmob
Re: CPU over loaded problem
  • 2009/1/26 20:13

  • irmob

  • Just popping in

  • Posts: 25

  • Since: 2005/10/2


I not use your hack yet, but I have this times for first page :

XOOPS took 0.410 seconds to load.
XOOPS Boot took 0.016 seconds to load.
Module init took 0.004 seconds to load.
XOOPS output init took 0.385 seconds to load.
Module display took 0.000 seconds to load.
Page rendering took 0.005 seconds to load

4
stefan88
Re: CPU over loaded problem
  • 2009/1/26 22:51

  • stefan88

  • Community Support Member

  • Posts: 1085

  • Since: 2004/9/20


Hi,

you may also check this story (Optimizing Xoops, its modules and your server):

https://xoops.org/modules/news/article.php?storyid=4063

Try cache for modules and blocks where posible.

Clean some tables (content, unactive users and so on) if posible. Check sessions table.

Also you may try GiJoes Fastest Cache Hack...

..

5
irmob
Re: CPU over loaded problem
  • 2009/1/27 6:57

  • irmob

  • Just popping in

  • Posts: 25

  • Since: 2005/10/2


Thanks from your help.
I am useing:
- cash for block
-optimize table of database
-install XOOPS care for optimizing table every 7 days
- remove tabal that unused

but I cant use "Jsmin" for minimize of java scripts.

I will report server status here

6
irmob
Re: CPU over loaded problem
  • 2009/2/1 20:57

  • irmob

  • Just popping in

  • Posts: 25

  • Since: 2005/10/2


Hello my friends

after 5 day from last edition I have 58 % of CPU load today.
Now my site is down.

Top Process %CPU 170 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/sls-


I cant solve this problem.
Do you know any thing?
Are attacked to my server?



7
stefan88
Re: CPU over loaded problem
  • 2009/2/1 23:20

  • stefan88

  • Community Support Member

  • Posts: 1085

  • Since: 2004/9/20


Hi,

what modules are you using?
..

8
irmob
Re: CPU over loaded problem
  • 2009/2/5 13:15

  • irmob

  • Just popping in

  • Posts: 25

  • Since: 2005/10/2


I am using:
wfdownload
news
smartsection
multimenu
my album
mastop go
protector
sitemap
contact us
content

Login

Username:
Password:

Lost Password? Register now!

Who's Online

67 user(s) are online (32 user(s) are browsing Support Forums)


Members: 0


Guests: 67


more...

Donat-O-Meter

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

Latest GitHub Commits