Stop INNODB MONITOR OUTPUT

Question

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!

G-Nugget · Accepted Answer · 2017-08-08 23:12:58Z

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.

answered Aug 8, 2017 at 23:12

G-Nugget

6883 silver badges13 bronze badges

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

Add a comment |

1 Answer 1