Buy Percona ServicesBuy Now!

Webinar Wednesday, December 20, 2017: InnoDB Performance Optimization

 | December 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, Technical Webinars

InnoDB Performance Optimization

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents InnoDB Performance Optimization on Wednesday, December 20, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8). InnoDB is one of the most commonly used storage engines for MySQL and Percona Server for MySQL. It balances high reliability with high performance and is the focus of the majority […]

Read More

Percona Server for MySQL 5.7.20-18 Is Now Available

 | December 14, 2017 |  Posted In: Events and Announcements, MyRocks, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona Server for MySQL

Percona announces the GA release of Percona Server for MySQL 5.7.20-18 on December 14, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.20, including all the bug fixes in it, Percona Server for MySQL […]

Read More

MySQL vs. MariaDB: Reality Check

 | November 2, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL vs. MariaDB

In this blog, we’ll provide a comparison between MySQL vs. MariaDB (including Percona Server for MySQL). Introduction The goal of this blog post is to evaluate, at a higher level, MySQL, MariaDB and Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from […]

Read More

MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0

 | October 31, 2017 |  Posted In: Database Monitoring, InnoDB, MySQL, Percona Monitoring and Management

In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0. As the part of Percona Monitoring and Management development, we’re constantly looking for better ways to visualize information and help you to spot and resolve problems faster. We’ve made some updates to the […]

Read More

How to Choose the MySQL innodb_log_file_size

 | October 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss. MySQL’s […]

Read More

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

 | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read More

One Million Tables in MySQL 8.0

 | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions […]

Read More