markb14391

Well-Known Member
Jun 9, 2008
305
2
68
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

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
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

Well-Known Member
Jun 9, 2008
305
2
68
Thanks Michael. I understand the tuning part, but I assume that it's best to start with initial settings. Where to start?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
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.