3

I use MariaDB galera cluster 10.0.31 with 3 nodes.

In one node when I tail -f err log to monitor server, Every 20 seconds MySQL dumping Show InnoDB Status to err log, and the log are getting bigger.

I don't know Which variable cause to dump output Innodb status to Err log file!

1 Answer 1

4

The variable you're looking for is innodb_status_output. Setting it to OFF should stop the innodb status from being dumped into the error log.

2
  • Thank you. I think in certain conditions Galera Cluster Enable this variable automatically but I don't sure
    – HamoonDBA
    Aug 9, 2017 at 4:39
  • InnoDB status will be automatically dumped to the logs in some conditions, for example when you have abnormal locks.
    – tanji
    Aug 9, 2017 at 11:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.