Solved TV-Show browsing dead slow with MySQL - 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: Solved TV-Show browsing dead slow with MySQL (/showthread.php?tid=357861) |
TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-21 Hello everybody, first of all I hope this is the correct forum. If not, please move this to the correct place. I've used Kodi on four Windows-Machines for several years and after getting into more and more trouble with watched-states, I decided to create a centralised database on my QNAP-NAS. This went well without any problems and two of the Windows-Machines are now set up to use the central database, which works fine with one exception, unfortunately. Browsing TV-Shows is dead slow on both machines. Switching to Season View takes 20-30 seconds. After that, it will be cached, but only until I start a video, then it's the same thing again - it's virtually unusable. I've read some older posts here on the forum and tried messing around with the my.cnf - to no avail so far. In these posts nobody came up with a solution (except switiching to emby, which is not what I really want to do). Here is the log: Debug Log (Database Details enabled) Some specs: Server: QNAP TS-853A / 16 GB / Celeron N3150 @ 1.60 GHz / QTS 4.5.1.1456 Client: PC / 32 GB / i9-9900K @ 3.60 GHz / Windows 10 64 Pro (latest) Kodi ver. 18.8 / Aeon Madnox Hope this is enough information and somebody can help me. Thanks! RE: TV-Show browsing dead slow with MySQL - Klojum - 2020-10-21 Please remove the banned repository from your Kodi setup first. We have no support for Kodi setups with video piracy installs. RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-21 Thanks for your reply. Can you tell me which repository you're referring to? Must be some leftover from long ago. I installed most of the repositories to try skins. And BTW how do I remove repositories? Context menu only gives me "deactivate" für repositories, no remove or uninstall... RE: TV-Show browsing dead slow with MySQL - Klojum - 2020-10-21 Look at your log, banned items are colored orange. Go to the Information page of the repository. It should have an Uninstall option. About your database server, it's a pretty old version. Any chance you can upgrade it? RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-21 So, I uninstalled the Repo, but it doesn't make any difference, still the same behaviour. As with the database, the problem is, it's embedded and part of the QNAP OS. So, in the end I'm quite dependent on QNAP concerning this part of the setup (which is a real pain, wouldn't recommend this to anybody!). As soon as I changed something that is part of the official firmware in the past, I lost all changes with the next firmware update, so that's not a good option. Besides, I'm not really familiar with Unix, so I might cause damage to the NAS which would be awful. However, I found this post on the qnap-forums, it might be an option as a last resort as well as this might be possible, but I doubt whether I manage to set up the whole thing correctly. Moreover, it doesn't really seem to be a performance issue with the database. Browing to album view in music database (4777 albums) causes a delay of 1 second. Also, browsing to the list of movies (3553 movies) causes virtually no delay. When in TV-Shows, it makes no difference how many seasons / episodes the series has. I tried "Cranford" (7 episodes) = 34,82 seconds to enter Season View and "The Simpsons" (663 episodes) = 34,80 seconds to enter Season View. These times were measured by hand, so I'd guess they're identical in reality. I'm sure the issue must be related to Season View itself or flattening or whatever. On the other hand, the same database doesn't cause any browsing issue on the two machines which still use their dedicated local databases. Update: Browsing "Genres" in Music Database also causes the 35 seconds delay! RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-26 Over the weekend, I have set up a Windows VM with the latest MySQL-Version on my QNAP and completely rebuilt the database. Unfortunately, this doesn't make any change. After the first 10 Series were in the database, it looked good, browsing speed was okay. But now that I've put all the series in the database, it's ~35 seconds to switch to Season View again. So I guess, it's not a problem with MySQL or the SQL-Version, as the problem is identical with an older Linux-version and a new Windows-version of the server. Looks as this is a problem with Kodi. Hope somebody has an idea, otherwise it might really be time to look for an alternative, as it is virtually unusable this way. RE: TV-Show browsing dead slow with MySQL - Klojum - 2020-10-26 (2020-10-26, 09:56)ForgotMyUsername Wrote: Looks as this is a problem with Kodi. Hope somebody has an idea, otherwise it might really be time to look for an alternative, as it is virtually unusable this way. Any chance you can double all cache-related settings in the my.cnf or my.ini file from MySQL? Just for testing purposes? I've used MySQL for years now on Linux, and no real problems emerged. Browsing episodes from a TV show with many episodes can take slightly longer (1-2 seconds) due to the more complex query at hand, but a query taking more than 30 seconds shouldn't happen. RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-26 I'm a real newbie to SQL, so I don't really know what exactly to do. This is the my.cnf, perhaps you can tell me which values to change? Quote:# Example MariaDB config file for medium systems. RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-28 Good News! After installing this MariaDB-Server on my QNAP, it finally works like a charm. It's really fast and the delay is gone. Still wondering what might be wrong with the older version or MySQL 8 on the Windows-VM, but I'll leave those problems to someone else and hope nobody ever runs into them. Hope it will still be so fast after feeding all my media into the database, but judging from the first test results, everything looks fine. Greetz, Mark TV-Show browsing dead slow with MySQL - Klojum - 2020-10-28 Thread marked solved. RE: TV-Show browsing dead slow with MySQL - ForgotMyUsername - 2020-10-29 Indeed! Thanks for your support! |