[mythtv-users] Successful Results,
EPG speedup with MySQL 4 and query cache
Joe Votour
joevph at yahoo.com
Sun Nov 14 19:05:40 UTC 2004
I tried the instructions as well, and I can also
report that the upgrade to MySQL 4 works, and the EPG
does feel snappier.
Which section did you put the query commands in? If I
put them under the "[mysqld]" section, then MySQL
won't even start properly. Adding them to the end of
the file seems to work, but I'm not sure that I'm
getting the caching then.
-- Joe
--- John Freer <john_freer at yahoo.com> wrote:
> Hi All,
>
> Just wanted to provide a report of successful
> result. Awhile back
> somebody posted a suggestion to use the query cache
> on mysql 4 to
> improve EPG responsiveness. Think it was Ed
> Wildgoose.
>
> Anyway, it took about an hour to do the upgrade from
> mysql 3 to 4.1.
> I used the instructions provided here:
>
> http://fedoranews.org/contributors/tony_smith/mysql/
>
> worked like a charm. I then set
> enable_query_cache=1 and
> query_cache_size=4000000 in /etc/my.conf. The
> results were great.
> Really improved the responsiveness of the EPG.
>
> Much happier now.
>
> Hope this helps somebody.
>
> JF
>
>
> > _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
More information about the mythtv-users
mailing list