[HeresJohnny]

MariaDB 10.5 has introduced some important changes, unfortunately some of them seem to be incompatible with KODI. I have seen some PRs that try to mitigate this but at the moment I would advise people to stay with 10.4 if possible.

One of the incompatibilities seems to have to do with compression. If compression is enabled on 10.5, Android and Libre/CoreElec installation will either show an empty library (even though sources and files remain accessible) or show a "0" instead of titles. Compression should be off by default but to be really sure you can put the following line in your my.ini / my.cnf:

Code:

[mysqld]
innodb_compression_default=OFF


I would also recommend to remove compression from advancedsettings.xml if set to "true":

Code:


<videodatabase>
<type>mysql</type>
<compression>false</compression>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<compression>true</compression>
</musicdatabase>


Or simply delete the lines with <compression> as it defaults to "false".

And just FYI, this is how my my.ini looks for 10.5 at this point:

Code:

[mysqld]
datadir=C:/Program Files/MariaDB 10.5/data
port=3306

key_buffer_size=16k
skip_name_resolve=1
query_cache_size=32M
query_cache_limit=2M
optimizer_search_depth=1
character-set-server=utf8
innodb_compression_default=OFF
innodb_log_buffer_size=32M

[client]
port=3306
plugin-dir=C:/Program Files/MariaDB 10.5/lib/plugin