In Percona Server for MySQL 8.0.41 / 8.4.4, we significantly re-designed the Data Masking Component. In particular, we made the following changes: Changed the user on behalf of whom we execute internal queries for dictionary operations. Introduced an in-memory dictionary term cache that allows significant speed-up of dictionary operations. Introduced masking_dictionaries_flush() User Defined Function. Introduced […]

If you are testing MySQL with sysbench, here is a RPM version for Fedora 31 and OL 8 & 9 linked with the last libmysql (libmysqlclient.so.24) from MySQL 9.3. This version of sysbench is from the latest master branch in GitHub. I used version 1.1, but this is to make a differentiation with the code […]

This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…

The post MySQL Data Archiving basics – considerations, mistakes, best practices first appeared on Change Is Inevitable.

In Percona Server for MySQL 8.0.41 / 8.4.4, we introduced several improvements in Encryption User-Defined Functions. Added support for RSAES-OAEP (OAEP) padding for RSA encrypt / decrypt operations. Added support for RSASSA-PSS (PSS) padding for RSA sign / verify operations. Added new encryption_udf.legacy_padding_scheme component system variable. Normalized character set support for all Encryption UDFs. PKCS1 […]

Time zones, truncation, formatting nightmares—oh MySQL, why so complex? Learn the key differences between TIMESTAMP and DATETIME, when to use each, and how to prevent time-based bugs in your queries.

The post MySQL Date Format: Understanding Date, Time, and Datetime in MySQL appeared first on Devart Blog.

Most database performance issues don’t start with complex queries or heavy traffic—they begin at the foundation: data type selection. One seemingly small decision—CHAR vs. VARCHAR—can dictate whether your database remains fast and efficient or bloated and sluggish as it scales.  It’s a mistake even experienced developers make, and it’s easy to see why. At a […]

The post Key Differences Between VARCHAR And CHAR in MySQL  appeared first on Devart Blog.

Need MySQL database hosting? Learn how to host a MySQL database on cloud, VPS, or local servers. Compare costs, features, and providers.

The post How to Host MySQL Databases: Best Methods & Hosting Solutions appeared first on Devart Blog.

Learn how to use ENUM in MySQL to store predefined values efficiently. Find syntax, examples, and best practices for the ENUM data type.

The post ENUM Data Type in MySQL: Syntax, Examples and Best Practices appeared first on Devart Blog.

The TIMESTAMPDIFF() function in MySQL calculates differences between two points in time. This article explores TIMESTAMPDIFF(), covering its syntax, everyday use cases, and best practices for real-world applications.

The post MySQL TIMESTAMPDIFF() Function: Syntax, Examples & Use Cases appeared first on Devart Blog.

MySQL HeatWave integrates GenAI capabilities into MySQL on OCI. We have demonstrated how HeatWave GenAI can leverage RAG’s capability to utilize ingested documents (unstructured data) in LakeHouse and generate responses to specific questions or chats. See: The common theme here is the use of data stored in Object Storage (LakeHouse). I previously discussed how to […]