fshagan Posted January 22, 2011 Report Share Posted January 22, 2011 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? Quote Link to comment Share on other sites More sharing options...
Michael D. Posted January 23, 2011 Report Share Posted January 23, 2011 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. Quote Link to comment Share on other sites More sharing options...
fshagan Posted January 24, 2011 Author Report Share Posted January 24, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.