CPU Usage and My SQL Process load issue

[friendlymela]

Hey experts i am developing my website url: www.friendlymela.com with Vbulletin 4.2.2 patch 1, recently i have read article that Vbulletin required minimum php version 5.3.29 so i was requested with my host to change it then he had changed it to 5.4.27 but after then i face loading issue on forum. my forum loaded very much slow after then they have provided me the following issues occurring on my forum



The limits of excessive usage for each resource are:

CPU %: 1.0-2.0 is Moderate, 3.0 is High, higher than 4.0 is Unacceptable. This is the average percentage of the entire server's CPU used by your account. This is of all processors combined.
Memory %: 0.0-1.0 is Moderate, 2.0 is High, higher than 5.0 is Unacceptable. This is the average percentage of the entire server's Memory used by your account in that day.
MySQL Usage: 0.0-1.0 is Moderate, 2.0 is High, higher than 2.5s is Unacceptable. This is the average number of Mysql instances you were running at all specific seconds of that day.


More often than not, single spikes in usage are attributed to abuse by your visitors, resource-exhaustive web platforms, or plugins of those platforms.

To assist you to isolate the source of usage, we have identified your top processes with highest usage in the past 7 days. They are:
Date % CPU Process
Oct 11th 9.5 httpd [friendlymela.com] [/newreply.php?dopostreply&t37677]
Oct 11th 8.5 httpd [friendlymela.com] [/showthread.php/37175-Crispy-Sweet-Noodles?sf93dd1f37ad76a]
Oct 11th 8.4 httpd [friendlymela.com] [/showthread.php/347-Sabzii-Mandiiii-p?p3039&viewfull1]
Oct 10th 67.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php
Oct 10th 64.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/forumdisplay.php
Oct 10th 53.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/forumdisplay.php
Oct 09th 73.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php
Oct 09th 66.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php
Oct 09th 59.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/forumdisplay.php
Oct 08th 90.0 [php-cgi] <defunct>
Oct 08th 88.0 [php-cgi] <defunct>
Oct 08th 87.0 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/index.php
Oct 07th 128 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/index.php
Oct 07th 126 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php
Oct 07th 110 [php-cgi] <defunct>
Oct 06th 104 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php
Oct 06th 103 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/index.php
Oct 06th 102 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/index.php
Oct 05th 135 [php-cgi] <defunct>
Oct 05th 128 [php-cgi]
Oct 05th 118 /opt/ntphp/php54/bin/php-cgi /home/friendmela/public_html/showthread.php


After then i told them to return my php version to 5.3.28 as it was before but still my site loading very slow, i have done alots of things and disable many mods from my website as well as i have block bad bots and compress images sizes etc in .htaccess and banned Baidu Spider by mod.

One thing more i want to point out that the following options are not changing thier values since 7 or 8 days. kindly have look screen shot of my cpanel also Resources Usage are showing that There has been no activity on your site within the past 24 hours.

[IMG]There has been no activity on your site within the past 24 hours[/IMG]

I am bit confused about all this matter. please anyone help me to sort out the issue and help me to resolve it please.

Regards,

Zee Leo