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...
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?