2021-08-20, 19:24
I have a server with Windows 10 and MySQL (v5.5) that has run Kodi 17.6 for several years. I have a media PC connected to my tv running Windows and Kodi that I use to watch TV.
I just upgraded from 17.6 to 19.1.
Database was upgraded, software installed, everything seems to be working OK.
However! When I am looking at a list of TV shows (for example, I click "Title" or "In Progress" when I'm in the TV Shows section), THAT menu loads quickly, but as soon as I click on any title, MySQL uses 100% of the CPU and there's a good 8-10 second delay before the list of seasons comes up. When I click on a season, the list of episodes loads quickly.
So it's only that one particular menu that's causing MySQL to spike the CPU usage and create a delay. When clicking on a title to see the list of episodes or list of seasons.
All the other lists seem to come up quickly (list of genres, list of actors, etc). Even if a tv show only has ONE episode available, clicking on the title of the show will create that 8+ second delay and MySQL CPU usage spike.
Also doesn't matter which computer I'm using Kodi on (tried 3 different computers that I upgraded to 19.1, and the server itself).
Any ideas?
P.S. - in the In Progress list, it used to show how many were watched compared to total, such as "8/10" so I knew there were 2 unwatched episodes. Now it just shows the total number of episodes. When I click on a title, (after the delay), it correctly shows me watched or unwatched statuses of the shows. Is this a setting to change somewhere?
I just upgraded from 17.6 to 19.1.
Database was upgraded, software installed, everything seems to be working OK.
However! When I am looking at a list of TV shows (for example, I click "Title" or "In Progress" when I'm in the TV Shows section), THAT menu loads quickly, but as soon as I click on any title, MySQL uses 100% of the CPU and there's a good 8-10 second delay before the list of seasons comes up. When I click on a season, the list of episodes loads quickly.
So it's only that one particular menu that's causing MySQL to spike the CPU usage and create a delay. When clicking on a title to see the list of episodes or list of seasons.
All the other lists seem to come up quickly (list of genres, list of actors, etc). Even if a tv show only has ONE episode available, clicking on the title of the show will create that 8+ second delay and MySQL CPU usage spike.
Also doesn't matter which computer I'm using Kodi on (tried 3 different computers that I upgraded to 19.1, and the server itself).
Any ideas?
P.S. - in the In Progress list, it used to show how many were watched compared to total, such as "8/10" so I knew there were 2 unwatched episodes. Now it just shows the total number of episodes. When I click on a title, (after the delay), it correctly shows me watched or unwatched statuses of the shows. Is this a setting to change somewhere?