Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : Vps high useage need help!

[Reece|StormingHost]

Hello i have a vps and its quite a new one since i just ordered it and transfered everything from my previous..

But im getting really high cpu useage and im wanting to know whats best ways to optimize this...

Is there any scripts etc that will help?

[cselzer]

We need to know: what server software, php? mysql? apache? lighttpd? we need to know what you're using.. and as far as scripts.. no.. we need to know what software you're using.

[Reece|StormingHost]

We are using ccpanel,apache etc the normal stuff.

Heres some info im getting from WHM:
User Domain %CPU %MEM MySQL Processes
root 4.55 15.10 2.0
Top Process %CPU 15.1 /usr/bin/python /usr/bin/yum -y update
Top Process %CPU 14.8 /usr/bin/python /usr/bin/yum -y update
Top Process %CPU 10.3 /usr/bin/python /usr/bin/yum -y update
mysql 2.52 1.01 0.0
Top Process %CPU 2.6 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/nl***********..pid --skip-external-locking
Top Process %CPU 2.5 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/nl***********.pid --skip-external-locking

Are these needed i didnt have them on my old server...

and im hitting 4.00 cpu

[UNIXy]

You yum updates seem a bit on the high side. Kill all yum updates and run the yum update manually to see if it completes normally.

Regards

[Reece|StormingHost]

Hello could you tell me how i can kill the processes of this please.

and also how i should optimize my vps i am hosting multiple websites on it..

[AshS]

What sort of resources [i.e RAM, CPU access] does your VPS have?

[Reece|StormingHost]

I have 1gb ram and CPU im not really sure to be honest...

I have restarted server and well its not coming back online..

Thanks

[johnch]

Originally Posted by Reece|StormingHost

Hello could you tell me how i can kill the processes of this please.

and also how i should optimize my vps i am hosting multiple websites on it..

top

kill processid

[XENnode]

Originally Posted by Reece|StormingHost

I have 1gb ram and CPU im not really sure to be honest...

I have restarted server and well its not coming back online..

Thanks

You rebooted and the VPS won't start?

[Reece|StormingHost]

Sorry its back online now, i have made some edits to apache and load has gone down alot! way under 1.00 now instead of 4.00 +

Does anybody have any tips to help optimize mysql?

thank you

[samurai7]

Login to WHM and choose "Update Config" > "Security Package Updates" > "Manual Updates Only"

This will fix the update which is consuming load, unless you have a manually configured cron.

In order to tweak mysql, you should seek the help of an experienced administrator. Contact me at deadlysamurai7@gmail.com if you would like me do it for you.

[samurai7]

You should do that WHM tweak to prevent it happening again; rebooting won't be a permanent solution.