Percona's MySQL & InnoDB performance and scalability blog
91k followers 8 článkov/týždeň
MySQL 9.0 Includes a New Option for Explaining Queries

MySQL 9.0 is an Innovation Release, but as you may have read in my Quick Peek, I found little innovation. However, one new item caught my eye, and it could be a way to track query performance. MySQL 9.0 EXPLAIN enhancement Here is the syntax that will be referenced in the post. {EXPLAIN | DESCRIBE […]

Fri Jul 19, 2024 19:14
How to Monitor Valkey/Redis with Percona Monitoring and Management

In this blog post, we will show you how to add external exporters to Percona Monitoring and Management (PMM) and monitor various services. Our focus will be on Valkey/Redis, but the principles apply to other technologies as well. PMM uses VictoriaMetrics, which is compatible with Prometheus. Prometheus has numerous exporters that you can use.  When...

Fri Jul 19, 2024 15:44
How to Have a Single MySQL User Account From Specific Hosts

In this article, we will demonstrate how to have a single MySQL database user account that can connect from specific hosts. We would usually implement it by creating separate user accounts with the same username but different hosts/IPs like <USER>@<HOST1>, <USER>@<HOST2> …. <USER>@<HOSTn>. Then, give those users the...

Thu Jul 18, 2024 15:57
Using Compact in Percona Server for MongoDB From Version 4.4+

In the previously posted blog, Compaction in Percona Server for MongoDB (PSMDB), we discussed how compact works before version 4.4. In this blog, we will see how compact works on PSMDB 6.0. I recommend reading the blog post linked above to understand what compact does, how to check dataSize, and how much space we can […]

Wed Jul 17, 2024 18:27
Ultimate Guide to Improving MySQL Query Performance

MySQL is certainly a powerful open source database management system, but even the most robust engine struggles when queries take an eternity to execute. For DBAs and developers, improving MySQL query performance is an ongoing goal. Efficient query performance is crucial for ensuring the smooth operation and optimal user experience of applications powered...

Wed Jul 17, 2024 14:57
No MySQL 9.x Innovation Releases from Percona

On July 1st, 2024, Oracle launched MySQL 9.0.0, the first release in the 9.x series. This release and the following six versions (9.1.0 to 9.6.0) are designated as “Innovation Releases.” These releases are characterized by their short support lifecycles, lasting only one quarter, and their focus is on introducing new features and innovations, which...

Tue Jul 16, 2024 16:36

Vytvorte si vlastný informačný kanál

Ste pripravení to vyskúšať?
Začnite 14-dňovú skúšobnú verziu, kreditná karta sa nevyžaduje.

Založiť účet