2016-11-24, 00:07
Hello, I have some problem with CPU loading on my NAS Synology with this service. There is a lot queries to database witch loading NAS CPU if choose any theme using Skin Helper Service.
When I stop this servise everything is ok but many skins are dependent on that.
I use the NAS as my db Server (MariaDB) for storing a lot of movies, so SQL queries below are endless:
How to avoid this queries? Can I disable this feature?
Tested with Kodi Jarvis themes and Krypton themes. For example, Estuary skin does not make slq queries but Estuary MOD does.
When I stop this servise everything is ok but many skins are dependent on that.
I use the NAS as my db Server (MariaDB) for storing a lot of movies, so SQL queries below are endless:
Code:
...
22:28:53.762 T:2980 DEBUG: CVideoDatabase::RunQuery took 2180 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 4
22:28:55.710 T:2980 DEBUG: CVideoDatabase::RunQuery took 1910 ms for 1 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=6 ORDER BY sets.idSet
22:28:57.031 T:2980 DEBUG: CVideoDatabase::RunQuery took 1315 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 6
22:28:59.451 T:2980 DEBUG: CVideoDatabase::RunQuery took 2393 ms for 3 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=7 ORDER BY sets.idSet
22:29:00.985 T:2980 DEBUG: CVideoDatabase::RunQuery took 1526 ms for 3 items query: select * from movie_view WHERE movie_view.idSet = 7
22:29:02.967 T:2980 DEBUG: CVideoDatabase::RunQuery took 1963 ms for 1 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=8 ORDER BY sets.idSet
22:29:04.243 T:2980 DEBUG: CVideoDatabase::RunQuery took 1270 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 8
22:29:05.799 T:2980 DEBUG: CVideoDatabase::RunQuery took 1532 ms for 5 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=9 ORDER BY sets.idSet
22:29:06.857 T:2980 DEBUG: CVideoDatabase::RunQuery took 1052 ms for 5 items query: select * from movie_view WHERE movie_view.idSet = 9
22:29:08.260 T:2980 DEBUG: CVideoDatabase::RunQuery took 1392 ms for 2 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=10 ORDER BY sets.idSet
22:29:09.485 T:2980 DEBUG: CVideoDatabase::RunQuery took 1219 ms for 2 items query: select * from movie_view WHERE movie_view.idSet = 10
22:29:10.887 T:2980 DEBUG: CVideoDatabase::RunQuery took 1387 ms for 1 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=11 ORDER BY sets.idSet
22:29:11.925 T:2980 DEBUG: CVideoDatabase::RunQuery took 1031 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 11
22:29:13.187 T:2980 DEBUG: CVideoDatabase::RunQuery took 1247 ms for 1 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=12 ORDER BY sets.idSet
22:29:14.730 T:2980 DEBUG: CVideoDatabase::RunQuery took 1531 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 12
22:29:16.051 T:2980 DEBUG: CVideoDatabase::RunQuery took 1284 ms for 3 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=13 ORDER BY sets.idSet
22:29:17.142 T:2980 DEBUG: CVideoDatabase::RunQuery took 1080 ms for 3 items query: select * from movie_view WHERE movie_view.idSet = 13
...
How to avoid this queries? Can I disable this feature?
Tested with Kodi Jarvis themes and Krypton themes. For example, Estuary skin does not make slq queries but Estuary MOD does.