Posts by vpeter

You need to look into README file for instructions. Try with

.............
PKG_TOOLCHAIN="manual"

pre_make_target() {
  cp makefile.linux_amd64 makefile.machine
}

make_target() {
  make all2 CC=$CC CXX=$CXX
}

I don't think your if statement works. Try with

  ping -c 1 -w 3 172.16.0.1 &>/dev/null
  if [ $? -ne 0 ]; then

PR send.

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

Compile [LibreELEC.wiki]

Compile [LibreELEC.wiki]

You need to change hyperion package and build addon.

And SPI is already enabled?

-- ENABLE_SPIDEV   = 1

Also WS2801

[84/215] Building CXX object libsrc/leddevice/CMakeFiles/leddevice.dir/LedDeviceWs2801.cpp.o

Then in /flash/syslinux.cfg use different partition for disk=UUID=.... or use /dev/ directly.

Is this "normal"?

Quote

start kodi, import library: 8230 rows in set (0.098 sec)

kodi is restarted: 8230 rows in set (6.789 sec)

Like Mounting network shares [LibreELEC.wiki]

Use cron?

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

Quote from Klojum

Code

12: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

Quote

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.

Quote from Klojum

Is 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.