Buy Percona ServicesBuy Now!

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

Read More

How to Speed Up Pattern Matching Queries

 | March 19, 2018 |  Posted In: Insight for DBAs, MySQL

pattern matching queries

From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]

Read More

Verifying Query Performance Using ProxySQL

 | March 15, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management, ProxySQL

Query Performance Using ProxySQL

In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]

Read More

Binlog Encryption with Percona Server for MySQL

 | March 8, 2018 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Percona Server for MySQL, Security

binlog encryption

In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between servers. They contain all the information from one server so that it can […]

Read More

Percona XtraDB Cluster 5.7.21-29.26 Is Now Available

 | March 2, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.21-29.26 (PXC) on March 2, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.21-29.26 is now the current release, based on the following: Percona Server for MySQL 5.7.21 Galera/Codership WSREP API Release 5.7.21 Galera Replication library 3.23 Starting from now, Percona […]

Read More

Webinar Thursday March 1, 2018: Performance Schema for MySQL Troubleshooting

 | February 28, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Schema, Technical Webinars

Performance Schema for MySQL Troubleshooting

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5, is a really powerful tool. It is actively under development, and each new version provides […]

Read More

Great Metrics Graphs: Percona Monitoring and Management vs. gnuplot

 | February 28, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

Percona Monitoring and Management vs. gnuplot

In this blog post, we’ll checkout Percona Monitoring and Management vs. gnuplot when it comes to creating great metrics graphs. gnuplot is great, but PMM might provide graphs that are easier to read. Percona Monitoring and Management (PMM) is our free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance, and is […]

Read More