[mythtv-users] query speedup?

[F Peeters (MythTV)]

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

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