[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