max_allowed_packet value causes starting forever

[Daniel Politeski]

Hi all,

I am trying to get mySQL to run when max_allowed_packet=30M within the my.ini file.

With default of 4M the server starts fine.

When set to 30M which is the requirement for software that I am testing with, it just stays in starting state within Windows Services.

I can't ever seem to find out what could be causing this behaviour, no forums seem to have much detail about it.

It is in the documentation for the product I am testing to set max_allowed_packet to 30M, so I am quite sure it can work.

I have tried a 16Gb and 32Gb Windows 2016 and 2012R2 machine and they all get stuck on starting.

If 30M = megabytes, it isn't a lot of storage so not sure why 4M works and 30M causes issues.

Anyone that can fill me in, much appreciated.

Thanks,
Dan.