[mythtv-users] MySQL related BE deadlocks - collective wisdomneeded

[warpme]

Dnia 27 lipca 2011 14:48 Dan Wilga <mythtv-users2 at dwilga-linux1.amherst.edu> napisał(a):

> On 7/27/11 5:48 AM, warpme wrote:
> > Well,
> > Having 30min Yesterday evening I recompile BE with above 2 lines commented in mythdbconn.cpp.
> > Unfortunately today I had deadlock again. This time it was in scheduler. Trace is again well known:
> >    
> Trying another angle on the disconnection idea, could you please post 
> the contents of your /etc/my.cnf file? I'm mostly interested in the 
> wait_timeout parameter, if there is one, but the whole thing might help.
> 
> Also, have you posted the contents of a "SHOW PROCESSLIST;" when the 
> database is locked? I don't recall seeing one yet.
> 
> 
Dan,
Pls see DB process list included in 6th post.
I don't have defined wait_timeout so I believe it is on 28800 (default) value.
Here is my.cfg:

[client]
port			= 3306
socket			= /var/run/mysqld/mysqld.sock

[mysqld]
port			= 3306
socket			= /var/run/mysqld/mysqld.sock
datadir			= /var/lib/mysql
skip-external-locking
key_buffer      	= 16M
max_allowed_packet 	= 1M
table_cache     	= 64
sort_buffer_size 	= 512K
net_buffer_length 	= 16K
myisam_sort_buffer_size = 8M
query_cache_size 	= 0
query_cache_type 	= 0

[mysqld_safe]
err_log         	= /var/log/mysqld.err
server-id	= 1

[mysqldump]
quick
max_allowed_packet = 16M

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout