Results 1 to 2 of 2
Thread: MySQL High CPU Usage
Feb 3, 2011, 04:52 #1
MySQL High CPU Usage
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...
Feb 3, 2011, 13:28 #2
- Join Date
- May 2007
- Poole, UK
- 96 Post(s)
- 0 Thread(s)
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?