Got it: Using and tuning MariaDB as your central database
Can you confirm? I only has dummy library created by copy/paste few tv shows I'm watching.
This happen if you trust to something which you don't understand 
Update: Suggested instruction is optimizer_search_depth=0.
No, you missed the point in my post. After library is imported all 8000 rows are fetched in a moment (0.098 sec). But after Kodi exits time is much, much longer (6.789 sec). I don't understand why? I did look mysql log but I don't understand anything other that SELECT 
I think you should read
You need to change hyperion package and build addon.
And SPI is already enabled?
-- ENABLE_SPIDEV = 1Also WS2801
[84/215] Building CXX object libsrc/leddevice/CMakeFiles/leddevice.dir/LedDeviceWs2801.cpp.oThen in /flash/syslinux.cfg use different partition for disk=UUID=.... or use /dev/ directly.
Is this "normal"?
start kodi, import library: 8230 rows in set (0.098 sec)
kodi is restarted: 8230 rows in set (6.789 sec)
You need rar2fs: Add rar2fs binary
I got system back and still long time for even simple select * from episode_view. No idea why. It should not be working like that.
Addon handles everything it needs.
Today is slow to me to. Strange.
Update: And now I can't even import db
Code12:11:59.127 T:140109139670784 DEBUG: RunQuery took 39317 ms for 6538 items query: select * from episode_view WHERE ((episode_view.dateAdded > '2012-01-01')) AND ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
Can you run this from mysql itself? mysql -u root -p
I don't have any database that's why I copy/paste entries on exported library to get more episodes. And from mysql I get
use MyVideos116;
select * from episode_view WHERE ((episode_view.dateAdded > '2012-01-01')) AND ((episode_view.playCount IS NULL OR episode_view.playCount < 1));
14816 rows in set (0.193 sec)
Listing them on terminal takes around 7 seconds. using LibreELEC (Milhouse): devel-20190118210257-#0118-ge23e672 (Generic.x86_64) and MariaDB addon 10.3.11.
PROJECT=.... ./scripts/create_addon name_of_addonIs it possible to update the server MariaDB add-on to v10.3.12? Who knows it'll fix it. Right now, Team Kodi is not in the happiest of moods of keeping up SQL db support.
Will do with few extra small changes.
I doubt HDD/SSD is making much difference in this case.
Leave storage as is and configure tvheadend to use extra mounted folders from esxi.
I tried with this in /storage/.kodi/userdata/addon_data/service.mariadb/my.cnf and I got log file with bunch of lines from Kodi.
general_log_file = /storage/.kodi/userdata/addon_data/service.mariadb/mysql.log
general_log = 1LibreELEC:~ # cat /storage/.kodi/userdata/addon_data/service.mariadb/mysql.log
/storage/.kodi/addons/service.mariadb/bin/mysqld, Version: 10.3.11-MariaDB-log (MariaDB Server). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
190110 13:07:30 8 Connect kodi@<IP_REMOVED> as anonymous on
8 Query SET NAMES utf8
8 Query SET SESSION sql_mode = (SELECT REPLACE(@@SESSION.sql_mode,'ONLY_FULL_GROUP_BY',''))
8 Query SELECT @@SESSION.optimizer_switch
8 Query SET SESSION optimizer_switch = 'derived_merge=off'
8 Query SHOW DATABASES LIKE 'MyVideos113'
8 Query SHOW TABLES LIKE '%'
8 Init DB MyVideos113
8 Query SHOW DATABASES LIKE 'MyVideos113'
8 Query SHOW TABLES LIKE '%'
8 Query SELECT idVersion FROM version
8 Quitstart/stop/restart the mariadb service
systemctl stop service.mariadb
systemctl start service.mariadb
systemctl restart service.mariadbKodi user can't connect on localhost but only on real ip address. That's why you need to use -h parameter
mysql -u kodi -p -h <real ip address of the server>I assume user kodi@localhost doesn't even exist according to what is created: LibreELEC.tv/mariadb.start at master · LibreELEC/LibreELEC.tv · GitHub
I'm not mysql user so something can also be wrongly implemented.
Whole dmesg would tell more (post url you get) by
dmesg | pastebinit