Editing my.cnf (mySQL settings)

#1 fshagan

Member

Group: Members
Posts: 139
Joined: 10-January 11

Posted 22 January 2011 - 12:55 PM

Looking at recommendations from scripts that evaluate your mySQL performance, I want to tinker with some settings. Because I'll change a setting, wait a while, then change it again, I don't want to be putting in more tickets (even though I'm sure MDD doesn't mind, I find I learn better by "doing"). Using "which mysql", I see that the active mySql is /usr/bin/mysql. Using "locate my.cnf", the configuration file, I get these results:

/etc/my.cnf
/root/.my.cnf
/usr/local/cpanel/whostmgr/my.cnf
/var/cpanel/configs.cache/_root_my.cnf_<long key number here>

So which one of those do I edit to make changes?

#2 MikeDVB

Forum Administrator

Group: Staff Administrator
Posts: 1,545
Joined: 27-September 08
Gender:Male
Location:Central Indiana, USA

Posted 23 January 2011 - 01:50 PM

It would be /etc/my.cnf however I wouldn't suggest messing with it unless you know what you're doing or you can cause MySQL downtime and at worst, database corruption. Do be careful or open a ticket.

█ Michael Denney - MDDHosting, LLC - Professional Hosting Solutions
█ LiteSpeed Powered - Shared, Reseller, Semi-Dedicated, and VPS
█ Incremental R1Soft CDP Backups on all shared, semi-dedicated, and VPS services!
█ http://www.mddhosting.com/ - Follow us on Twitter!

#3 fshagan

Member

Group: Members
Posts: 139
Joined: 10-January 11

Posted 23 January 2011 - 11:00 PM

MikeDVB, on 23 January 2011 - 01:50 PM, said:

It would be /etc/my.cnf however I wouldn't suggest messing with it unless you know what you're doing or you can cause MySQL downtime and at worst, database corruption. Do be careful or open a ticket.

OK, you talked me into another ticket!

No hurry on this one, the VPS is running fine, and my customers are happy. I do have several Wordpress and forum sites on the server, so there are fair number of queries happening.