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

Group Replication: The Sweet and the Sour

 | August 1, 2017 |  Posted In: GTID, High-availability, InnoDB, MySQL, Percona XtraDB Cluster, PMM

Group Replication

In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.  Overview In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).  While I have extensively covered the first, my last serious work on […]

Read More

Platform End of Life (EOL) Announcement for RHEL 5 and Ubuntu 12.04 LTS

 | July 31, 2017 |  Posted In: Events and Announcements, InnoDB, MariaDB, MongoDB, MySQL, Percona Software, Percona Support

End of Life

Upstream platform vendors have announced the general end of life (EOL) for Red Hat Enterprise Linux 5 (RHEL 5) and its derivatives, as well as Ubuntu 12.04 LTS. With this announcement comes some implications to support for Percona software running on these operating systems. RHEL 5 was EOL as of March 31st, 2017 and Ubuntu […]

Read More

Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication High Availability Webinar: Q & A

and  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster

High Availability Webinar

Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of the webinar here. Is there a minimum MySQL server version for […]

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 Live Open Source Database Conference Europe 2017 in Dublin, Ireland Call for Papers is Open!

 | June 5, 2017 |  Posted In: InnoDB, MariaDB, MongoDB, MyRocks, MySQL, Percona Live

Colin Charles

Announcing the opening of the Percona Live Open Source Database Conference Europe 2017 in Dublin, Ireland call for papers. It will be open from now until July 17, 2017.* Do you have a big idea to explain, use case to share or skill to teach? Submit your speaking proposal for either breakout or tutorial sessions. […]

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 Live Open Source Database Conference 2017 Slides and Videos Available

 | May 16, 2017 |  Posted In: Big Data, Cloud and MySQL, Cloud and NoSQL, Column Store Database, Database Monitoring, Docker, Group Replication, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, MySQL 101, Percona Live

Percona Live

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]

Read More