+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: v20 Library scan is taking really longtime (/showthread.php?tid=373540)
Library scan is taking really longtime - sufreak - 2023-06-20
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.
RE: Library scan is taking really longtime - izprtxqkft - 2023-06-20
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
RE: Library scan is taking really longtime - Klojum - 2023-06-20
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.
RE: Library scan is taking really longtime - sufreak - 2023-06-20
(2023-06-20, 21:36)Klojum Wrote: 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
RE: Library scan is taking really longtime - izprtxqkft - 2023-06-20
(2023-06-20, 21:36)Klojum Wrote: 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
RE: Library scan is taking really longtime - Klojum - 2023-06-20
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.
RE: Library scan is taking really longtime - izprtxqkft - 2023-06-20
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