High CPU usage

Hello,

We are running Version 7.1.2 Sugar Version 6.5.17 (Build 1220) on ubuntu. We also have QuickCRM app for our mobile users.

I keep seeing processes on the server consuming the CPU. I have seen as many as 6 in this CPU hungry position. They do not die or go away . I have to kill them.

Here is a sample of the top command on the server.

top - 15:04:10 up 21:48, 2 users, load average: 1.14, 1.23, 1.33
Tasks: 180 total, 2 running, 178 sleeping, 0 stopped, 0 zombie
Cpu(s): 92.4%us, 5.3%sy, 0.0%ni, 2.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 3083840k total, 2549388k used, 534452k free, 95860k buffers
Swap: 524284k total, 61192k used, 463092k free, 1243396k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18088 web5 20 0 305m 52m 25m R 95.6 1.7 6:00.47 /usr/bin/php-cgi -d open_basedir=none -d upload_tmp_dir=/var/www/clients/client2/web5/tmp -d session.save_path=/var/www/clients/client2/web5/tmp
18236 web5 20 0 307m 54m 24m S 0.0 1.8 0:01.23 /usr/bin/php-cgi -d open_basedir=none -d upload_tmp_dir=/var/www/clients/client2/web5/tmp -d session.save_path=/var/www/clients/client2/web5/tmp

Any idea what might be causing the high CPU demand?

Thanks,
Jeff

That’s because your PHP on the server is running as a CGI script which means most probably your web server is configured to process all PHP scripts using those processes.

If you kill them other’s will spawn because server has been most probably configured to keep that service alive and the service itself has a minimum processes to spawn and maximum that it can have.

Get in touch with your System Administrator to resolve you the issue, there is not really a “quick” fix.

Thanks for the reply.

Unfortunately I am the system admin as well. I am running ISPconfig3 and had it set to use php-fastcgi. I have switched it php-fpm and have seen some performance improvement.

No I have like 20+ php-fpm processes like the following.
702 web5 20 0 342m 69m 13m S 0.0 2.3 4:24.41 php-fpm: pool web5

On Monday’s and Tuesday’s they pin the CPU 100%. Then on Wednesday around noon the CPU usage drops back down to normal. The same thing happened last week.

So it seem like something in the scheduler might be the culprit. Need to check and see what runs starting Sunday evening.

Any thoughts what might cause this process spike and then drop off later in the week?

Thanks,
Jeff