EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 8.0: Descending Indexes Can Speed Up Your Queries

 | October 20, 2016 |  Posted In: MySQL

Descending Indexes

In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release (new optimizer preview), when you create an index you can specify the […]

Read More

A Guide to the Percona Monitoring and Management Demo

 | October 19, 2016 |  Posted In: Database Monitoring, InnoDB, MongoDB, MySQL, Percona Monitoring and Management

Percona Monitoring and Management Demo

As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with some explanation. This post provides some guidance. The PMM demo has a […]

Read More

Upgrading to MySQL 5.7? Beware of the new STRICT mode

 | October 18, 2016 |  Posted In: MySQL


This blog post discusses the ramifications of STRICT mode in MySQL 5.7. In short By default, MySQL 5.7 is much “stricter” than older versions of MySQL. That can make your application fail. To temporarily fix this, change the SQL_MODE to NO_ENGINE_SUBSTITUTION (same as in MySQL 5.6):

MySQL 5.7, dates and default values The default SQL_MODE in MySQL 5.7 […]

Read More

MySQL Downgrade Caveats

 | October 18, 2016 |  Posted In: MySQL

mysql downgrade

In this blog, we’ll discuss things to watch out for during a MySQL downgrade. Previously, I wrote the blog MySQL upgrade best practices. Besides upgrading your MySQL version, sometimes you need to downgrade. When it comes to downgrading MySQL, there are two types of downgrade methods supported: In-Place Downgrade: In this method, you use the existing data […]

Read More

Percona Server 5.6.33-79.0 is now available

 | October 18, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.6.33-79.0

Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug fixes in it, Percona Server 5.6.33-79.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this […]

Read More

Percona Monitoring and Management 1.0.5 is now available

 | October 14, 2016 |  Posted In: Events and Announcements, Percona Monitoring and Management


Percona is glad to announce the release of Percona Monitoring and Management 1.0.5. PMM Server is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are available in the documentation. PMM Server changelog Prometheus 1.1.3 Consul 0.7.0 Added Orchestrator – a MySQL replication topology management […]

Read More

Update the Signing Key for Percona Debian and Ubuntu Packages

 | October 13, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software

signing key for Percona Debian and Ubuntu

In this blog post, we’ll explain how to update the signing key for Percona Debian and Ubuntu packages. Some of the users might have already noticed following warning on Ubuntu 16.04 (Xenial Xerus): W: http://repo.percona.com/apt/dists/xenial/InRelease: Signature by key 430BDF5C56E7C94E848EE60C1C4CBDCDCD2EFD2A uses weak digest algorithm (SHA1) when running apt-get update. Percona .deb packages are signed with a key […]

Read More

MySQL 5.7 Performance Tuning Immediately After Installation

 | October 12, 2016 |  Posted In: InnoDB, MySQL

MySQL 5.7 Performance Tuning

This blog updates Stephane Combaudon’s blog on MySQL performance tuning, and covers MySQL 5.7 performance tuning immediately after installation. A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation that covers the (now) older versions of MySQL: 5.1, 5.5 and 5.6. In this post, I will look […]

Read More

Encrypt your –defaults-file

 | October 12, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit


This blog post will look how to use encryption to secure your database credentials. In the recent blog post Use MySQL Shell Securely from Bash, there are some good examples of how you might avoid using a ~/.my.cnf – but you still need to put that password down on disk in the script. MySQL 5.6.6 and later introduced […]

Read More

Using the loose_ option prefix in my.cnf

 | October 11, 2016 |  Posted In: MySQL

loose_ option

In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example:

The MySQL manual has a solution: use the loose_ prefix option in my.cnf file. In the prior example, if we specify loose_bogus_option=1 […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.