Change the value of max_binlog_cache_size

Open odunybrad opened this issue 6 years ago • 2 comments

Thanks for providing this useful container.

I am doing a research aiming at finding issues in configuration files. I have a question about one MySQL config: max_binlog_cache_size. It seems the official document says "The maximum recommended value is 4GB; this is due to the fact that MySQL currently cannot work with binary log positions greater than 4GB."

However, the default value is 18446744073709551615, which is much larger than the recommended value.

Shall we change the value to 4GB? Thanks!

Aug 05 '19 03:08 odunybrad

Sounds sensible but shouldn't the upstream default be updated in the first place?

Aug 05 '19 10:08 witekest

Yes, I agree. They actually have acknowledged the bug but haven't fixed it https://bugs.mysql.com/bug.php?id=94487. Maybe it takes a long time for the official to make even a small change.

Aug 14 '19 23:08 odunybrad