Better Database Debugging for Shorter Downtimes

Rob Hamel (Pythian) presents at the 2010 O'Reilly MySQL Conference & Expo.

Slides: http://assets.en.oreilly.com/1/event/36/Better%20Database%20Debugging%20for%2...

From the official conference description at http://en.oreilly.com/mysql2010/public/schedule/detail/13021



We will go through the most common issues we have faced in this regard and demonstrate how proper instrumentation at the database level can make you a better DBA.

These instrumentation techniques do not require special tools and can mostly be implemented via stored procedures, events, or simple shell scripts. The Pythian Group has developed and refined these techniques since 1998, for 52 different MySQL environments (clients) spread across 700+ databases.

Areas that will be addressed are:

collecting and using performance metrics (how and what to collect) Configuration auditing
DDL auditing
Event scheduler jobs
Range partitioning

Category:

Science & Technology

Tags:

• mysqlconf
• mysql
• debugging
• rob hamel
• pythian