GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

How to reset Innodb_deadlocks counter?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to reset Innodb_deadlocks counter?

    Hi,

    we have encountered some deadlocks in the past, but solved them. The extended status of our Percona Server 5.5 shows:

    # mysqladmin extended-status |grep Innodb_deadlocks| Innodb_deadlocks | 11 |

    After sending the FLUSH STATUS command allmost all counters are resettet, but not the deadlock counter.

    Is there any way to reset this counter? We don't want to restart the master because of this problem.

    Thanks!

  • #2
    Hi,

    There are some status variables that can't be flushed Check this bug report opened 6 years ago:

    bugs.mysql.com/bug.php?id=22875

    The bug reports shows that Com_% can't be flushed but the problem also affects other variables like Innodb_deadlocks.

    The documentation says:

    "Some global variables may be reset to zero as well."

    _SOME_

    Regards.

    Comment

    Working...
    X