MySQL - Max Allowed Packets

[andyb4u]

I'm currently working on a project where we went from an old version of XI with postgres; converted postgres to MySQL as per the steps in https://support.nagios.com/kb/article.php?id=560and then offloaded MySQL as per the steps in https://support.nagios.com/kb/article.php?id=263.

In the steps to convert postgres to MySQL it mentions the setting max_allowed_packet=512M in/etc/my.cnf.

My question is - should I be adding this max_allowed_packet parameter to our offloaded MySQL server? I think on a clean build of XI on a single server this isn't set.

Regards,
Andy

[bolson]

Yes, the max_allowed_packet directive determines the largest query sent to the server, the largest result set returned from the server, or the largest log event sent to system logging. The default if not set is 16M which is far too small to accommodate insert statements sent from Nagios and result sets returned to Nagios. The recommended value for a local or offloaded database server is 512M. Does this answer your question and may we close this topic?

[andyb4u]

Thanks very much for that info. That answers my question and I'm happy for the topic to be closed.

[kyang]

Sounds good! I'll be closing this thread!

If you have any more questions, feel free to create another thread.

Thanks for using the Nagios Support Forum!