2022-11-09, 11:55
Mysql Server Setup:
Pi 4 b running Raspbian GNU/Linux 10 (buster)
MariaDB version 10.0
Client:
Kodi 18.9 on Windows 10
Addon - Youtube2KodiLibrary https://github.com/evantaur/plugin.youtube2kodilibrary
Hi All,
So I've been running this setup just fine for the longest of times but I had noticed degradation to my performance and especially even more since I have recently installed "YouTube2kodilibrary" addon which basically pulls nfo and strm files off of youtube channels which you can then scan into Kodi as a TV show. This works great but has slowed my Kodi experience even further.
I decided to upgrade my MariaDB server and also dropped my database so I could start fresh. This worked amazing until I started to scrape the Youtube stuff. I then experienced scraping failures such as halfway through receiving messages that the show could not be found, which would result in either most of the scrape not being completed. I would say 70% of the shows scraped fine, others had issues. Even trying to manually run the unscraped strm files would either lead to playing the video or flat out making Kodi crash without notice. Of the videos that played fine, I could manually scrape them individually as well.
But Kodi ran at an amazing speed in terms of navigating the library, no lag whatsoever.
So after various testing and restoring my Pi 4 backup image several I came to the following conclusions:
1. MariaDB 10.0 can scrape all the Youtube files fine, but then Kodi slows down to a crawl. Im talking 10-15 minutes to open up a TV show to view the episodes.
2. MariaDB 13.0 will not scrape properly but Kodi works reaaally fast. In the log there was multiple instances of "SQL: [MyVideos116] Undefined MySQL error: Code (1366)"
3. Hiding my advancedsettings.xml, I can scrape the Youtube files to my local database without issues.
So there must be something wrong with MariaDB, right? I noticed some of the nfo files from Youtube2Kodilibrary being quite long and also having some irregular letters/symbols which maybe MariaDB 13.0 doesn't like? Maybe MariaDB 10.0 will take them in, hence the slow performance as the database is struggling with the odd characters?
The only thing I tried with Mariadb was to alter the database structure, as I saw people having isssues with scraping nfo files which have many URLS, with the following command to increase the field size of column c06:
ALTER TABLE MyVideos116.tvshow MODIFY COLUMN c06 longtext DEFAULT NULL NULL;
Which didn't help. Any Idea how I should proceed? If logs of Kodi are need, just let me know which "error" you would like me to reproduce. I have a feeling I need to adjust the MariaDB though.
Much appreciated!
Regards,
Deep
Pi 4 b running Raspbian GNU/Linux 10 (buster)
MariaDB version 10.0
Client:
Kodi 18.9 on Windows 10
Addon - Youtube2KodiLibrary https://github.com/evantaur/plugin.youtube2kodilibrary
Hi All,
So I've been running this setup just fine for the longest of times but I had noticed degradation to my performance and especially even more since I have recently installed "YouTube2kodilibrary" addon which basically pulls nfo and strm files off of youtube channels which you can then scan into Kodi as a TV show. This works great but has slowed my Kodi experience even further.
I decided to upgrade my MariaDB server and also dropped my database so I could start fresh. This worked amazing until I started to scrape the Youtube stuff. I then experienced scraping failures such as halfway through receiving messages that the show could not be found, which would result in either most of the scrape not being completed. I would say 70% of the shows scraped fine, others had issues. Even trying to manually run the unscraped strm files would either lead to playing the video or flat out making Kodi crash without notice. Of the videos that played fine, I could manually scrape them individually as well.
But Kodi ran at an amazing speed in terms of navigating the library, no lag whatsoever.
So after various testing and restoring my Pi 4 backup image several I came to the following conclusions:
1. MariaDB 10.0 can scrape all the Youtube files fine, but then Kodi slows down to a crawl. Im talking 10-15 minutes to open up a TV show to view the episodes.
2. MariaDB 13.0 will not scrape properly but Kodi works reaaally fast. In the log there was multiple instances of "SQL: [MyVideos116] Undefined MySQL error: Code (1366)"
3. Hiding my advancedsettings.xml, I can scrape the Youtube files to my local database without issues.
So there must be something wrong with MariaDB, right? I noticed some of the nfo files from Youtube2Kodilibrary being quite long and also having some irregular letters/symbols which maybe MariaDB 13.0 doesn't like? Maybe MariaDB 10.0 will take them in, hence the slow performance as the database is struggling with the odd characters?
The only thing I tried with Mariadb was to alter the database structure, as I saw people having isssues with scraping nfo files which have many URLS, with the following command to increase the field size of column c06:
ALTER TABLE MyVideos116.tvshow MODIFY COLUMN c06 longtext DEFAULT NULL NULL;
Which didn't help. Any Idea how I should proceed? If logs of Kodi are need, just let me know which "error" you would like me to reproduce. I have a feeling I need to adjust the MariaDB though.
Much appreciated!
Regards,
Deep
