by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, MySQL, Storage Engine
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...
by Jaime Sicam | Mar 26, 2018 | Insight for DBAs, MySQL, Percona Software
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...
by Tibor Korocz | Mar 19, 2018 | Insight for DBAs, MySQL
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....
by Tibor Korocz | Mar 15, 2018 | Monitoring, MySQL, Percona Software, 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...
by Sveta Smirnova | Mar 14, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Basic Internal Troubleshooting Tools for MySQL Server webinar. First, I want to thank everybody for attending my February 15, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for...
by Robert Golebiowski | Mar 8, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Security
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...
by Dmitriy Kostiuk | Mar 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
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...
by Tate McDaniel | Mar 1, 2018 | Monitoring, MySQL, Percona Software
by Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
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,...
by Tibor Korocz | Feb 28, 2018 | Monitoring, MySQL, Percona Software
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...
by Peter Zaitsev | Feb 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse. For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the...
by Borys Belinsky | Feb 27, 2018 | MySQL, Percona Events, Percona Software
The latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. Percona Monitoring and Management is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own...
by Tibor Korocz | Feb 27, 2018 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I’ll look at how to catch slow and frequent queries with ProxySQL. More and more people are using ProxySQL because it is a great tool and it can help DBAs a lot. But many people do not realize that it is more powerful than it looks. It has...
by Marcelo Altmann | Feb 26, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog...
by Dmitriy Kostiuk | Feb 26, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.39-26.25 is now the current release, based on the following:...
by Mykola Marzhan | Feb 23, 2018 | Cloud, MariaDB, Monitoring, MySQL, Percona Software
Please join Percona’s Build / Release Engineer, Mykola Marzhan, as he presents Monitoring Amazon RDS with Percona Monitoring and Management on February 27, 2018, at 7:00 am PST (UTC-8) / 10:00 am EST (UTC-5). Register Now Are you concerned about how you are monitoring...
by Dave Avery | Feb 22, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog...
by Dave Avery | Feb 21, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live
The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be...
by Alexander Rubin | Feb 19, 2018 | Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics. Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few...
by Jervin Real | Feb 16, 2018 | MySQL
In this blog post, we’ll look at how ZFS affects MySQL performance when used in conjunction. ZFS and MySQL have a lot in common since they are both transactional software. Both have properties that, by default, favors consistency over performance. By doubling...