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

   
Speakers
Frédéric Descamps
Schedule
Day Sunday
Room AW1.121
Start time 11:45
End time 12:15
Duration 00:30
Info
Event type Podium
Track MySQL
Language English
Daily maintenance of big databases/tables

This talk is about maintaining (or trying to maintain) big databases with large tables with a minimum of downtime and the tools helping for those tasks.

  • Configure ibdata
  • Backup ?
  • Clean the data (optimize and archiving)
  • Status of long queries in realtime
A short overview of innotop, maatkit, ptxarchiver, ...