[mythtv-users] Sluggish watch recordings list after 0.27 upgrade.
Jamie Moore
mythtv-users at jamiem.com
Tue Dec 10 11:48:24 UTC 2013
Hello. New to the list so I hope I'm doing this right.
I'm using the latest Debian dmo packages (0.27.0+fixes20131113-dmo1) and
I have the same problem with sluggish Watch Recordings list.
I have managed to /sort of/ recreate what Bryan did.
At 02:09am
-rw-r--r-- 1 jamie jamie 85K Dec 10 02:09 1009_20131209202400.mpg.png
-rw-r--r-- 1 jamie jamie 91K Dec 10 02:09 2050_20131209223100.mpg.png
-rw-r--r-- 1 jamie jamie 69K Dec 10 02:09 2054_20131209195600.mpg.png
-rw-r--r-- 1 jamie jamie 79K Dec 10 02:09 2054_20131209215400.mpg.png
At 11:22am
-rw-r--r-- 1 jamie jamie 85K Dec 10 11:22 1009_20131209202400.mpg.png
-rw-r--r-- 1 jamie jamie 91K Dec 10 11:22 2050_20131209223100.mpg.png
-rw-r--r-- 1 jamie jamie 69K Dec 10 11:22 2054_20131209195600.mpg.png
-rw-r--r-- 1 jamie jamie 79K Dec 10 11:22 2054_20131209215400.mpg.png
At 11:38am
-rw-r--r-- 1 jamie jamie 85K Dec 10 11:22 1009_20131209202400.mpg.png
-rw-r--r-- 1 jamie jamie 91K Dec 10 11:22 2050_20131209223100.mpg.png
-rw-r--r-- 1 jamie jamie 69K Dec 10 11:22 2054_20131209195600.mpg.png
-rw-r--r-- 1 jamie jamie 79K Dec 10 11:22 2054_20131209215400.mpg.png
You'll notice that the first run at 11:22am had the thumbnails recreate.
A subsequent launch and scroll through the programmes at 11:38am did not.
It is worth noting that the problem still manifests even when the
thumbnails are seemingly /not/ being regenerated.
Now that I'm on-list, here's a copy/paste from an e-mail I sent to Bryan
which might or might not shed more light on things:
---------------------------------- 8< ---------------------------------
Something I have noticed, if you take an mysql log, each time you scroll
down between recordings a number of SQL actions are fired, seemingly
pertaining to the `jobqueue` table.
137 Prepare SELECT status FROM jobqueue WHERE type = ? AND
chanid = ? AND starttime = ?
137 Reset stmt
137 Close stmt
137 Prepare SELECT status FROM jobqueue WHERE type = ? AND
chanid = ? AND starttime = ?
137 Reset stmt
137 Close stmt
137 Prepare SELECT status FROM jobqueue WHERE type = ? AND
chanid = ? AND starttime = ?
137 Reset stmt
137 Execute SELECT status FROM jobqueue WHERE type = 1 AND
chanid = 2052 AND starttime = '2013-11-05 23:11:00'
137 Close stmt
137 Prepare SELECT status FROM jobqueue WHERE type = ? AND
chanid = ? AND starttime = ?
137 Reset stmt
137 Execute SELECT status FROM jobqueue WHERE type = 2 AND
chanid = 2052 AND starttime = '2013-11-05 23:11:00'
137 Close stmt
137 Prepare SELECT status FROM jobqueue WHERE type = ? AND
chanid = ? AND starttime = ?
137 Reset stmt
137 Close stmt
[SQL continues for a hundred or so lines]
Some of these prepare statements seem populated/executed
137 Execute SELECT status FROM jobqueue WHERE type = 1 AND chanid =
2052 AND starttime = '2013-11-05 23:11:00'
At any rate, a difference between a "working" system and a "broken"
system seems to be that on the bad system, the frontend "waits" [locks?]
while the SQL completes before /visually/ reacting to the keypress /
remote press. I say /visually/ because if you actually press down a few
times while it's "thinking" and wait - you end up a few programme lines
down.
---------------------------------- 8< ---------------------------------
While my abilities might be limited, I'd be happy to do any debugging
that anyone can suggest to help iron this out.
Regards,
Jamie.
On 10/12/13 10:48, Bryan Bennetts wrote:
> Slowly getting time to look a this. One thing I notice from the logs is :
>
> Dec 10 10:40:19 peroni mythfrontend.real: mythfrontend[1400]: I
> CoreContext mythuihelper.cpp:1483 (LoadCacheImage) MythUIHelper:
> LoadCacheImage(/home/myth/.mythtv/remotecache/1071_20131101085400.mpg.png,-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png)
> Dec 10 10:40:19 peroni mythfrontend.real: mythfrontend[1400]: I
> ImageLoad mythuihelper.cpp:1483 (LoadCacheImage) MythUIHelper:
> LoadCacheImage(/home/myth/.mythtv/remotecache/1071_20131101085400.mpg.png,-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png)
> Dec 10 10:40:19 peroni mythfrontend.real: mythfrontend[1400]: I
> ImageLoad mythuihelper.cpp:663 (RemoveFromCacheByURL) MythUIHelper:
> RemoveFromCacheByURL removed
> :/home/myth/.mythtv/themecache/Mythbuntu.1920.1080/-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png:
> from cache
> Dec 10 10:40:19 peroni mythfrontend.real: mythfrontend[1400]: I
> ImageLoad mythuiimage.cpp:275 (LoadImage)
> ImageLoader::LoadImage(-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png)
> NOT Found in cache. Loading Directly
> Dec 10 10:40:19 peroni mythfrontend.real: mythfrontend[1400]: I
> ImageLoad mythuihelper.cpp:1299 (LoadScaleImage) MythUIHelper:
> LoadScaleImage(/home/myth/.mythtv/remotecache/1071_20131101085400.mpg.png)
>
> I may be misreading but isn't that saying 'I need these images', 'Remove
> the image form the Cache', 'Oh no the image isn't in the cache I need to
> load it from source'?
>
> Unfortunately I didn't get the file time stamp prior to the messages,
> but certainly it has been updated :
>
> myth at peroni:~$ ls -l
> /home/myth/.mythtv/themecache/Mythbuntu.1920.1080/-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png
> -rw-rw-r-- 1 myth myth 98248 Dec 10 10:40
> /home/myth/.mythtv/themecache/Mythbuntu.1920.1080/-home-myth-.mythtv-remotecache-1071_20131101085400.mpg.png--492x277.png
>
> Cheers, Bryan.
>
>
> On 3 December 2013 19:18, Bryan Bennetts <bryan.bennetts at gmail.com
> <mailto:bryan.bennetts at gmail.com>> wrote:
>
>
> On Dec 3, 2013 6:35 PM, "Stuart Morgan" <stuart at tase.co.uk
> <mailto:stuart at tase.co.uk>> wrote:
> >
> > On Tuesday 03 Dec 2013 10:06:04 Jim Stichnoth wrote:
> > > On Tue, Dec 3, 2013 at 7:13 AM, Bryan Bennetts
> > <bryan.bennetts at gmail.com <mailto:bryan.bennetts at gmail.com>>wrote:
> > > > Hi all,
> > > >
> > > > I've upgraded to mythbuntu 13.10/mythtv 0.27 and am now
> finding that one
> > > > of my frontend's Watch Recordings view is somewhat sluggish.
> > > >
> > > > That machine is a Acer Revo 3700 (with 4G of ram IIRC) so not
> hugely
> > > > over-powered but on 0.26 there was no perceivable issue. I
> have tried
> > > > creating my own MythBuntu theme with the fanart turned off,
> but that has
> > > > not improved performance.
> > > >
> > > > It *seems* to be related to the length of the episodes list as
> when
> > > > scrolling down the left hand panel it is noticably faster for,
> say, films
> > > > (split second scrolling) than children's programs (of which we
> have
> > > > plenty,
> > > > can take a good 3-4 seconds to populate the right hand panel).
> This
> > > > implies that the menu *may* be doing an operation per episode.
> > > >
> > > > Anyone have any thoughts on how to diagnose/resolve this?
> > >
> > > I have this same issue on my ION frontends. I believe it has to
> do with a
> > > 0.27 change where the frontend now asks the backend to generate
> preview
> > > images at full resolution before scaling locally to the
> theme-specified
> > > resolution, instead of generating smaller preview images on the
> backend
> > > which are rescaled again on the frontend.
> >
> > The scaling is done in a background thread, therefore wouldn't affect
> > responsiveness unless threading wasn't enabled. Moreover, since
> the preview
> > image is cached locally after scaling, it wouldn't affect
> scrolling through the
> > list unless there were always new recordings which required new
> preview
> > images. Which isn't to say that the issue isn't preview related
> somehow, just
> > that it's not related to the scaling.
> >
> > --
> > Stuart Morgan
> > MythTV
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
> > http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> Hmm, well I'll try paring down the theme more to see if affects the
> behaviour. I would hope that the code isn't generating a preview
> for each episode just as the main tile is selected in the left hand
> list.
>
> Cheers, Bryan.
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list