SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru SSJ's Avatar
    Join Date
    Jan 2007
    Posts
    830
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL High CPU Usage

    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. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,077
    Mentioned
    103 Post(s)
    Tagged
    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?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •