Determining Max_Allowed_Packet setting for MySQL
Posted on 2011-10-15
I'm trying to mitigate a potential risk where my hosting server reboots, and the MySQL service is restarted and the default Max_Allowed_Packet setting is not increased to allow my software to handle large enough documents.
Without changing this setting, the application fails to load new documents, or correctly create the historical copy when a new revision is released.
I tried putting the command line in the My.ini file of max_allowed_packet = 10485760000; and rebooting the server, but the MySQL service didn't restart automatically so I had to start it using the MySQL Configuration Tool that rewrites the my.ini file.
I can manually change the setting by entering SET GLOBAL max_allowed_packet = 10485760000; at the mysql command prompt through Navicat (MySQL editing tool), and then everything works as it should.
I either need to figure out how to make sure this setting is applied at the virtual server in case the data center has to recreate my server instance, or access this setting through VBA in my application and write in some code that checks for the proper setting before allowing the user to release a document.
I tried to hunt for that setting in the registry, but I don't think MySQL stores that setting there.
Anyone have any ideas how I should handle this?