[mythtv-users] "Watch Recordings" slow - disable thumbnail/preview generation, or big SQL queries?
prefect47 at gmail.com
Sun Apr 10 10:15:48 UTC 2011
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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users