High server load

[kapstokje78]

[solved] High server load

Hello,

I hope you can help me.

since a couple of days i have a high server load.

We run a vbulletin board and currently with 55 members online we have the following load:

I notice every time that we have a lot of lines with

/usr/local/php5/bin/php-cgi

and

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/

The time + with the mysql line is also high.

Optimized vbulletin already.

There is only 1 site on this dedi server.

Server load is going up and up.
2 days ago it was 113

 

[SeLLeRoNe]

I would suggest you to use php-cli and mod_ruid2, probably will load your server less with same security.

Also, you didnt menthioned dedi server specs that would be nice to know.

Regards

 

[kapstokje78]

i'm running with cgi for over 9 months without problems.
Can it come this suddenly?

Serverspecs:

Intel(R) Pentium(R) CPU G6950 @ 2.80GHz DUAL
4 GB ram
directadmin
Apache 2.2.22
MySQL 5.5.14
Php 5.3.10 / CGI - SUPHP

If i have to go back to CLI is this possible to do with suphp.
Should i just rebuild it with the options in the custombuild?
Should i change permissions on the server?

Thanks in advance

 

[SeLLeRoNe]

If you will run mod_ruid2 you can just follow the guide present on this fourm.

Regarding passing from cgi to cli i suppose that just the option.conf in custombuild change have to be made and rebuild php after that.

Also, i would suggest you to upgrade to apache 2.4.

I dont know and honestly i think suphp will not work with php cli.

But, if you wanna stay on cgi, at least think about upgrade apche.

The server load is probably due to high traffic on websites, you can maybe limit connection per ip or upgrade your server performance.

As far as i did read php-cgi use a lot of resources.

Regards

 

[kapstokje78]

As usual,

Post an support topic and you'll find the problem

It was probably caused by a vbulletin plugin.

Deleted that certain plugin and the load is stable again.
Weird, because when we manually disabled all plugins, there wasn't a big difference.

Thanks for your help and i will look at the server for a few more days if it's necessary to change to cli.

 

[nobaloney]

I and others will still recommend you convert to using mod_ruid2. It did wonders for me; servers that came to their knees with only a few WordPress sites are running well again. As mentioned previously, both Apache 2.4 and mod_ruid are very good for speed and resource usage, and mod_ruid is quite secure; most people think as good as running PHP as CGI.

Jeff

 

[kapstokje78]

Ok, i changed to cli with mod_ruid2, but apache 2.4 gives errors, so i quickly revert the apache to 2.22
Error is with mod_ruid2:

Starting httpd: httpd: Syntax error on line 18 of /etc/httpd/conf/httpd.conf: Cannot load /usr/lib/apache/mod_ruid2.so into server: /usr/lib/apache/mod_ruid2.so: undefined symbol: unixd_config

 

[SeLLeRoNe]

Cause once you pass to apache 2.4 you must reinstall mod_ruid2 for be sure is compiled again apache 2.4

So, upgrade to apache 2.4 and re-install mod_ruid2

Regards

 

[kapstokje78]

yes, i just read it in the mod_ruid thread.
Still some errors, but solved them and itś working now.
Thanks