Posts: 14,211
Joined: Nov 2009
Reputation:
708
Klojum
Lost connection
Posts: 14,211
Crashes with RPi's that normally run okay... I'd say the SD card is getting write issues over time. Most of the SD cards don't have any wear levelling or TRIM support like real SSDs do, so sooner or later they will wear out. Having the databases centralized via a remote MySQL server tends to help, the video database will cause the most writes with every movie or tv episode that is watched.
BTW, I also compacted your signature a bit. We have a 4 line maximum policy on this forum.
Posts: 470
Joined: Oct 2013
Reputation:
2
2018-05-31, 01:20
(This post was last modified: 2018-05-31, 01:28 by Rickt1962.)
I always thought it was caused by addons . So for testing purposes I used a brand NEW Scan Disk ultra 32 gig and the only thing on Kodi is the PVR by Zoltan.
Now retried it with out the Library and no crashing
One HTPC Windows 7 pro 64x running WMC with 2 HDhomeRun on Comcast 6 tuners with MCEbuddy
WD MyCloud 24TB over Netgear network | 6500 movies and 40,000+ TV Show episodes
Posts: 14,211
Joined: Nov 2009
Reputation:
708
Klojum
Lost connection
Posts: 14,211
I don't know all types of WD MyCloud devices or their specificaties.
If yours does support/run MySQL, have a try at it. If it doesn't do MySQL, than that's it.
Posts: 4,545
Joined: Jun 2015
Reputation:
269
Use MySQL (if you can) if you really want a client server set up (shared libraries across multiple Kodi installations), however know there is a price. MySQL is generally slower than SQLite (used on the default stand alone Kodi), and with large music or video collections you may notice this. Also having the db across a network will be slower than having it on the SD card.
Posts: 12,508
Joined: Oct 2014
Reputation:
608
MySQL is only on the newer/larger MyCloud devices - I have it available on my MyCloud Mirror Gen1, but I don't think it's on the older standard single-disk versions.
Even then running it there caused quite significant slow-down on my devices, as the database is stored on the drives, so they have to be awoken/spun-up when the database needs to be read or updated. Even on a fully wired network between my Pi3 and MCM it still took several seconds.
If you do want to run a MySQL type database and are on LibreElec, one option is to install the docker support add-on, and then also the Linuxserver.io repo (from the main LE repo) and then use their MariaDB container.
Posts: 12,508
Joined: Oct 2014
Reputation:
608
2018-06-03, 19:44
(This post was last modified: 2018-06-03, 19:45 by DarrenHill.)
Not from me - I run a mariaDB container under Docker (the LibreElec setup I mentioned above) on a Pi 3b and it suffices fine for my needs.
Posts: 470
Joined: Oct 2013
Reputation:
2
How large is your library ?
One HTPC Windows 7 pro 64x running WMC with 2 HDhomeRun on Comcast 6 tuners with MCEbuddy
WD MyCloud 24TB over Netgear network | 6500 movies and 40,000+ TV Show episodes
Posts: 487
Joined: Jun 2013
Reputation:
21
Wasn't there a kodi forum thread that outlined optimisations that could be done to greatly improve MYSQL performance?
Sadly my google foo is not working at the moment so i can't provide a link to said thread.