Best Practices for Database Administrators slides and links

Pythian has openings for MySQL and MS SQL Server DBAs in each of our offices in Ottawa, Canada; Boston, USA; Dubai, UAE; and Hyderabad, India. If you are a MySQL and/or SQL Server DBA and would like to evaluate this opportunity, please send us your résumé with an introductory paragraph to hr@pythian.com.

Best Practices for Database Administrators slides and links

By Sheeri Cabral — April 16th, 2008 at 12:05 pm
Posted in Group Blog Posts • MySQL
Tags: 2008 • best practices • conferences • MySQL • mysqlconf

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

These icons link to social bookmarking sites where readers can share and discover new web pages.