1
Good morning. I use Mysql version 5.5.20 on WAMP server.
I have an SQL statement that needs a little more memory than is set by default, to return the data.
So I increased the value of max_allowed_packet for the size I need in my.ini, and restart the services.
I do that select to confirm the saved information: Select @@global.max_allowed_packet, all right.
But the other day the settings go back to what they were before.
Have you ever been through it or can you give me an idea of how to fix it.
Note: I have tried to set the global value in this way: set global max_allowed_packet = valor, but it is the same.
Thank you very much.
Do you need to edit my.ini every time after restarting your machine? If so, you do not have any Freeze configured?
– Giovanni Bernini
No, none. I edit my.ini and it turns out what I said on upstairs.
– Danniell
You said
"Mas no outro dia as configurações voltam ao que eram anteriormente."this only actually happens after 24 hours, or it is after an OS reboot?– Giovanni Bernini
After 24 hours, the server and MYSQL services were not restarted.
– Danniell