Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
HI,
Looks log_bin_compress is not working at all on MariaDB-server-10.11.14-1.el9.x86_64:
log_bin_compress_min_len=256 (default)
Is it feature or a bug?
I purged all bin logs almost at the same time on both servers only one has log_bin_compress=1 other one log_bin_compress=0 nad checked after ~12 hours:
|
|
[root@server02 mysql]# ls -ltr mariadb-bin.2196* | wc -l |
36
|
[root@server02 mysql]# |
[root@server01 mysql]# ls -ltr mariadb-bin.2196* | wc -l |
36
|
|
|
[root@server02 mysql]# |
MariaDB ******** SLAVE ******** READ ONLY ******** [(none)]> select @@log_bin_compress; |
+--------------------+
|
| @@log_bin_compress | |
+--------------------+
|
| 1 | |
+--------------------+
|
1 row in set (0.000 sec) |
|
|
[root@server01 mysql]# |
MariaDB ******** SLAVE ******** READ ONLY ******** [(none)]> select @@log_bin_compress; |
+--------------------+
|
| @@log_bin_compress | |
+--------------------+
|
| 0 | |
+--------------------+
|
1 row in set (0.000 sec) |
|
|
|
|
[root@server02 mysql]# du -sh mariadb-bin.219665* |
1.1G mariadb-bin.219665 |
[root@server02 mysql]# mysqlbinlog mariadb-bin.219665 > mariadb-bin.219665.txt |
1.1G mariadb-bin.219665.txt |
[root@server02 mysql]# gzip mariadb-bin.219665 |
149M mariadb-bin.219665.gz |
[root@server02 ~]# mysqlbinlog --base64-output=AUTO --verbose mariadb-bin.219665 > mariadb-bin.219665.txt |
1.2G mariadb-bin.219665.txt |
|
|
|
|
server02 37.783.624 kb |
server01 38.054.076 kb |