Yesterday I presented “Best Practices for Database Administrators” at the .
The slides are available in pdf form. And here are some of the links I spoke about:
MySQL 5.0 manual
explain
show variables
show status
data types
procedure analyse()
mysqldumpslow’s manual page says “Use mysqldumpslow –help to see the options that this command supports.”
mysqlsla
mysqlreport
contains mk-query-profiler
and mk-table-sync