[mythtv-users] query speedup?
F Peeters (MythTV)
francesco at fampeeters.com
Sun Nov 26 10:16:51 UTC 2006
On Sun, November 26, 2006 11:07, Udo van den Heuvel wrote:
> F Peeters (MythTV) wrote:
>> On Sun, November 26, 2006 10:39, Brad DerManouelian wrote:
>>> On Nov 26, 2006, at 1:31 AM, Udo van den Heuvel wrote:
>>>> Where can I find tips to speed up the database of MythTV?
>>>> MySQL takes 90+ seconds to list Recorded programs in MythWeb. (only 92
>>>> programs from 1 channel)
>>>> The machine is ~50% idle during the query.
>>>> How can I find out why this query takes so much time?
>>>> Kind regards,
>>> You should run optimize_mythdb.pl. It's in the contrib directory. In
>>> fact, it's recommended that you set it up as a cron job and run it
>>> every night. If that doesn't help, you can tweak the MySQL settings.
>>> There's recommendations for those settings on Jarod's guide here:
>> Or try turning off the thumbnails in the MythWeb settings...
>> Apparently it rebuilds those every time you refresh the page, because on
>> my box loading time went down from 120+ seconds to about 10 seconds by
>> disabling pixmaps option...
> Thanks for the tips. (you are quick!)
> optimize_mythdb.pl does not make much of a difference for this situation.
> The thumbnails tip is kinda strange: when a show is recorded a png of
> the right size is generated automagically. On the webpage the png is of
> the same size as in the directory with the recordings. In the access_log
> the png is even cached.
> So what happens?
> I want my thunmbnails, I assume they are gone with disabling the pixmap
> option you mention?
> Can I consider this a bug? (pending finding out where the majority of
> the time is lost)
I haven't had time to research where the delay is at... I just found that
in my setup disabling the pixmaps/thumbnails helps a lot... I want them
too, but not that badly that I want to wait over 2 minutes to get the
recorded programs list...
(Hey, I'm Dutch too, and admit it: we don't live if we cannot complain! <G>)
Anyway... I definately want to know where the problem is, just haven't had
time to figure out the problem...
PC-Chips M863G Geode - NVidia 440 - Hauppauge PVR250
Ubuntu 6.10 (Edgy Eft) - XFCE - MythTV 0.20 - Xine
Panasonic NV-VHD1 VCR/DVD player case modded to fit it all in...
More information about the mythtv-users