MySQL/MariaDB related:
wait_timeout
– Time in seconds that the server waits for a connection to become active before closing it.interactive_timeout
– Time in seconds that the server waits for an interactive connection.max_allowed_packet
– Maximum size in bytes of a packet or a generated/intermediate string. Set as large as the largest BLOB, in multiples of 1024.
Example of my.cnf:
[mysqld]
# 8 hours
wait_timeout = 28800
# 8 hours
interactive_timeout = 28800
max_allowed_packet = 256M
If you are using xampp server :
Go to xampp -> mysql -> bin -> my.ini
Change below parameter :
max_allowed_packet = 500M
innodb_log_file_size = 128M