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.

Optimal my.cnf Settings

Discussion in 'Workarounds and Optimization' started by markb14391, Nov 5, 2013.

  1. markb14391

    markb14391 Well-Known Member

    Joined:
    Jun 9, 2008
    Messages:
    305
    Likes Received:
    2
    Trophy Points:
    18
    While I know that every server is different, I'm surprised that optimal my.cnf settings seem so elusive. Since cPanel is designed for shared hosting, I would imagine that some ideal starter settings could be established. However, everyone seems to have a different opinion on the configurations.

    Can anyone suggest good starter settings for shared hosting (WordPress, etc.) on a server with 3-4 GB RAM?

    I know results should be tuned over time, but I am focusing on the starter settings.

    Thanks,

    Mark
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Most servers have different types and amounts of CPU/RAM. In addition, the MySQL usage on most servers varies greatly. Thus, the use of a MySQL tuner script is recommended. There is a thread on obtaining your MySQL statistics for help with tuning at:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    Thank you.
     
  3. markb14391

    markb14391 Well-Known Member

    Joined:
    Jun 9, 2008
    Messages:
    305
    Likes Received:
    2
    Trophy Points:
    18
    Thanks Michael. I understand the tuning part, but I assume that it's best to start with initial settings. Where to start?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's fine to start with no modified configuration values. The default /etc/my.cnf file is suitable to have in place. Remember to let MySQL run for at least 24 hours before running the tuner. Then, after implementing the changes, you can keep those in place before running the tuner again after another 24 hours.

    Thank you.
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    This comment may be of some use to you:
    Re: MYSQL Configuration - cPanel Forums

    HTH! :)
     
Loading...

Share This Page