NinkWare Tech Forge

Percona

What an awesome company and tool set.  The wizard is killer.  Here is how I use it.

Tools

mysqltuner.pl (or just google “mysqltuner.pl”, literally, and a page of code will show up for you to copy into a file).  I luv this wee tool.

What to do

# forgive me I am ultra paranoid.  Hate having a db 
# server bomb out and even if the old way wasn't great, 
# it DID work.
cd /etc/mysql
cp -p my.cnf my.cnf.save # best to do this man.

• Run on-line wizard.  Review it’s documentation too.  Helps quite a bit.
• DANGER DANGER: do NOT use the final result as your entire my.cnf.  It probably won’t work.  You can try, but I sure hope you did the backup I stated above.
• So what you do is “compare” the wizard’s ideas with what you have.  Modify as you see fit.
• Test with mysqltuner.pl
  • copy to your db server (yes you can do remote, but hey, you are tuning the db server are thee not?
    • Hit your site with a browser, best to use the most db intensive pages
      • if you don’t do this, you will get the same report results from mysqltuner.pl
    • perl mysqltuner.pl
  • Now adjust my.cnf
    • you will most invariably have to google for a lot of this info and what to change and why.  And trust you me, the same questions get posed a lot on the web.
• REPEAT in the FUTURE
  • This is important.  You will need some activity over time to really tune your db properly.