Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    471
    Likes Received:
    4
    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,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 HSN-Saman, Jan 11, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - High usage MySql
  1. Maning

    MYSQL high cpu usage issue

    Maning, Oct 13, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    1,018
    cPanelLauren
    Oct 19, 2018
  2. baowesome

    MySQL Very High CPU Usage issue

    baowesome, Apr 2, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    1,342
    cPanelMichael
    Apr 2, 2018
  3. Rogerio

    High CPU/disk usage - IMAP "sort"

    Rogerio, May 22, 2019 at 11:44 AM, in forum: E-mail Discussion
    Replies:
    5
    Views:
    180
    Rogerio
    May 23, 2019 at 8:51 AM
  4. Shehzad Hameed

    Question about High Memory Usage

    Shehzad Hameed, Mar 28, 2019, in forum: General Discussion
    Replies:
    2
    Views:
    390
    cPanelMichael
    Mar 29, 2019
  5. Denis Gomes Franco

    Server crash during backup, high CPU usage

    Denis Gomes Franco, Mar 3, 2019, in forum: Data Protection
    Replies:
    4
    Views:
    351
    Denis Gomes Franco
    Mar 4, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice