Practices for reducing MySQL database size

Database Administration
25 April 12:50pm - 13:40pm @ Ballroom D

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.


Yoshinori Matsunobu
Database Engineer, Facebook
Yoshinori is a database engineer at Facebook. Before joining Facebook, Yoshinori was a database and infrastructure architect at DeNA, living in Tokyo. Yoshinori's primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.