Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 6, 2024
Are Your MySQL Users Using ‘password’ or ‘thebossisajerk’ as Passwords?
Are your MySQL users using ‘password’, ‘s3cr3t’, or ‘thebossisajerk’ as their passwords? Easy-to-guess passwords can be disastrous to the security [...]
February 2, 2024
Segmentation Fault – A DBA Perspective
Segmentation fault - A DBA perspective INTRODUCTION On occasions, DBAs come across segmentation fault issues while executing some queries. However, [...]
February 1, 2024
In Search of Transparency at FOSDEM
FOSDEM is for sure one of the most respected free and open source software-focused conferences in Europe, which is loved [...]
February 1, 2024
MySQL vs PostgreSQL: Key Features and Use Cases
This blog was originally published in June of 2023 and updated in February of 2024. For more than a quarter [...]
January 31, 2024
MySQL Table Size Is Way Bigger After Adding a Simple Index; Why?
It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. [...]
January 18, 2024
Syscalls Analysis in MySQL When Using innodb_flush_method and innodb_use_fdatasync
In this blog post, we will discuss how to validate at the operating system level the effects of changing the [...]
January 17, 2024
Quick Peek: MySQL 8.0.36 and 8.3
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what [...]
January 12, 2024
Can’t We Assign a Default Value to the BLOB, TEXT, GEOMETRY, and JSON Data Types?
One of our customers wants to create a table having a column of data type TEXT with the default value, [...]
January 11, 2024
Is MySQL Router 8.2 Any Better?
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in [...]
January 9, 2024
How to Use Group Replication with Haproxy
When working with group replication, MySQL router would be the obvious choice for the connection layer. It is tightly coupled [...]
January 8, 2024
The Underlying Importance of the server_id Parameter
One of the most underlooked parameters to configure MySQL is server_id, which is an integer number to identify a server [...]
January 5, 2024
Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL
The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest [...]
January 4, 2024
MySQL General Tablespaces: A Powerful Storage Option for Your Data
Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This [...]
January 3, 2024
The Various Methods to Backup and Restore ProxySQL
ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the [...]
January 2, 2024
Is Thread Pool Plugin the Right Choice for Your Workload?
TL&DR: Depending on the workload, the thread pool plugin can cause serious performance drops. This post was motivated by two [...]
January 2, 2024
Audit DROP Statements in Percona Server for MySQL
Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal [...]
December 28, 2023
Introducing the MySQL Audit Log Filter Plugin
We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in [...]
December 20, 2023
How to Monitor Online InnoDB Buffer Pool Resizing
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to [...]
December 14, 2023
Can You Trust AI Chatbots When Seeking Help With Databases?
Will 2023 be called the year of Generative Artificial Intelligence (AI)? I don’t know, but certainly, the launching of ChatGPT [...]
December 13, 2023
Exploring MySQL 8 Priority-Based Error Log Filtering
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the [...]