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
15 years+ experience as Data Architect/DBA specializing in high volume OLTP and data warehouse environments starting with Oracle and branching out into MySQL in 2003.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).
View a complete list of O'Reilly MySQL Conference contacts.