Optimal my.cnf Settings

markb14391

• November 05, 2013 10:30

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

• 

  cPanelMichael

  • November 05, 2013 16:10

  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.

  0
• 

  markb14391

  • November 05, 2013 16:41

  Thanks Michael. I understand the tuning part, but I assume that it's best to start with initial settings. Where to start?

  0
• 

  cPanelMichael

  • November 05, 2013 16:58

  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.

  0
• 

  Infopro

  • November 05, 2013 21:09

  [quote="markb14391, post: 1497902">Thanks Michael. I understand the tuning part, but I assume that it's best to start with initial settings. Where to start?
  This comment may be of some use to you: Re: MYSQL Configuration - cPanel Forums HTH! :)

  0

Please sign in to leave a comment.