Remove plugins-mysql_innodb from Munin if mysql has innodb_file_per_table=1
Open Discussion
With cPanel's default Munin configuration, it's not compatible with servers with large innodb databases.
Every time munin collect's its mysql data it runs :
- SELECT data_free FROM tables WHERE ENGINE = 'InnoDB' LIMIT 1
This query can take longer than Munin's default interval, if your total InnoDB databases are large you will have this query running multiple times making MySQL very slow and even crashing in some cases.
We had to manually delete /etc/munin/plugins/mysql_innodb and add a script to /post/upcp to make sure it stays deleted. /etc/munin/plugins/mysql_innodb is only needed if you don't have innodb_file_per_table=1 in your mysql config.
We request that cPanel either disables by default or gives us a supported way to disable it.
Doing this will also alleviate the need for the 10+ year workaround to ‘fix’ the ‘bad’ configuration that always throws a critical alert, "MySQL InnoDB free tablespace" upon the Munin service monitor installation.
Ref:
https://forums.cpanel.net/threads/munin-plugin-warn-mysql-innodb-free-tablespace.208591/post-2795493
Doing this will also alleviate the need for the 10+ year workaround to ‘fix’ the ‘bad’ configuration that always throws a critical alert, "MySQL InnoDB free tablespace" upon the Munin service monitor installation.
Ref:
https://forums.cpanel.net/threads/munin-plugin-warn-mysql-innodb-free-tablespace.208591/post-2795493
Replies have been locked on this page!