Optimal my.cnf Settings

[markb14391]

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]

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.

 

[markb14391]

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

 

[cPanelMichael]

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.

 

[Infopro]

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!