EmergencyEMERGENCY? Get 24/7 Help Now!

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

MySQL 8.0: The end of MyISAM

 | October 11, 2016 |  Posted In: MySQL

Descending Indexes

This blog discusses the gradual end of MyISAM in MySQL. The story that started 20 years ago is coming to its end. I’m talking about the old MyISAM storage engine that was the only storage provided by MySQL in 1995, and was available in MySQL for 20+ years. Actually, part of my job as a MySQL consultant […]

Read More

Take Percona’s One-Click 2017 Top Database Concerns Poll

 | October 10, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Database Monitoring, High-availability, MariaDB, MongoDB, MySQL

2017 top database concerns

Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]

Read More

Percona Database Security Poll Results

 | October 10, 2016 |  Posted In: MySQL

This blog reports the results of Percona’s database security poll. As Peter Zaitsev mentioned recently in his blog post on database support, the data breach costs can hit both your business reputation and your bottom line. Costs vary depending on the company size and market, but recent studies estimate direct costs ranging in average from $1.6M to 7.01M. […]

Read More

Consul Architecture

 | October 10, 2016 |  Posted In: MySQL, Percona XtraDB Cluster


In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

Read More

Why Percona didn’t participate in the 2016 Gartner Operational DBMS MQ

 | October 7, 2016 |  Posted In: Events and Announcements, MongoDB, MySQL

gartner operational dbms mq

Around this time last year, Gartner named Percona a Challenger in the 2015 Magic Quadrant for Operational Database Management Systems (Gartner Operational DBMS MQ). For those not familiar with these, Magic Quadrants (MQ) are a set of market research reports published by Gartner that provide qualitative analysis into a market by highlighting its participants, relevant trends, […]

Read More

From Percona Live Europe 2016: Thank You, Attendees!

 | October 7, 2016 |  Posted In: MySQL

From everyone at Percona, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s Percona Live Europe Open Source Database Conference. The conference was an outstanding success! The sold-out event brought the European open source database community together, with a technical emphasis on the core topics of MySQL, […]

Read More

Use MySQL Shell Securely from Bash

 | October 6, 2016 |  Posted In: MySQL

mysql shell

This blog post discusses how to use MySQL shell securely from Bash. The Bourne shell is everywhere. It is part of the most basic Linux install. You will find it on the biggest SPARC machines down to a Raspberry Pi. It is nice to know it will always be there. Unlike other, more complex scripting […]

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.