Вход на сайт

Просмотр новости

Найдите то, что Вас интересует

Binary Log Compression is Safe since MySQL 8.0.34

Дата публикации: 26-03-2026 20:41:00

This is a quick one.  My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet :
The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would
Binary Log Compression is Safe since MySQL 8.0.34 appeared first on MariaDB.org


Основное содержимое страницы с новостью.

This is a quick one.  My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet :

The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would exceed 1 GiB.

So Binary Log Transaction Compression is safe since MySQL 8.0.34.  But this also means that it is unsafe before, as also clearly mentioned in Bug #103672 :

It is true that an 8.0.33 server (or older) will produce a corrupted binary log and that replicas may have to recover from backup. It would be better to document this clearly and to advise to not use compression on 8.0.33 and older.

However, even if updating the documentation is mentioned in the above quote, my quick check did not find any reference to the risk of using binlog compression before 8.0.34 (including in the documentation of the global variable binlog_transaction_compression).  I thought this deserved wider knowledge, hence this post.

Схожие новости

#Наименование новостиТональностьИнформативностьДата публикации
1Interesting Binary Logging Optimization in MariaDB04.8726-05-2025
2Notes on Compression in the MySQL Protocol03.8706-11-2023
3MySQL Binlogs:: How to recover05.913-07-2019
4MySQL 8.0.17 GTID Crash Safety Improvement09.2104-08-2026
5Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before)08.2314-04-2026
6Group Commit and Transaction Dependency Tracking012.0321-10-2024
7Do not uselessly grant CREATE and ALTER TABLE09.1120-06-2026
8Still on MySQL 5.7 or 8.0? Those high-severity CVE fixes are covered012.2302-07-2026
9More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate05.425-02-2026
10InnoDB Redo Log Sizing: Stop Guessing, Start Measuring05.8202-05-2026

Классификация: . Схожих патентов: 0. Схожих новостей: 10. Тональность: 0. Информативность: 11.88. Источник: mariadb.org.