Mysql has gone away error randomly

Asked Jun 05 '19 at 14:27

Active Jun 06 '19 at 10:09

Viewed 219 times

I have a web application written in php. In this app, I have a script(CLI) which is really heavy. After this script finishes its job, I get "mysql has gone away" error in my normal http request for a few minutes. For example, Last time my script finished its job around 22:38 and I was getting "mysql has gone away" for next 3 minutes.

This is the connections to mysql server(Mysql data):

And connections to mysql(using something like netstat):

P.S: most of http request manage to open connection to mysql without any problems.

P.S: After a few minutes, I stop getting this error(22:42 in the chart). P.S: I get this error when opening a connection using php's PDO or when I want to execute a statement.

P.S: CPU usage is quite normal

edited Jun 06 '19 at 08:38

asked Jun 05 '19 at 14:27

undone

Did you check the manual? https://dev.mysql.com/doc/refman/8.0/en/gone-away.html – oxr463 Jun 05 '19 at 15:00
@LucasRamage Yes I have – undone Jun 05 '19 at 17:39
You need to provide relevant information, then. Just saying you read the manual is not sufficient. – Michael Hampton Jun 05 '19 at 17:47
This can happen if a query choke your mysql (cpu or the disk). Please include a CPU chart & IO latency chart for the server, it might answer your question. – yagmoth555 Jun 05 '19 at 17:50
I suggest to ask rather "how to debug it". – peterh Jun 05 '19 at 18:12
@peterh I'm checking whether I can provide those charts I was asked for – undone Jun 05 '19 at 18:23
1

@yagmoth555 I added those charts. – undone Jun 06 '19 at 08:38

Mysql has gone away error randomly

0 Answers0