[mythtv-users] Possibly Handy tweaks

[David Rees]

> Here are some common useful tweaks to make MySQL more responsive,
> these go in the /etc/my.cnf under the mysqld section:
> 
> key_buffer = 48M
> max_allowed_packet = 8M
> table_cache = 128
> sort_buffer_size = 48M
> net_buffer_length = 8M
> thread_cache_size = 4
> query_cache_type = 1
> query_cache_size = 4M

Thanks for getting my butt in gear and tweaking my mysql config.  I'm on 
FC1 which had MySQL 3.23.58 installed.  I upgraded to MySQL 4.0.21, and 
then looked to tweaking /etc/my.conf.  I'm running these parameters now:

# Don't need InnoDb for Myth
skip-innodb
key_buffer = 16M
table_cache = 128
sort_buffer_size = 2M
myisam_sort_buffer_size = 8M
query_cache_size = 16M

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...

-Dave