EmergencyEMERGENCY? Get 24/7 Help Now!

Updating InnoDB Table Statistics Manually

 | September 11, 2017 |  Posted In: Database Monitoring, InnoDB, Insight for DBAs, Insight for Developers, MySQL

InnoDB Tables

In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Read More

What is MySQL Partitioning?

 | July 27, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 101

MySQL Partitioning

In this blog, we’ll quickly look at MySQL partitioning. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want […]

Read More

MariaDB Server 10.2 GA Release Overview

 | June 19, 2017 |  Posted In: InnoDB, MariaDB, MySQL

MariaDB Server 10.2

This blog post looks at the recent MariaDB Server 10.2 GA release. Congratulations to the MariaDB Foundation for releasing a generally available (GA) stable version of MariaDB Server 10.2! We’ll definitely spend the next few weeks talking about MariaDB Server 10.2, but here’s a quick overview in the meantime. Keep in mind that when thinking about […]

Read More

Percona Server for MySQL 5.7.18-15 is Now Available

 | May 26, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software

Percona Server for MySQL 5.7.18-15

Percona announces the GA release of Percona Server for MySQL 5.7.18-15 on May 26, 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.18, including all the bug fixes in it, Percona Server for MySQL […]

Read More

ICP Counters in information_schema.INNODB_METRICS

 | May 22, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL, Percona Monitoring and Management, PMM

ICP Counters

In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series.  As mentioned in the previous post, in this blog we will look at how to check on ICP counters on MySQL and Percona Server for MySQL. This also applies to […]

Read More

Percona Server for MySQL 5.7.18-14 is Now Available

 | May 12, 2017 |  Posted In: MyRocks, MySQL, Percona Server, TokuDB

Percona Server for MySQL 5.7.18-15

Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 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.18, including all the bug fixes in it, Percona Server for MySQL […]

Read More

How much disk space should I allocate for Percona Monitoring and Management?

 | May 4, 2017 |  Posted In: Database Monitoring, InnoDB, MongoDB, MySQL, Percona Monitoring and Management, PMM

Percona Monitoring and Management

I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that consume non-negligible disk space: Prometheus data source for the time series metrics Query Analytics (QAN) which […]

Read More