MacResource
Someone please optimize my my.cnf file - Printable Version

+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Someone please optimize my my.cnf file (/showthread.php?tid=20481)



Someone please optimize my my.cnf file - Greg the dogsitter - 10-13-2006

Is there any software that, after running a bunch of queries on a MySQL database, will tell you which of your my.cnf parameters need adjusting?

"Hey, you could index a lot faster of our thingee_cache size were increased; you have Y total, so I'd recommend setting it to X."

Like that. Yeah.


Re: Someone please optimize my my.cnf file - mattkime - 10-13-2006

Some people find it satisfying to adjust their own parameters.


Re: Someone please optimize my my.cnf file - Greg the dogsitter - 10-13-2006

No doubt!


Re: Someone please optimize my my.cnf file - mattkime - 10-13-2006

hm....this is a good idea though. let me know if you find any good info.

...then again, mysql isn't my bottleneck...