[mythtv-users] MySQL related BE deadlocks - collective wisdom needed

[David Edwards]

2011/7/24 Warpme <warpme at o2.pl>

> I'll be really grateful for any hint helping me to move forward with this
> very frustrating situation.
>

I do not know the MythTV code at all, but that does look like it is waiting
for (or actually reading) data from the DB. Have you looked at what queries
are running when Myth hangs? Try connecting to the database using the mysql
command line tool and running "show full processlist;" to see what it is up
to. You could also try turning on the MySQL general query log to see what it
is doing prior to the problem occurring:
http://dev.mysql.com/doc/refman/5.1/en/query-log.html

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110725/ce545e57/attachment.html