[mythtv-users] query speedup?

[F Peeters (MythTV)]

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:
>>>
>>>> Hello,
>>>>
>>>> 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,
>>>> Udo
>>> 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:
>>> http://wilsonet.com/mythtv/fcmyth.php#mysql
>>>
>> 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...

Good luck!

-- 
F Peeters
  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...