[sufreak]

I decided to rebuild my library from scratch, upgrading from Kodi 17 to 20. I also moved over to MariaDB on Synology.  It takes 10-30 second at times to scan in a single file. (if not longer)

Kodi Debug log: https://paste.kodi.tv/fuyuruzako.kodi

My Syno 920 has 8 GB of RAM and the following settings in /var/packages/MariaDB10/etc/my.cnf

Code:


[mysqld]
skip-networking=0
skip-bind-address
skip-name-resolve=1
optimizer_search_depth=0
innodb_buffer_pool_chunk_size=1G
innodb_buffer_pool_instances=4
innodb_adaptive_hash_index=OFF
innodb_buffer_pool_dump_at_shutdown=ON
innodb_buffer_pool_load_at_startup=ON
character_set_server=utf8
aria_pagecache_buffer_size=1G


My previous updates on a old linux host were REALLY fast. Or I guess, normal speed.

[izprtxqkft]

i see a 2-5 second delay every time "Mysql Start transaction" appears, looks like slow mariadb server

MYSQL: Connected to version 10.3.32-MariaDB - this is an unmaintained version of mariadb, looks like latest version is 11.3 - https://mariadb.com/kb/en/mariadb-server-release-dates

[Klojum]

Synology has its own pace of upgrading the tools in its DSM software. I wouldn't call it unmaintained.

I prefer to run Kodi's database (MySQL, not MariaDB) on a SSD using a separate Ubuntu Server pc. All videos go via the Syno NAS of course.

[sufreak]

Synology has its own pace of upgrading the tools in its DSM software. I wouldn't call it unmaintained.

I prefer to run Kodi's database (MySQL, not MariaDB) on a SSD using a separate Ubuntu Server pc. All videos go via the Syno NAS of course.

That's why my previous set up. I was hoping to consolidate a bit, but I guess not. Back to linux I go

[izprtxqkft]

Synology has its own pace of upgrading the tools in its DSM software. I wouldn't call it unmaintained.

I prefer to run Kodi's database (MySQL, not MariaDB) on a SSD using a separate Ubuntu Server pc. All videos go via the Syno NAS of course.

good to know, i just read it was unmaintained on that page i linked, must be maintained by synology then

[Klojum]

To be clear, "their own pace of upgrading the tools in its DSM software" does not mean the MariaDB server is slow by default. It's still possible that certain settings or cache sizes are 'insufficient' when handling the Kodi database.

OTOH, once you go for a database on a SSD, you'll see some difference.

[izprtxqkft]

also to be clear, i have no evidence that it is due to an old version i just dont want to waste any time trying to fix an old version when there is potential it will already be fixed in a newer version