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

= operator with comparision in mysql ,means not exact match
how to get extension from the filename in PHP ?
what is differnce between exec() and system() and passthru() in PHP
How to post message to Google Plus By Api
Array to String PHP?
how to use strpos to find macth for string 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