MySQL

Category to track posts in PlanetMySQL

15 Oct 2018

Identifying High Load Spots in MySQL Using Slow Query Log and pt-query-digest

By Uday Varagani Insight for DBAs, MySQL, Percona Toolkit, PMM , , , , 0 Comments
pt-query-digest MySQL slow queries

pt-query-digest is one of the most commonly used tool when it comes to query auditing in MySQL®. By default, pt-query-digest reports the top ten queries consuming the most amount of time inside MySQL. A query that takes more time than the set threshold for completion is considered slow but it’s not always true that tuning […]

Read more
11 Oct 2018

How to Fix ProxySQL Configuration When it Won’t Start

By James Lawrie Insight for DBAs, Insight for Developers, MySQL, ProxySQL 1 Comment
restart ProxySQL config

With the exception of the three configuration variables described here, ProxySQL will only parse the configuration files the first time it is started, or if the proxysql.db file is missing for some other reason.
If we want to change any of this data we need to do so via ProxySQL’s admin interface and then save them […]

Read more
11 Oct 2018

Percona Live 2019 – Save the Date!

By Bronwyn Campbell Events and Announcements, MongoDB, MySQL, Percona Live, PostgreSQL 0 Comments
Austin Texas

After much speculation following the announcement in Santa Clara earlier this year, we are delighted to announce Percona Live 2019 will be taking place in Austin, Texas.
Save the dates in your diary for May, 28-30 2019!
The conference will take place just after Memorial Day at The Hyatt Regency, Austin on the shores of Lady Bird […]

Read more
10 Oct 2018

Percona Monitoring and Management (PMM) 1.15.0 Is Now Available

By Dmitriy Kostiuk Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM 1 Comment
Percona Monitoring and Management

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.

This release offers two new features for both the MySQL Community and Percona Customers:

MySQL […]

Read more
10 Oct 2018

Instrumenting Read Only Transactions in InnoDB

By Przemysław Malkowski InnoDB, Insight for DBAs, MySQL, MySQL 8.0, Performance Schema 0 Comments
Instrumenting read only transactions MySQL

Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction.
Now, as a […]

Read more
09 Oct 2018

Announcement: Second Alpha Build of Percona XtraBackup 8.0 Is Available

By Borys Belinsky Backups, InnoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraBackup 0 Comments
Percona XtraBackup 8.0

The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories.
Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server […]

Read more
08 Oct 2018

Persistence of autoinc fixed in MySQL 8.0

By Fernando Laudares Camargos and Trey Raymond Insight for DBAs, Insight for Developers, MySQL, MySQL 8.0 , , 3 Comments
MySQL 8.0 autoinc persistence fixed

The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions. Another example is the change in how AUTO_INCREMENT (autoinc) sequences are persisted, and thus replicated. (more…)

Read more
04 Oct 2018

The Importance of mysqlbinlog –version

By Ceri Williams Database Recovery, Insight for DBAs, MariaDB, MySQL , , , , 0 Comments
Importance of MySQL binlog version

When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog=ON. (more…)

Read more
04 Oct 2018

Percona Live Europe 2018 Session Programme Published

By Bronwyn Campbell Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Live, Percona Server for MongoDB, Percona Server for MySQL, PostgreSQL 0 Comments
PLE 2018 Full Agenda Announced

Offering over 110 conference sessions across Tuesday, 6 and Wednesday, 7 November, and a full tutorial day on Monday 5 November, we hope you’ll find that this fantastic line up of talks for Percona Live Europe 2018 to be one of our best yet! Innovation in technology continues to arrive at an accelerated rate, […]

Read more
03 Oct 2018

Finding Table Differences on Nullable Columns Using MySQL Generated Columns

By David Ducos Insight for DBAs, Insight for Developers, MySQL, Performance Tuning , 5 Comments
MySQL generated columns

Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an 
IS NULL  comparison over the second table in the WHERE clause, but what if the column could be […]

Read more

Upcoming Webinars

All Webinars »


MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL. Copyright © 2006-2018 Percona LLC.

Terms of Use | Privacy | Copyright | Legal