Plesk 11.0.9 too slow after upgrade

[technick]

Hello ,

after plesk updated to 11.0.9 version my server is very slow . Load average has increased a lot and also the panel is too slow . Some domains point at default page but this has been fixed after httpdmng --reconfigure-all and with several restarts of apache and nginx .

Also this server hosts a site with large traffic and for this reason we have fully optimized nginx and apache . Everything was working fine since the update . Any suggestions ..?? Below I paste a screen from top ..

top - 09:26:03 up 1 day, 23:40, 3 users, load average: 8.20, 4.69, 3.55
Tasks: 308 total, 1 running, 288 sleeping, 19 stopped, 0 zombie
Cpu(s): 9.2%us, 1.8%sy, 0.0%ni, 69.5%id, 19.3%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 32924656k total, 30020952k used, 2903704k free, 189024k buffers
Swap: 33553328k total, 21456k used, 33531872k free, 26501588k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
24950 apache 20 0 395m 42m 21m S 7.0 0.1 0:00.82 httpd
24956 apache 20 0 396m 43m 21m S 6.6 0.1 0:00.77 httpd
24946 apache 20 0 395m 42m 21m S 6.3 0.1 0:01.49 httpd
25165 apache 20 0 394m 42m 21m S 6.0 0.1 0:00.55 httpd
25161 apache 20 0 393m 42m 20m S 5.7 0.1 0:00.98 httpd
24942 apache 20 0 424m 78m 27m S 5.3 0.2 0:02.76 httpd
25163 apache 20 0 393m 42m 21m S 5.3 0.1 0:00.45 httpd
25172 apache 20 0 394m 42m 20m S 5.3 0.1 0:00.63 httpd
24947 apache 20 0 394m 43m 23m S 5.0 0.1 0:00.66 httpd
25164 apache 20 0 393m 41m 20m S 5.0 0.1 0:00.41 httpd
25171 apache 20 0 393m 41m 20m S 5.0 0.1 0:00.46 httpd
24943 apache 20 0 426m 78m 27m S 4.7 0.2 0:01.42 httpd
25173 apache 20 0 393m 41m 20m S 4.7 0.1 0:00.44 httpd
28979 mysql 20 0 4806m 392m 7496 S 3.0 1.2 34:05.74 mysqld
25175 root 20 0 109m 17m 4576 S 2.0 0.1 0:00.06 pmmcli
25170 apache 20 0 391m 40m 21m S 1.0 0.1 0:00.18 httpd
25093 psaadm 20 0 376m 58m 28m S 0.7 0.2 0:00.24 sw-engine-cgi

 

[abdi]

When in TOP, please press "Shift-M" that should sort by the process eating much RAM.

Had you restarted your server after the upgrade? Usually this helps a-lot ...Otherwise, give me the TOP results with a SHIFT-M

 

[technick]

This is what top with shift m shows ..

top - 13:26:32 up 2 days, 3:40, 3 users, load average: 5.08, 7.97, 9.27
Tasks: 323 total, 14 running, 304 sleeping, 4 stopped, 1 zombie
Cpu(s): 5.7%us, 1.4%sy, 0.0%ni, 81.4%id, 11.3%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 32924656k total, 23981136k used, 8943520k free, 307928k buffers
Swap: 33553328k total, 29148k used, 33524180k free, 20021776k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2251 mysql 20 0 4775m 350m 7304 S 5.7 1.1 8:04.84 mysqld
15354 apache 20 0 558m 189m 5420 S 0.0 0.6 0:07.53 httpd
18355 apache 20 0 408m 57m 22m S 0.5 0.2 0:01.68 httpd
20266 apache 20 0 408m 56m 21m S 0.0 0.2 0:00.66 httpd
20262 apache 20 0 405m 54m 22m S 0.0 0.2 0:01.68 httpd
18575 apache 20 0 405m 54m 23m S 0.0 0.2 0:03.62 httpd
18721 apache 20 0 499m 54m 23m S 0.0 0.2 0:04.04 httpd
18599 apache 20 0 401m 53m 25m S 0.5 0.2 0:02.92 httpd
18322 apache 20 0 403m 53m 22m S 0.0 0.2 0:04.11 httpd
18331 apache 20 0 404m 53m 22m S 0.0 0.2 0:03.93 httpd
20672 apache 20 0 404m 53m 21m R 5.7 0.2 0:00.81 httpd
16638 apache 20 0 498m 52m 23m S 0.0 0.2 0:06.71 httpd
20272 apache 20 0 403m 52m 21m S 0.0 0.2 0:01.82 httpd
20269 apache 20 0 403m 52m 21m S 0.0 0.2 0:01.44 httpd
20665 apache 20 0 403m 52m 21m S 0.0 0.2 0:00.98 httpd
19706 apache 20 0 403m 51m 22m S 0.0 0.2 0:03.90 httpd
20716 apache 20 0 403m 51m 21m S 0.0 0.2 0:00.70 httpd
19713 apache 20 0 497m 51m 23m S 0.0 0.2 0:03.26 httpd
20274 apache 20 0 402m 51m 21m S 0.5 0.2 0:01.83 httpd
20475 apache 20 0 403m 51m 20m R 2.6 0.2 0:00.96 httpd
18590 apache 20 0 401m 50m 23m S 0.0 0.2 0:04.18 httpd
20482 apache 20 0 403m 50m 20m S 0.0 0.2 0:00.57 httpd
20256 apache 20 0 403m 50m 20m S 0.0 0.2 0:01.39 httpd
20692 apache 20 0 403m 50m 20m S 0.0 0.2 0:00.99 httpd
20719 apache 20 0 401m 50m 21m R 3.6 0.2 0:00.64 httpd
20270 apache 20 0 403m 50m 20m S 0.0 0.2 0:00.83 httpd
20467 apache 20 0 401m 50m 21m S 0.0 0.2 0:00.68 httpd
20709 apache 20 0 401m 50m 21m S 1.0 0.2 0:01.07 httpd
20260 apache 20 0 401m 50m 21m S 0.0 0.2 0:01.08 httpd
18620 apache 20 0 400m 50m 22m S 0.0 0.2 0:04.54 httpd
20481 apache 20 0 401m 50m 20m R 4.1 0.2 0:01.30 httpd
18520 apache 20 0 399m 50m 22m S 0.5 0.2 0:03.62 httpd
20248 apache 20 0 401m 49m 20m S 0.0 0.2 0:02.13 httpd
20670 apache 20 0 401m 49m 21m R 4.1 0.2 0:00.57 httpd
20470 apache 20 0 400m 49m 21m R 1.6 0.2 0:00.83 httpd
20265 apache 20 0 401m 49m 21m S 0.0 0.2 0:02.06 httpd
18593 apache 20 0 400m 49m 22m S 0.0 0.2 0:03.80 httpd
20462 apache 20 0 401m 49m 20m R 4.1 0.2 0:01.15 httpd
18379 apache 20 0 399m 49m 22m S 0.0 0.2 0:04.31 httpd
18354 apache 20 0 399m 49m 22m S 0.0 0.2 0:04.53 httpd
20691 apache 20 0 401m 49m 20m R 5.2 0.2 0:00.80 httpd
20712 apache 20 0 401m 49m 20m S 0.0 0.2 0:00.93 httpd
20667 apache 20 0 400m 49m 21m S 0.0 0.2 0:00.44 httpd

 

[technick]

I have also restarted server and reconfigured all domains ... something might have happened with mysql

 

[abdi]

No MySQL is just OK. You can always monitor what queries are being processed through mytop. However from what I see you seem to have a lot of traffic on your server. (if not you are under a DOS attack). May I suggest the following:

1. Optimize Apache (at least with the following basics)

vim /etc/httpd/conf/httpd.conf

and set the following

KeepAlive On
KeepAliveTimeout 2

More here:
http://emergent.urbanpug.com/?p=60
https://www.virtacoresupport.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=102
http://www.crucialp.com/resources/t...ze-tweak-high-traffic-servers-apache-load.php

2. Optimize MySQL (atleast with the following basics)

vim /etc/my.cnf

and change to the following

wait_timeout=50
connect_timeout=50

More here: http://www.debianhelp.co.uk/mysqlperformance.htm

Depending, you can bring that value lower ...

3. Please install and enable Nginx, it will help really reduce on the Apache LOAD and increase the efficiency of your server.

 

[technick]

Thank you for your reply , I have already tuned mysql , apache and nginx ... I believe that the problem relies on mysql .. anyway I formatted the server and I made a restore ..

 

[abdi]

Did the re-installation solve the problem?

 

[technick]

yes it did ..

 

[abdi]

Alright, thanks for that information.