[mythtv-users] MythSocket errors, backend unresponsive

Khanh Tran khanh at khanh.net
Sun Sep 26 18:48:19 UTC 2010


still trying to track down the root cause of this issue, I've been playing
with the settings in my.cnf with some success.   I get seemingly less
"MYTH_PROTO_VERSION was empty" when I switch from the default my.cnf for
openSUSE to the my.cnf for "large systems" from /usr/share/mysql.  Since I
just had my first MYTH_PROTO_VERSION error in 48 hours, I figured I'm on the
right track and just went down to the my.cnf for "medium systems".

However, I also found my way to the mysqltuner.pl script from the wiki and
used it to make some suggested changes for my system.  My MBE runs as a FE
as well as a backend/MySQL with 3GB RAM, minus (I think) 256M for onboard
Intel video.  Am I just running out of memory?

top says:

PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
18132 mythtv    20   0  296m 141m  23m S    0  4.7 119:41.58 mythfrontend
 2892 root      20   0  442m  93m 3940 S    0  3.1   5:34.75 X
29951 mythtv    20   0  277m  66m 9592 S    0  2.2   0:31.90 mythbackend
29937 mysql     20   0  233m  45m 5108 S    0  1.5   3:55.40 mysqld

Here's what I have for the global section of my current my.cnf:

key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
character-set-server            = utf8
default-character-set           = utf8
key_buffer_size = 128M
query_cache_size = 8M
query_cache_limit = 1M
join_buffer_size = 128K
tmp_table_size = 32M
max_heap_table_size = 16M
thread_cache_size = 4
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100926/9d550213/attachment.htm>


More information about the mythtv-users mailing list