jignesh posted

MySQL Keeps Crashing

A Database Error Occurred

Error Number: 2006

MySQL server has gone away

SELECT * FROM `users` WHERE `id` = '2'

Filename: models/Auth_model.php

Line Number: 450

Edit Question

angeo
answered Feb 11 '22 00:00

first of all restart MySQL server


sudo mysqld restart

try to resize the allowed packet to 1 gb
--max-allowed-packet=1G

and try to resize the log file as well to 16 mb
--innodb-log-file-size=16M
run following code to terminal


sudo mysqld --innodb-log-file-size=16M --max-allowed-packet=1G

Edit Answer

serialize() vs json_encode()
What is the process to register a variable in PHP session?
Knet payment gateway integration Error in PHP
how to read file in chunk in PHP ?
what is alternative of eval function in php ?
How can I prevent SQL injection in PHP?

Post Answer

OMG! You need to Login / Register to Post Answer

[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic

jignesh posted

MySQL Keeps Crashing

angeo answered Feb 11 '22 00:00

Related Questions

Insert link

Insert image

angeo
answered Feb 11 '22 00:00