FOSDEM is the biggest free and non-commercial event organized by and for the community. Its goal is to provide Free and Open Source developers a place to meet. No registration necessary.

   
Speakers
Stéphane Combaudon
Schedule
Day Saturday
Room H.2213
Capacity 100
Start time 18:30
End time 18:55
Duration 00:25
Info
Track MySQL & friends devroom

A practical overview of Maatkit

Maatkit has saved my day more than once. In this talk, I will show you real-life examples of hard problems that I had to solve, and how Maatkit provided elegant (and most of the time very efficient) solutions.

I will cover the following short stories:

  • When I run this query manually, I get an immediate answer, but when the same query is run by the application, it takes 30+s. Why?
  • Did you know that the data you're backing up is not the right data?
  • You say that we're running 400 SET queries/s. I doubt this, could we catch them live?
  • Last time I wanted to update this field in the whole table, it took 2 weeks. Any tips to run the update faster?
  • I had to skip an event on a slave. To avoid inconsistencies with the master, is rebuilding this 10GB table from scratch the only way?
  • We regularly have very long queries that freeze the whole server. Could we kill them automatically if they run for more than 50s?

And a few more if time permits.

Maatkit has saved my day more than once. In this talk, I will show you real-life examples of hard problems that I had to solve, and how Maatkit provided elegant (and most of the time very efficient) solutions.

I will cover the following short stories:

  • When I run this query manually, I get an immediate answer, but when the same query is run by the application, it takes 30+s. Why?
  • Did you know that the data you're backing up is not the right data?
  • You say that we're running 400 SET queries/s. I doubt this, could we catch them live?
  • Last time I wanted to update this field in the whole table, it took 2 weeks. Any tips to run the update faster?
  • I had to skip an event on a slave. To avoid inconsistencies with the master, is rebuilding this 10GB table from scratch the only way?
  • We regularly have very long queries that freeze the whole server. Could we kill them automatically if they run for more than 50s?

And a few more if time permits.