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

Anthony Giggins seven at seven.dorksville.net
Mon Jul 25 12:30:42 UTC 2011


On 25 July 2011 18:59, David Edwards <david at more.fool.me.uk> wrote:

> 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
>
>
>
mytop might also be able to provide some useful information?

Cheers,

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


More information about the mythtv-users mailing list