search

monasca / monasca-docker

Docker files and setup for Monasca
Apache License 2.0
24 stars 47 forks source link

Change the value of max_binlog_cache_size #523

Open odunybrad opened 5 years ago

odunybrad commented 5 years ago

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!

witekest commented 5 years ago

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

odunybrad commented 5 years ago

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.