2018-02-16, 12:13
https://dev.mysql.com/doc/refman/5.7/en/...cache.html
Deprecated in 5.7.20, removed in 8.0, but users tend to upgrade their backend servers very slowly so MySQL Server versions with query cache could be around for quite a while and would suddenly start breaking with MariaDB Connector when users upgrade to LE 9.0.
Disabling per-connection (
Thanks @HeresJohnny for reporting this.
Deprecated in 5.7.20, removed in 8.0, but users tend to upgrade their backend servers very slowly so MySQL Server versions with query cache could be around for quite a while and would suddenly start breaking with MariaDB Connector when users upgrade to LE 9.0.
Disabling per-connection (
SET SESSION query_cache_type = OFF;
) would help reduce support overhead (but might require an LE specific patch to Kodi, unless it can be conditional when building with MariaDB client?) Or we just ask users to disable query cache in the Server config, but that might affect other applications using the same server.Thanks @HeresJohnny for reporting this.