Solved Slow down
#16
Here you go: https://paste.kodi.tv/ulubupuyut
Reply
#17
Thanks. It doesn't look like any of the steps failed.
The next step that I was trying to avoid would be to send your 121 db to attempt reproduction on other systems. I don't see much else that could be done.
format: zip of the db dump I suppose?
Just in case I checked again a 20.5 to 21 migration with a 10.11.7 docker and there was no performance issue afterwards.

edit: looking a little closer at the log, there are were a few db access to movie_view after the migration, and they took much less time than the reported problem.
CVideoDatabase::RunQuery took 1345 ms for 3852 items query: select * from movie_view  WHERE (isDefaultVersion = 1) AND (((movie_view.playCount IS NULL OR movie_view.playCount = 0)))
CVideoDatabase::RunQuery took 710 ms for 10 items query: select * from movie_view  WHERE isDefaultVersion = 1 ORDER BY dateAdded desc, idMovie desc LIMIT 10

I don't know if that matches the numbers when the db is created from scratch, but it would be weird to have normal performance and then a degradation.
Always read the Kodi online-manual, the FAQ and search the forum before posting.
Do not e-mail Kodi Team members directly asking for support. Read/follow the forum rules (wiki).
For troubleshooting and bug reporting please make sure you read this first.
Reply
#18
Thanks again - I guess we should leave it there, since there are no other reports of the topic besides the two in this thread. Thanks for looking deeply - if the problem would manifest in more installations, I am more than happy to support at that time by providing data as needed.
Reply
#19
sure. If you want to dig, it sounds a bit like the statistics of some tables are bad, causing the optimizer to choose the wrong execution plan.
The migration creates a new db and doesn't inherit the previous db stats. It's a different access pattern when migrating and when importing into a new db so maybe we hit a maria db bug somehow. Can't really say...
Always read the Kodi online-manual, the FAQ and search the forum before posting.
Do not e-mail Kodi Team members directly asking for support. Read/follow the forum rules (wiki).
For troubleshooting and bug reporting please make sure you read this first.
Reply

Logout Mark Read Team Forum Stats Members Help
Slow down0