High CPU usage

[MRatWork]

Your 'ps aux|grep mysql' is a normal service loaded.

[cvrle77]

So, all I need to switch from mod to php_fpm?

[MRatWork]

My recommendation is using php-fpm_event (for apache or -proxy). Lighttpd/Nginx/Hiawatha automatically using php-fpm.

[cvrle77]

Well, I am using nginxproxy since day one



So, if proxies are using php-fpm_event automatically, that means I was already using it.

I don't really think my sites are high traffic ones with 30-60 users online.

And even after switching, load is still unchanged. Also, this is SSD VPS, with IO of 300-600MB/s, so that isn't an issue here...

When I mentioned mysql, all I said is that in htop, before changes, I had 4 mysqld processes visible, and after change there were 8+, I never said mysql is an issue.

[cvrle77]

Now after change, I have Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

error 500

[MRatWork]

I think your issue related to http://forum.mratwork.com/kloxo-mr-releases-and-announcements/(update)-please-update-to-6-5-0-f6-5-1-b-to-201405102201405104/

You need update Kloxo-MR first.

[cvrle77]

Did everything, but I see 0 improvement. Load still jumping on 1, and main processes php-fpm: pool admin are eating CPU. I have to stop httpd every time it reaches load of 1, so I don't get banned from hosting.

[MRatWork]

There something in your website application using cpu too high.

I am not sure, maybe you can limiting with 'ulimit'.

Inform here 'ulimit -a'.

[cvrle77]

ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 7823
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 7823
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

[MRatWork]

Read http://www.itworld.com/operating-systems/317369/setting-limits-ulimit and http://www.askapache.com/optimize/optimize-nice-ionice.html

[cvrle77]

As I said in my first post

After my last venture  from here http://forum.mratwork.com/kloxo-mr-technical-helps/php-broke/ , I've noticed load increase from max 0.5 to 1.5+ which got me suspended from my VPS provider today, and don't know what caused this, since I haven't changed anything in my website setup.

I never touched anything on my VPS regarding websites (i've even disabled lots of stuff to see if plugins or theme is causing those issues), I had smooth config with kloxo mr, before I've updated everything, after that bad venture with trying to install APC.

At around 18th april there was some holiday, and I had over 70K PV and load of 0.3, I had more than 200 people  online at the same time, now when it comes close to 50 people online, load goes to 1, few people more and it goes up over 1. I have WP super cache installed, Better Wordpress Minify, static content is served all the time and I can see that in source by the date cache file is created.

I know this can work smooth, with waaaay lesser load on server, because I've had it, and lost that setup after updates...

[merbot]

also
check this with mysqltuner

[I<3Kloxo]

As I understand for web sites that have hight traffic it is better "php-fpm_event" ? Is that correct?

Edit:
I changed to php-fpm_event and I do not see any change regarding CPU.

[I<3Kloxo]

bump !

[MRatWork]

Try 'sh /script/mysql-optimize --select=repair'. Maybe something wrong your database.