Buy Percona ServicesBuy Now!

Join ProxySQL Tech Talks with Percona on June 4th, 2020!

 | May 29, 2020 |  Posted In: MySQL, Open Source Databases, Tools

ProxySQL Tech Talks with Percona

Long months of the pandemic lockdown have brought to life many great online events enabling the MySQL community to get together and stay informed about the very recent developments and innovations available to MySQL users. It isn’t over yet! Next Thursday, June 4th, Percona & ProxySQL are co-hosting the ProxySQL Tech Talks with Percona virtual […]

Read More

Are your Database Backups Good Enough?

 | September 20, 2019 |  Posted In: Events, MySQL

In the last few years there have been several examples of major service problems affecting businesses data: outages causing data inconsistencies; unavailability or data loss, and worldwide cyberattacks encrypting your files and asking for a ransom. Database-related incidents are a very common industry issue- even if the root cause is not the database system itself. […]

Read More

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

A Nice Feature in MariaDB 10.3: no InnoDB Buffer Pool in Core Dumps

 | June 28, 2018 |  Posted In: MariaDB, MySQL

InnoDB buffer pool size

MariaDB 10.3 is now generally available (10.3.7 was released GA on 2018-05-25). The article What’s New in MariaDB Server 10.3 by the MariaDB Corporation lists three key improvements in 10.3: temporal data processing, Oracle compatibility features, and purpose-built storage engines. Even if I am excited about MyRocks and curious on Spider, I am also very […]

Read More