Buy Percona ServicesBuy Now!

Impact of innodb_file_per_table Option On Crash Recovery Time

 | July 23, 2019 |  Posted In: MySQL, Open Source Databases

Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces. It provides some advantages. I will highlight some of them: You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally […]

Read More

Percona Live Presents: Globalizing Player Accounts with MySQL at Riot Games

 | May 28, 2019 |  Posted In: Events, MySQL, Open Source Databases

During my presentation at Percona Live 2019, I’ll be talking about how Riot Games, the company behind League of Legends, migrated hundreds of millions of player accounts to unlock opportunities for us to delight players. This meant moving ten geographically distributed databases into a single global database replicated into four AWS regions. I’ll talk about […]

Read More