[mythtv-users] "Watch Recordings" slow - disable thumbnail/preview generation, or big SQL queries?

[Niklas Brunlid]

On 4 April 2011 20:58, Niklas Brunlid <prefect47 at gmail.com> wrote:

>
>
> On 4 April 2011 19:38, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
>> On 04/04/2011 12:42 PM, Niklas Brunlid wrote:
>> > On 2 April 2011 20:46, Michael T. Dean wrote:
>> > ...
>>
>
...


>
>> Since it may well be backend data access or processing causing the slow
>> down, I recommend trying something like:
>>
>> wget mysqltuner.pl
>>
>> and then running it against your database to see if it has any
>> recommendations.
>
>
> Thanks, this had some good tips. The database is obviously old and was last
> optimized more than a year ago... :)
>

Ran this a few times and I think it feels a little faster, but it may just
be a psychological effect. :)
I think running the optimize_mythdb.pl script  is what actually made a
difference.

/ Niklas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110410/af000974/attachment.html