Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD)

Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Printable Version

+- 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: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) (/showthread.php?tid=337576)

Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Scybalon - 2018-11-17

Hello everybody,

I am experiencing some major issues with my Kode (OSMC) installations.
I have a WD MyBook, where I installed a MySQL-Server which I want to access from 2 Raspberry Pi as well as 1 Win 10 Computer.
This installation worked perfectly until some time ago.

Now I am experiencing an extreme lag, and I don't know what to do next.
Having the Debugging activated I started my Kodi-Installation on my Win10 PC. Here ist the log: Log

The issues started (in my opinion) around line 493, as I started my Kodi Installation around 14:23:20 and everything was within a few milliseconds until this line.
Unfortunately I have no clue at all how to interpret my log / resolve my issue.

I hope you can help me in this matter.

Thank you very much in advance!

Scybalon

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Klojum - 2018-11-17

(2018-11-17, 15:38)Scybalon Wrote: This installation worked perfectly until some time ago.

Something must have changed... Do you have a slow Kodi also on the 2 RPi boxes, or just on the Win10 pc?

It's a bit odd... Using Kodi 17 with MyVideos107, and getting a "14:23:20.327 T:11368 DEBUG: CDatabaseManager::Initialize, updating databases..." entry in the log.

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Scybalon - 2018-11-18

First of all: Thank you for your answer.

You are right, something has changed: I moved apartment.
I used Powerline (Devolo) in my old apartment to connect to the internet and am still using the same hardware in my new apartment.
But I have no clue, how this could cause the problem.

I am also experiencing the lag with my 2 RPi-boxes.
I did a clean / fresh installation on all three devices (2 Rasperry Pi, 1 Win 10), dropped the old databases on my MySQL-Database (on my NAS) and rebuilt the database from scratch.

I still hope you guys can help me.

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Klojum - 2018-11-18

Powerline adapter connections can be as volatile as wifi connections from what I know. Wifi connections also vary per location. Thicker walls = lousier wifi connections.

If you want to test network speed, try a ethernet cable and see if there is a (noticeable) difference. If there is, you have a crap powerline connection...
How are the RPi's connected, via wifi?

If you have the choice, ethernet is 100% the way to go.

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Scybalon - 2018-11-18

I do not use Wifi for my Rasperry Devices (as well as my Win 10 PC).
I also had this thought and tried to connect my Win 10 to the same Router as my NAS. Of course the speed (Ping, MB/s) was better but the performance of my Kodi installation was still miserable.

So you see: I am out of ideas Sad

Do you guys have any other suggestions (based on the log-file?)?

Thank you very much in advance!

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - DarrenHill - 2018-11-18

I used to host my MySQL on my WD NAS (a MyCloud Mirror) and have to say that it wasn't nice.

The problem I think is that the drive that contains the database tends to spin down and sleep (even when that feature is apparently switched off on the NAS), and so before it can be accessed it needs to spin up and become active again. I was seeing this when navigating through the menus in Kodi and before/after playing things (when the database is accessed and updated).

Simplest way is to host the database elsewhere, perhaps even on one of the Pi's itself if OSMC allows that? I know on LibreElec it can be done via the docker add-on and the MariaDB container. If not then perhaps invest in another Pi and use that as the host, or just do it on another PC on your network if you have a suitable one which is always awake.

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Klojum - 2018-11-18

I once ran Raspbian on an RPi3B+ that booted from an external (bootable) SSD via USB, and running MariaDB server on it.
It ran okay, given the RPi's moderate CPU performance.

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Scybalon - 2018-11-22

Unfortunately the problem still exists - Does anybody have a clue whats causing the problem?

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - DarrenHill - 2018-11-23

Based on the above comments and suggestions, what have you actually done to try and rectify it?

RE: Slow Kodi (Win10 & Raspberry Pi) with MySQL on external NAS (WD) - Scybalon - 2018-12-03

(2018-11-18, 13:35)Klojum Wrote: If you want to test network speed, try a ethernet cable and see if there is a (noticeable) difference. If there is, you have a crap powerline connection...How are the RPi's connected, via wifi?.

The Pi's as well as the PC have a wired connection.

(2018-11-18, 18:29)DarrenHill Wrote: I used to host my MySQL on my WD NAS (a MyCloud Mirror) and have to say that it wasn't nice.
The problem I think is that the drive that contains the database tends to spin down and sleep (even when that feature is apparently switched off on the NAS), and so before it can be accessed it needs to spin up and become active again. I was seeing this when navigating through the menus in Kodi and before/after playing things (when the database is accessed and updated).

I have experienced this as well - however, this does not bug me at all, as it only takes a few seconds to start up the drive and everything worked smoothly (as long as I kept accessing the database (till the next spin down)

(2018-11-18, 18:29)DarrenHill Wrote: Simplest way is to host the database elsewhere, perhaps even on one of the Pi's itself if OSMC allows that? I know on LibreElec it can be done via the docker add-on and the MariaDB container. If not then perhaps invest in another Pi and use that as the host, or just do it on another PC on your network if you have a suitable one which is always awake.

First of all: I had exactly this setup in the past - so it is possible to host the database on the Pi itself
Unfortunately, this is not what I want Sad

I wanted to keep the database separated on my NAS so that it is possible for me to exchange any Pi's as a please. Smile

(2018-11-23, 11:33)DarrenHill Wrote: Based on the above comments and suggestions, what have you actually done to try and rectify it?

So you see, there are not many options for me to try. If I have misinterpreted any solution, please feel free to point it out.

The LOG-File provided in my original post does not help?