Wed, 08 May 2024 14:19:49 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/mysql-downgrade-caveats/ https://www.percona.com/blog/mysql-downgrade-caveats/#comments Tue, 18 Oct 2016 20:02:47 +0000 https://www.percona.com/blog/?p=37935 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 directory […]]]> https://www.percona.com/blog/mysql-downgrade-caveats/feed/ 1 37935 https://www.percona.com/blog/pmp-check-pt-table-checksum-percona-monitoring-plugin/ Wed, 14 Sep 2016 20:52:55 +0000 https://www.percona.com/blog/?p=37765 Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost.[crayon-664c76f0ac377657723064-i/] alerts you when the pt-table-checksum tool from Percona Toolkit finds data drifts on a replication slave. [crayon-664c76f0ac37d594327951-i/] monitors data differences on the slave from the […]]]> 37765 https://www.percona.com/blog/top-overlooked-mysql-performance-optimizations-q/ https://www.percona.com/blog/top-overlooked-mysql-performance-optimizations-q/#comments Fri, 19 Aug 2016 23:34:01 +0000 https://www.percona.com/blog/?p=37027 Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations“. In this blog, I will provide answers to the Q & A for that webinar.For hardware, which disk raid level do you suggest? Is raid5 suggested performance-wise and data-integrity-wise? RAID 5 comes with high overhead, as each write turns […]]]> https://www.percona.com/blog/top-overlooked-mysql-performance-optimizations-q/feed/ 4 37027 https://www.percona.com/blog/mysql-got-an-error-reading-communication-packet-errors/ https://www.percona.com/blog/mysql-got-an-error-reading-communication-packet-errors/#comments Mon, 16 May 2016 16:32:28 +0000 https://www.percona.com/blog/?p=34827 In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors and how to address them.In Percona’s managed services, we often receive customer questions on communication failure errors. So let’s discuss possible reasons for this error and how to remedy it.Try Now: Get MySQL Database Management Services with […]]]> https://www.percona.com/blog/mysql-got-an-error-reading-communication-packet-errors/feed/ 9 34827 https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-pt-table-sync-part-2/ https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-pt-table-sync-part-2/#comments Thu, 17 Mar 2016 21:20:49 +0000 https://www.percona.com/blog/?p=33196 This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication.In the first post, I showed you how to use the [crayon-664c76f0ae0ae228253114-i/]  / [crayon-664c76f0ae0b4693584236-i/]  tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to use […]]]> https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-pt-table-sync-part-2/feed/ 3 33196 https://www.percona.com/blog/mysql-5-7-change-replication-filter-online/ https://www.percona.com/blog/mysql-5-7-change-replication-filter-online/#comments Thu, 05 Nov 2015 01:16:17 +0000 https://www.percona.com/blog/?p=32023 MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post.Adding replication filters online is one of the MySQL 5.7 features described in this manual. However, I will describe and summarize a few examples in this blog post.Filtering replication events is also known as Partial Replication. Partial replication […]]]> https://www.percona.com/blog/mysql-5-7-change-replication-filter-online/feed/ 4 32023 https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/ https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/#comments Wed, 12 Aug 2015 07:00:07 +0000 https://www.percona.com/blog/?p=30812 https://www.percona.com/blog/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/feed/ 14 30812 https://www.percona.com/blog/mysql-5-7-key-features/ https://www.percona.com/blog/mysql-5-7-key-features/#comments Wed, 27 May 2015 07:00:52 +0000 https://www.percona.com/blog/?p=29873 https://www.percona.com/blog/mysql-5-7-key-features/feed/ 11 29873 https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/ https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/#comments Mon, 16 Mar 2015 07:00:55 +0000 https://www.percona.com/blog/?p=28813 https://www.percona.com/blog/deep-dive-mysqls-innochecksum-tool/feed/ 5 28813 https://www.percona.com/blog/3-handy-tools-to-remove-problematic-mysql-processes/ https://www.percona.com/blog/3-handy-tools-to-remove-problematic-mysql-processes/#comments Fri, 27 Feb 2015 08:00:54 +0000 https://www.percona.com/blog/?p=28148 https://www.percona.com/blog/3-handy-tools-to-remove-problematic-mysql-processes/feed/ 3 28148 https://www.percona.com/blog/mysql-5-6-transportable-tablespaces-best-practices/ https://www.percona.com/blog/mysql-5-6-transportable-tablespaces-best-practices/#comments Tue, 09 Dec 2014 08:00:08 +0000 https://www.percona.com/blog/?p=26091 https://www.percona.com/blog/mysql-5-6-transportable-tablespaces-best-practices/feed/ 5 26091 https://www.percona.com/blog/mysql-replication-got-fatal-error-1236-causes-and-cures/ https://www.percona.com/blog/mysql-replication-got-fatal-error-1236-causes-and-cures/#comments Wed, 08 Oct 2014 07:00:10 +0000 https://www.percona.com/blog/?p=25864 MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue […]]]> https://www.percona.com/blog/mysql-replication-got-fatal-error-1236-causes-and-cures/feed/ 9 25864 https://www.percona.com/blog/mysql-upgrade-best-practices/ Fri, 19 Sep 2014 17:06:27 +0000 https://www.percona.com/blog/?p=25659 MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights the recommended ways to upgrade MySQL in different scenarios.Why are MySQL upgrades needed? The reasons are many and include Access to new features, performance benefits, bug fixes… However, MySQL upgrades can […]]]> 25659 https://www.percona.com/blog/mysql-101-monitor-disk-io-with-pt-diskstats/ https://www.percona.com/blog/mysql-101-monitor-disk-io-with-pt-diskstats/#comments Thu, 04 Sep 2014 07:00:12 +0000 https://www.percona.com/blog/?p=24955 https://www.percona.com/blog/mysql-101-monitor-disk-io-with-pt-diskstats/feed/ 6 24955 https://www.percona.com/blog/how-to-identify-and-cure-mysql-replication-slave-lag/ https://www.percona.com/blog/how-to-identify-and-cure-mysql-replication-slave-lag/#comments Fri, 02 May 2014 07:00:33 +0000 https://www.percona.com/blog/?p=22367 Here on the Percona MySQL Support team, we often see issues where a customer is complaining about replication delays – and many times the problem ends up being tied to MySQL replication slave lag. This, of course, is nothing new for MySQL users and we’ve had a few posts here on the MySQL Performance Blog […]]]> https://www.percona.com/blog/how-to-identify-and-cure-mysql-replication-slave-lag/feed/ 15 22367 https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/ https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/#comments Fri, 14 Mar 2014 15:00:16 +0000 https://www.percona.com/blog/?p=20408 MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute. Peter Zaitsev first wrote about this back in 2006 – there have been a few other posts here on the MySQL Performance Blog since then (check this and this, too) […]]]> https://www.percona.com/blog/mysql-slow-query-log-tools-and-tips/feed/ 6 20408 https://www.percona.com/blog/error-mysqld-sort-aborted-server-shutdown-in-progress/ https://www.percona.com/blog/error-mysqld-sort-aborted-server-shutdown-in-progress/#comments Mon, 30 Dec 2013 08:01:06 +0000 https://www.percona.com/blog/?p=19736 https://www.percona.com/blog/error-mysqld-sort-aborted-server-shutdown-in-progress/feed/ 3 19736 https://www.percona.com/blog/mysql-error-too-many-connections/ https://www.percona.com/blog/mysql-error-too-many-connections/#comments Thu, 28 Nov 2013 08:01:41 +0000 https://www.percona.com/blog/?p=19179 Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation.We have always received quite a few questions here at Percona Support on how to avoid the dreaded “Too many connections” error, as well as what is the recommended value for max_connections. So, in this article, I will try to cover the […]]]> https://www.percona.com/blog/mysql-error-too-many-connections/feed/ 13 19179 https://www.percona.com/blog/innodb-performance-optimization-basics-updated/ https://www.percona.com/blog/innodb-performance-optimization-basics-updated/#comments Fri, 20 Sep 2013 05:00:22 +0000 https://www.percona.com/blog/?p=17856 I recently stumbled upon a post that Peter Zaitsev published back in 2007 titled “Innodb Performance Optimization Basics.” It’s a great post and reading it inspired me to examine what’s changed in the nearly six years that have followed in terms of MySQL, Percona Server – as well as in all of the other now-available […]]]> https://www.percona.com/blog/innodb-performance-optimization-basics-updated/feed/ 9 17856 https://www.percona.com/blog/crash-resistant-replication-how-to-avoid-mysql-replication-errors/ https://www.percona.com/blog/crash-resistant-replication-how-to-avoid-mysql-replication-errors/#comments Mon, 15 Jul 2013 10:00:48 +0000 https://www.percona.com/blog/?p=16403 https://www.percona.com/blog/crash-resistant-replication-how-to-avoid-mysql-replication-errors/feed/ 6 16403