Showing entries 11 to 20 of 22212
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: MySQL (reset)
An Efficient Path to Learning MySQL Performance
Conference Video Slides
MySQL Performance for Application Developers @ MySQL and HeatWave Summit 2025† mysql-summit-2025.pdf
MySQL Performance for Developers @ Percona Live 2023† PL23.pdf
Efficient MySQL Performance @ Percona Live 2022 PL22.pdf
Efficient MySQL Performance @ FOSDEM 2022
[Read more]
What’s New in MySQL 8.4 LTS: Key Enhancements Explained

MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become deprecated/removed. This blog provides a comprehensive, side-by-side comparison of the key differences […]

Percona Server for MySQL Data Masking Enhanced with Dictionary Term Cache

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 […]

sysbench linked to latest libmysql (from MySQL 9.3)

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 […]

MySQL Data Archiving basics – considerations, mistakes, best practices

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.

Percona Server for MySQL: Enhanced Encryption UDFs

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 […]

MySQL Date Format: Understanding Date, Time, and Datetime in MySQL

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.

Key Differences Between VARCHAR And CHAR in MySQL 

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.

How to Host MySQL Databases: Best Methods & Hosting Solutions

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.

ENUM Data Type in MySQL: Syntax, Examples and Best Practices

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.

Showing entries 11 to 20 of 22212
« 10 Newer Entries | 10 Older Entries »