[mythtv-users] Possibly Handy tweaks

[Yan-Fa Li]

Web based applications tend to benefit from the query cache most since 
they are do mostly reads and tend to do very little application layer 
caching, so I'm not surprised it's helping.

I think you're right, that setting larger net_buffer_sizes won't help 
that much unless you're doing large transactions like transferring clobs 
back and forth from the database.  I'm setting it since remote frontends 
do a lot of stuff over network sockets.  It certainly seems to not do my 
setup any harm.

Actually a couple of other settings I've been meaning to try were 
tweaking the tcp read and write socket memory buffers to max.  This 
helps with throughput, which may be useful for a video streaming setup 
to frontends.

Yan

David Rees wrote:
> 
> Using MySQL Administrator to monitor server stats, it seems like the 
> key_buffer and query_cache_size I've set are a bit overkill for my setup.
> 
> What is amazing is how fast things run in the Mythweb now.  Used to be 
> that the pages would be a bit sluggish, now they are quite snappy on my 
> Duron 800.  MySQL CPU utilization seems to be down as well.
> 
> Does setting a larger net_buffer_size improve things much?  The docs I 
> saw mentioned that you shouldn't need to change it typically...