by Mani Paluru | Apr 4, 2023 | Insight for DBAs, MySQL
In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. What is the user attribute? A user attribute is a JSON object made up of one or more key-value pairs, and it is set while creating the user with CREATE USER and by including ATTRIBUTE...
by David Stokes | Apr 4, 2023 | Insight for DBAs, Insight for Developers, MySQL
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting short. The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new...
by Pete Scott | Mar 30, 2023 | Insight for DBAs
The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. This comprehensive...
by Smit Arora | Mar 29, 2023 | Insight for DBAs, MySQL
A partitioned table in MySQL has its data separated into different tablespaces while still being viewed as a single table. Partitioning can be a useful approach in some cases when handling huge sets of data. Deleting huge data sets could be quickened up in a...
by Carlos Tutte | Mar 27, 2023 | Insight for DBAs, MySQL, Percona Software
On MySQL and Percona Server for MySQL, there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. A lot of useful information can be retrieved from this schema, for example, table metadata and foreign...
by Yura Sorokin | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
In MySQL Server 8.0.32, Oracle fixed Bug #105761: “mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit) which caused a wave of complaints from users who could no longer do backups with the mysqldump utility because of the lack of the...
by Denis Subbota | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article discusses the need for using binlog compression and the potential issues it may cause. Binlog compression is a technique used to reduce the size...
by Gaurav Pareek | Mar 21, 2023 | Insight for DBAs, MySQL, Security
In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking...
by Puneet Kala | Mar 17, 2023 | Insight for DBAs, Monitoring, MySQL, Percona Software
2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and Backup Management. These updates are designed to keep databases running at peak performance and simplify database operations. But as...
by Daniel Guzmán Burgos | Mar 16, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS). If not, go and...
by Larry Xia | Mar 13, 2023 | Insight for DBAs, MySQL, Percona Software
When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 replica. This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server...
by Michael Villegas | Mar 8, 2023 | Insight for DBAs, Insight for Developers, MySQL
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One of the most common problems I faced is the one related to the well-known error “ERROR 1040 (08004): Too many connections”. A lot has been written about this error. Still, the...
by Mauricio Cacho | Mar 6, 2023 | Insight for DBAs, MySQL
MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is? We will walk through how to figure that out in this blog. We already have a couple of posts related to this...
by Uday Varagani | Mar 3, 2023 | Insight for DBAs, MySQL, Percona Software
This post was originally published in October 2018 and was updated in March 2023. pt-query-digest is one of the most commonly used tools for query auditing in MySQL. By default, pt-query-digest reports the top ten queries consuming the most amount of time inside...
by Fernando Mattera | Mar 3, 2023 | Insight for DBAs, MySQL, Percona Software
Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer. A few days ago, a client asked us the following question:...
by Sergey Pronin | Mar 1, 2023 | Cloud, MySQL, Percona Software
Public cloud spending is slowing down. Quarter-over-quarter growth is no longer hitting 30% gains for AWS, Google, and Microsoft. This is businesses’ response to tough and uncertain macroeconomic conditions, where organizations scrutinize their public cloud...
by David Stokes | Mar 1, 2023 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 5.7 has had a good, long run, but the official End of Life is October of 2023. The Era of MySQL 5.x will be over, and only MySQL 8.0 will be officially supported. Yup, six months away. So if you are running MySQL, you need to consider upgrading to...
by Dmitry Lenev | Feb 20, 2023 | MySQL, Percona Software, Security
Introduction/TLDR: We are considering changing EXPLAIN in Percona Server for MySQL to require less privileges for providing execution plans for INSERT/UPDATE/DELETE statements (and possibly changing the behavior for EXPLAIN SELECT as well), to make it more convenient...
by Edwin Wang | Feb 16, 2023 | Database Trends, Insight for DBAs, MySQL
ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview. I wondered, does that mean ChatGPT is ready to replace MySQL DBAs, too? No. Let me show you why. Recently, one of our clients...
by Vadim Tkachenko | Feb 15, 2023 | MySQL, Percona Software
Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL (Percona Server for MySQL: Automatic Cloud Deployment With Terraform) and Percona Monitoring and Management (Deploying Percona Monitoring and Management (PMM) With Terraform). Now we...
