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!

MariaDB 10.0 high cpu usage.

Discussion in 'Workarounds and Optimization' started by Augusto Will, May 27, 2015.

  1. Augusto Will

    Augusto Will Active Member

    Joined:
    Sep 9, 2011
    Messages:
    43
    Likes Received:
    4
    Trophy Points:
    58
    cPanel Access Level:
    Root Administrator
    I need help to optimize and speed up my MariaDB.

    The service is using too much cpu (100% of all cores).

    I have an AMD Octacore (AMD Opteron Processor 3280) with 32Gb memory.

    My my.cnf is untouched.

    Can you help me please?

    Thank you.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Augusto Will

    Augusto Will Active Member

    Joined:
    Sep 9, 2011
    Messages:
    43
    Likes Received:
    4
    Trophy Points:
    58
    cPanel Access Level:
    Root Administrator
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    You run the script at your own risk as with any third-party application, however it is reviewable on GitHub:

    https://github.com/major/MySQLTuner-perl

    I've not seen any reports of it causing any problems with servers, as it's purpose is to provide guidance on MySQL configuration values.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice