Practices for reducing MySQL database size
Database storage costs (Flash, SAS drives, etc) are still not cheap, so fighting against rapidly growing database size is important. Reducing datasize can be done from both application standpoint and database internal standpoint. Typical examples for application tuning are such as archiving, deleting, aggregating records. Examples for database internal tuning are such as using InnoDB compression, defragmentation, using different storage engine, etc. Apparently understanding your applications is critical to reduce datasize. It is not uncommon to reduce database size by 40-80%.
In this talk, the speaker will cover performance tuning tips and tricks based on experiences from running critical Facebook database infrastructure.