EmergencyEMERGENCY? Get 24/7 Help Now!

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables

 | December 28, 2016 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

Pepper.com

In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to back up. So if you’re running innodb_file_per_table=1, and […]

Read More

Percona Poll Results: What Database Technologies Are You Using?

 | December 21, 2016 |  Posted In: Database Poll, MongoDB, MySQL

This blog shows the results from Percona’s poll on what database technologies our readers use in their environment. We design different databases for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Big data and IoT applications, high availability, secure backups, security, cloud vs. on-premises deployment: each […]

Read More

Make MySQL 8.0 Better Through Better Benchmarking

 | December 2, 2016 |  Posted In: Benchmarks, MySQL

MySQL 8.0.1

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read More

Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7

 | November 30, 2016 |  Posted In: MySQL

InnoBD Buffer Pool Pre-Load Feature

In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7 Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default behavior. Without any special effort, MySQL saves and […]

Read More

The Future of TokuDB at Percona

 | November 1, 2016 |  Posted In: MySQL, TokuDB

TokuDB

In this blog post, I’ll discuss the future of TokuDB at Percona. Spoiler: solid. As soon as we announced the fact that MyRocks was coming to Percona Server for MySQL at Percona Live Europe, rumors appeared that this means we’re going to phase out TokuDB at the same time.   I can understand why those […]

Read More

Announcing MyRocks in Percona Server for MySQL

 | October 24, 2016 |  Posted In: MySQL, Percona Server for MySQL

MyRocks in Percona Server

Announcing MyRocks in Percona Server for MySQL. RocksDB has been taking the world by the storm! RocksDB counts Facebook, LinkedIn, Pinterest, Airbnb and Netflix among its users. It is the storage engine for many open source database technologies, including CockroachDB, Apache Flink, TiKV and Dgraph. It is also integrated with MySQL and MongoDB as the MyRocks and […]

Read More