MySQL Global Config

instruction.txt

/*
Notes:
execute the function twice to see if the variable values are changed or not.
I did not bother with creating additional foreach queries for before and after.
If you exceed either the minimum or maximum values the Min|Max value will be used instead of your value.

integer is in bytes: 1024 = 1KB | 1073741824 = 1GB

max_allowed_packet
Permitted Values Type integer
Default	4194304
Min Value 1024
Max Value 1073741824

integer is in seconds: 28800 = 480 minutes | 31536000 = 525600 minutes = 8760 hours
wait_timeout
Permitted Values (Windows) Type integer
Default	28800
Min Value 1
Max Value 2147483

Permitted Values (Other) Type integer
Default	28800
Min Value 1
Max Value 31536000
*/

> SET GLOBAL max_allowed_packet=524288000;
> SET GLOBAL wait_timeout=28800;
> SHOW VARIABLES LIKE 'parameter';