Session
What Causes Downtime in MySQL, and How Can You Prevent It?

January 11th, 2012 @ 10:55AM

Abstract

Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising, and will be detailed in this talk.

Tracks: Manager, DBA

Level: Intermediate

Speaker

Baron Schwartz

Chief Performance Architect, Percona

Baron is the lead author of High Performance MySQL, and creator of Maatkit. He consults with Percona's customers, and develops tools and practices for Percona's team.