[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