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

[Michael T. Dean]

On 07/25/2011 10:23 AM, Michael T. Dean wrote:
> On 07/25/2011 08:30 AM, Anthony Giggins wrote:
>> On 25 July 2011 18:59, David Edwards wrote:
>>> 2011/7/24 Warpme
>>>> 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
>> mytop might also be able to provide some useful information?
>
> And, since you converted to InnoDB (which, BTW, for others reading this
> thread, converting to InnoDB is not something we're recommending you
> do--when we're ready to do so, MythTV will automatically update the
> schema to use the InnoDB engine), please post the output of:
>
> SHOW ENGINE INNODB STATUS\G
>
> when it's deadlocked.
>

Oh, and probably not important, but because it would be useful in 
finding out if it's important, do you run mythshutdown?

Mike