-----Original Message-----
Has anyone tried this?
http://rackerhacker.com/mysqltuner/
I'm going to give it a shot.
On Aug 4, 2008, at 7:19 PM, Hans Zaunere wrote:
I haven't used it in production, but I've reviewed it and it looks
pretty
good.
I'm curious if anyone else has tried it.
I used it on a few servers and it gave some nice suggestions.
Definitely faster than going through each variable, remembering what
it does, and figuring out if it needs to be adjusted. It does want
you to have an innodb buffer pool that matches the size of your data
which is obviously nice, but I don't think it's always necessary.
There may be a few other areas where you have to use your own
judgement. It's also worth running, making changes, running again,
and repeating. For some settings (like query cache size), it will
keep suggesting an incremental increase until you get it to the right
value.
-Rob
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
