The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

High CPU usage ONLY by MySql !!!

Discussion in 'Workarounds and Optimization' started by furquan, Jan 11, 2013.

  1. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    458
    Likes Received:
    3
    Trophy Points:
    168
    Hello all,

    My server load is quite optimal But in the "top -c" screen i see Only MySql process taking up 600% + of CPU utilization.

    Can any one point me, on how do i figure this out, what is causing this issue.

    The number of concurrent users is not very high either :-

    root@ netstat -an | grep :3306 |wc -l
    23

    My server configuration is as follows :-

    Pentium(R) Dual-Core CPU E5500 @ 2.80GHz
    4 GB RAM

    Any suggestion to debug this issue would be highly appreciated.

    Thank you,
     
    #1 furquan, Jan 11, 2013
  2. HSN-Saman

    HSN-Saman Member

    Joined:
    Jan 11, 2013
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Search "mysql optimization" on the forum , there are many topics .
    also try using mysqltuner.pl script to optimize mysql configuration.
     
    #2 HSN-Saman, Jan 11, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - High usage MySql
  1. janipewter

    MySQL constant high CPU usage

    janipewter, Feb 8, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    579
    cPanelMichael
    Feb 10, 2017
  2. urkeee

    Help - optimize mysqltunner to reduce high cpu usage

    urkeee, Nov 14, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    966
    cPanelMichael
    Nov 16, 2016
  3. wesley700r

    MySQL database high CPU usage

    wesley700r, Aug 18, 2016, in forum: Database Discussions
    Replies:
    2
    Views:
    558
    cPanelMichael
    Aug 23, 2016
  4. Ahmed Hany

    mysql high cpu usage issue

    Ahmed Hany, May 5, 2016, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    1,196
    Znuff
    May 17, 2016
  5. jjtt

    MySQL Extremely High CPU Usage

    jjtt, Apr 1, 2016, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    1,720
    cPanelMichael
    Apr 4, 2016

Share This Page