MySQL High CPU Usage

Databases
1

Hello Experts,

I need a help on mysql. I’ve a website with big database size and visitors are increasing day by day.

My problem is mysql using maximum CPU power. Normal usage of CPU is 65% and sometimes it reaches to 92%. That’s why CPU stops responding and there will be only option to restart CPU.

It’s a dedicated server and I checked the process list. Following mysql process is consuming more power:
7852 (Trace) (Kill) mysql 0

64.5 0.3 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/cpanel-101-465.xxx.xxx.xx.pid --skip-external-locking

When I checked this process through putty, I’ve seen some connections to tables which never get closed. Even I restart the mysql server, it automatically reaches to 60%.

Any help will be greatly appreciate…

Thanks,

2

What is the server-side language in use (ie php .net, asp, etc)?

Are you creating multiple connections to MySQL or are you creating one connection and sharing that connection around the app?