I have CPU usage problem and It's killing me, I moved to VPS with 2GHz CPU and 4GB RAM but I still have 100% CPU usage when the website has 200 Visitor at the same time. at first I though that might be for a plugins and bad code in components, and try to install clean joomla version 1.5.22 and latest k2 and just restore the k2 and users tables, but situation was the same, I got help to configure severs from Cpanel developers, and my php apache mysql is working perfectly.
after 2 weeks of searching, trying and geting help from professional the only things that I can think about is my database collation utf8-general-ci and my utf8 data!
What do you think? please please allows me to know your ideas, experiences and any useful information.
Database Version:
5.0.91-community-log
Database Collation:
utf8_general_ci
PHP Version:
5.2.16
Web Server:
Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Web Server to PHP interface:
cgi-fcgi
Joomla! Version:
Joomla! 1.5.22 Stable [ senu takaa ama woi ] 04-November-2010 18:00 GMT