[mythtv-users] MySQL related BE deadlocks - collective wisdomneeded
mythtv-users2 at dwilga-linux1.amherst.edu
Wed Jul 27 13:58:17 UTC 2011
On 7/27/11 9:47 AM, warpme wrote:
> Pls see DB process list included in 6th post.
I'm looking at the thread here:
and I see a backend stacktrace and the output of SHOW ENGINE INNODB
STATUS, but not SHOW PROCESS LIST. This could help, because it would
show if there is another process other than Myth trying to use the DB or
if, perhaps, there are two competing backends.
> I don't have defined wait_timeout so I believe it is on 28800 (default) value.
> Here is my.cfg:
Your my.cnf looks sub-optimal, but nothing jumps out at me as a possible
cause of the problem.
More information about the mythtv-users