Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. I was successful in streaming the live video on www.ustream.tv, and you can see it in totality at http://www.ustream.tv/recorded/352479.
The slides are available in pdf form. And here are some of the links I spoke about:
cacti
nagios
rt
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
Maatkit, contains mk-query-profiler
and mk-table-sync
mytop
innotop
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:
cacti
nagios
rt
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
mytop
innotop