MySql/MariaDB: innodb_status_output is turned on automatically

How do I determine what's causing innodb_status_output to be turned on automatically by MariaDB? I'm running Galera on a 3 node cluster on CentOS.

Thanks,
-Keith

2 Replies

I'm not 100% sure this will solve it for you, but I did some digging around online and it could be that all you need to do is run the following:

set global innodb_status_output=OFF

I found that in MariaDB's doc, which I'll link you below:

InnoDB status monitor gets enabled after server startup

Let me know if that works for you.

Thanks, rgerke. I appreciate the help. That command will turn off the monitor, but it will be turned back on automatically under certain conditions, as listed here: https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting.html

  • A long semaphore wait
  • InnoDB cannot find free blocks in the buffer pool
  • Over 67% of the buffer pool is occupied by lock heaps or the adaptive hash index

Best regards,
Keith

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct