Mon, 29 Apr 2024 15:52:36 +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/easily-validate-configuration-settings-in-mysql-8/ https://www.percona.com/blog/easily-validate-configuration-settings-in-mysql-8/#comments Mon, 01 Apr 2024 11:54:23 +0000 https://www.percona.com/blog/?p=75088 This blog was published in April of 2021 and updated in April of 2024.In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In some cases a few deprecated options might no longer be supported […]]]> https://www.percona.com/blog/easily-validate-configuration-settings-in-mysql-8/feed/ 1 75088 https://www.percona.com/blog/transparent-huge-pages-refresher/ https://www.percona.com/blog/transparent-huge-pages-refresher/#respond Tue, 03 Oct 2023 12:16:00 +0000 https://www.percona.com/blog/?p=89488 Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for […]]]> https://www.percona.com/blog/transparent-huge-pages-refresher/feed/ 0 89488 https://www.percona.com/blog/mysql-101-parameters-to-tune-for-mysql-performance/ https://www.percona.com/blog/mysql-101-parameters-to-tune-for-mysql-performance/#comments Fri, 01 Sep 2023 11:00:55 +0000 https://www.percona.com/blog/?p=69345 This post was originally published in June 2020 and was updated in September 2023.While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the […]]]> https://www.percona.com/blog/mysql-101-parameters-to-tune-for-mysql-performance/feed/ 3 69345 https://www.percona.com/blog/upgrading-to-mysql-8-tools-that-can-help/ https://www.percona.com/blog/upgrading-to-mysql-8-tools-that-can-help/#respond Thu, 20 Apr 2023 14:46:39 +0000 https://www.percona.com/blog/?p=86372 As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to MySQL 8. Such major version upgrades are rarely simple, but thankfully there are tools that can help smooth the process and ensure a successful upgrade.It should be noted that while the technical aspects of the […]]]> https://www.percona.com/blog/upgrading-to-mysql-8-tools-that-can-help/feed/ 0 86372 https://www.percona.com/blog/is-your-database-ready-for-black-friday/ https://www.percona.com/blog/is-your-database-ready-for-black-friday/#respond Fri, 18 Nov 2022 14:00:31 +0000 https://www.percona.com/blog/?p=83697 With the holiday season approaching quickly, it’s an opportune time to discuss preparation for the busiest shopping season of the year, especially the typical surge of high traffic on Black Friday. Many businesses find themselves caught off guard by high holiday traffic, leading to a sluggish client experience at best, or production downtime at worst. […]]]> https://www.percona.com/blog/is-your-database-ready-for-black-friday/feed/ 0 83697 https://www.percona.com/blog/mysql-8-multi-factor-authentication-overview/ https://www.percona.com/blog/mysql-8-multi-factor-authentication-overview/#respond Wed, 23 Mar 2022 12:09:39 +0000 https://www.percona.com/blog/?p=79314 As part of my ongoing series around MySQL 8 user administration, I’d like to cover one of the new features introduced in MySQL 8.0.27 – multi-factor authentication. In order to establish identity, multi-factor authentication (MFA) is the use of multiple authentication values (factors) during the MySQL authentication process.IntroductionMFA provides greater security compared to a single-factor […]]]> https://www.percona.com/blog/mysql-8-multi-factor-authentication-overview/feed/ 0 79314 https://www.percona.com/blog/mysql-8-password-verification-policy/ https://www.percona.com/blog/mysql-8-password-verification-policy/#respond Tue, 22 Mar 2022 13:31:37 +0000 https://www.percona.com/blog/?p=79319 In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced.IntroductionThe password verification-required policy enables DBAs to […]]]> https://www.percona.com/blog/mysql-8-password-verification-policy/feed/ 0 79319 https://www.percona.com/blog/mysql-8-random-password-generator/ https://www.percona.com/blog/mysql-8-random-password-generator/#respond Fri, 08 Oct 2021 11:45:03 +0000 https://www.percona.com/blog/?p=78372 As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking features can enable the locking of an account with too many failed password […]]]> https://www.percona.com/blog/mysql-8-random-password-generator/feed/ 0 78372 https://www.percona.com/blog/mysql-8-account-locking/ https://www.percona.com/blog/mysql-8-account-locking/#respond Tue, 05 Oct 2021 14:32:12 +0000 https://www.percona.com/blog/?p=78370 As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password management in MySQL 8; one of the more security-focused changes was […]]]> https://www.percona.com/blog/mysql-8-account-locking/feed/ 0 78370 https://www.percona.com/blog/mysql-shell-101-system-log/ https://www.percona.com/blog/mysql-shell-101-system-log/#respond Mon, 05 Jul 2021 13:29:58 +0000 https://www.percona.com/blog/?p=77025 One of the new features introduced in MySQL 8.0.24 was the ability to log all SQL statements that are issued in the MySQL Shell to the system log. This is a useful feature that can greatly assist in tracking who did what on the system. UsageThe simplest way to utilize the new Shell logging feature […]]]> https://www.percona.com/blog/mysql-shell-101-system-log/feed/ 0 77025 https://www.percona.com/blog/using-mysql-8-dual-passwords/ https://www.percona.com/blog/using-mysql-8-dual-passwords/#comments Thu, 01 Jul 2021 15:17:38 +0000 https://www.percona.com/blog/?p=77006 MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, and better SQL support, just to name a few. There are lesser-known new features, however, that aim to reduce overall DBA workload and streamline management processes – and one of these is support for dual […]]]> https://www.percona.com/blog/using-mysql-8-dual-passwords/feed/ 1 77006 https://www.percona.com/blog/mysql-101-using-super_read_only/ https://www.percona.com/blog/mysql-101-using-super_read_only/#comments Wed, 31 Mar 2021 14:50:06 +0000 https://www.percona.com/blog/?p=75071 As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based on work done by WebScaleSQL. This feature eventually found its way into the Community branch of MySQL starting with 5.7.8, and it works the same in both cases. While this is now old news, over […]]]> https://www.percona.com/blog/mysql-101-using-super_read_only/feed/ 1 75071 https://www.percona.com/blog/tam-enterprise-experiences-data-encryption/ Thu, 07 Jan 2021 17:53:43 +0000 https://www.percona.com/blog/?p=73277 In previous TAM Enterprise Experiences posts, we have outlined typical aspects of utilizing MySQL in an Enterprise environment. One thing we have not yet covered is the topic of database encryption, both from the standpoint of business requirements as well as some of the more technical aspects of encryption.In this post, we will cover: Common […]]]> 73277 https://www.percona.com/blog/tam-enterprise-experiences-troubleshooting-methodology/ Tue, 05 Jan 2021 16:09:47 +0000 https://www.percona.com/blog/?p=73329 One of the great things about being a Technical Account Manager (TAM, for short) at Percona is having the opportunity to see a wide variety of issues across many clients, and having the space to identify the common threads that seem to bind many of these issues. While the challenges vary as widely as the […]]]> 73329 https://www.percona.com/blog/are-you-the-next-great-percona-tam/ Mon, 29 Jun 2020 14:52:41 +0000 https://www.percona.com/blog/?p=69348 In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully embraced open source. This small company quickly grew, riding the wave of open source adoption within the greater enterprise market and became the Percona we know and love today.My first awareness of Percona came at […]]]> 69348 https://www.percona.com/blog/tips-for-mysql-5-7-database-tuning-and-performance/ Wed, 01 Apr 2020 16:30:51 +0000 https://www.percona.com/blog/?p=66405 While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings […]]]> 66405 https://www.percona.com/blog/what-is-a-tam-technical-account-manager-and-does-your-database-need-one/ Fri, 27 Mar 2020 16:19:10 +0000 https://www.percona.com/blog/?p=66051 This is usually one of the first questions asked by clients when discussing the possibility of adding a TAM (Technical Account Manager) to their Percona Support contract. Although the TAM role in a general sense has been around for many years, there are often misconceptions and confusion on what exactly a TAM is, and how […]]]> 66051 https://www.percona.com/blog/the-benefits-of-amazon-rds-for-mysql/ Thu, 19 Dec 2019 15:52:18 +0000 https://www.percona.com/blog/?p=63970 As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS.Amazon RDS allows you to deploy scalable MySQL servers within […]]]> 63970