Tag - InnoDB

Avoid Shared Locks from Subqueries When Possible

Shared Locks

In this blog post, we’ll look at how to avoid shared locks from subqueries.
I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:

MySQL

update ibreg set k=1 where id in (select id from ibcmp where id > 90000);

1

update ibreg set k=1 where id in (select id from […]

Read more

Percona Live Europe: Tutorials Day

Percona Live Tutorials

Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies.
Today attendees went to training sessions taught by open source database […]

Read more

Updating InnoDB Table Statistics Manually

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?

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 to […]

Read more

MySQL Encryption at Rest – Part 2 (InnoDB)

MySQL Encryption at Rest

Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption.
At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at rest.” As with all […]

Read more

MariaDB Server 10.2 GA Release Overview

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

MySQL Encryption at Rest – Part 1 (LUKS)

MySQL Encryption at Rest

In this first of a series of blog posts, we’ll look at MySQL encryption at rest.
At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at rest.” As with all things open source, there several options […]

Read more

Percona Server for MySQL 5.7.18-15 is Now Available

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

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

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