Database Optimizations

To make sure our db is ready for 10x growth earlier this autumn we’ve done a deep dive into the entire functioning of our database.

We’ve updated the software with the latest patches, reviewed and improved our most demanding queries using the slow query log, reviewed our table indexes, backup strategy and procedures for restoring a backup and more.

As a result:

• you should immediately see a noticeable decrease in the time required to load the recordings and logs pages with large data sets (thousands and tens of thousands of recordings)
• we’re now getting the most out of the resources on the db server and it is ready to handle much higher peaks but also more sustained load
• daily backups are faster and have close to no impact on performance
• we have an improved db monitoring and alert system
• our db size is smaller < removed any orphan rows and eliminated unnecessary columns
• we’ve rehearsed our backup restoring procedures and improved them. We now feel a lot more confident in our ability to restore a complete backup if we will ever need to do that (hopefully not!).