Otdfbt

Why does Linux list NVMe drives as /dev/nvme0 instead of /dev/sda?

Are all instances of trolls turning to stone ultimately references back to Tolkien?

When to remove insignificant variables?

When two first person POV characters meet

Interaction between Leyline of Anticipation and Teferi, Time Raveler

How do I handle a table mixing up the DM and the players' roles too often?

What does "play with your toy’s toys" mean?

Is this proposal by U.S. presidential candidate Pete Buttigieg to change the composition of the Supreme Court constitutional?

Count All Possible Unique Combinations of Letters in a Word

What's currently blocking the construction of the wall between Mexico and the US?

How does DC work with natural 20?

What is "industrial ethernet"?

How to remove this component from PCB

What does the hyphen "-" mean in "tar xzf -"?

Are birchat hoda'ah on the idea or the thing?

Greeting with "Ho"

How do I professionally let my manager know I'll quit over smoking in the office?

Why is it recommended to mix yogurt starter with a small amount of milk before adding to the entire batch?

Why does the Saturn V have standalone inter-stage rings?

What was the Shuttle Carrier Aircraft escape tunnel?

Are springs compressed by energy, or by momentum?

Trainee keeps missing deadlines for independent learning

How can I politely work my way around not liking coffee or beer when it comes to professional networking?

If I wouldn't want to read the story, is writing it still a good idea?

Mysql has gone away error randomly

Fixing “MySQL server has gone away” errorpython mysqldb - mysql server gone away - can't reconnectIntermintent slow MySQL ConnectionsMySQL not accepting connections from WPMySQL lowering wait_timeout value to lower number of open connectionsError 2006: MySQL server has gone away'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'2006: MySQL server has gone awayMySql Clients connection timeout randomlyHow to fix mysql has gone away, high writeiops, switch to postgres?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

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

mysql php tcp connection pdo

share|improve this question

edited Jun 6 at 8:38

undone

asked Jun 5 at 14:27

undoneundone

142117

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you check the manual? dev.mysql.com/doc/refman/8.0/en/gone-away.html
  
  – Lucas Ramage
  Jun 5 at 15:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LucasRamage Yes I have
  
  – undone
  Jun 5 at 17:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You need to provide relevant information, then. Just saying you read the manual is not sufficient.
  
  – Michael Hampton♦
  Jun 5 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 5 at 17:50
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @yagmoth555 I added those charts.
  
  – undone
  Jun 6 at 8:38
  

  
  
  
  

 | 
show 2 more comments

1

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

mysql php tcp connection pdo

share|improve this question

edited Jun 6 at 8:38

undone

asked Jun 5 at 14:27

undoneundone

142117

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you check the manual? dev.mysql.com/doc/refman/8.0/en/gone-away.html
  
  – Lucas Ramage
  Jun 5 at 15:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @LucasRamage Yes I have
  
  – undone
  Jun 5 at 17:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You need to provide relevant information, then. Just saying you read the manual is not sufficient.
  
  – Michael Hampton♦
  Jun 5 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 5 at 17:50
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @yagmoth555 I added those charts.
  
  – undone
  Jun 6 at 8:38
  

  
  
  
  

 | 
show 2 more comments

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

mysql php tcp connection pdo

share|improve this question

edited Jun 6 at 8:38

undone

asked Jun 5 at 14:27

undoneundone

142117

share|improve this question

edited Jun 6 at 8:38

undone

asked Jun 5 at 14:27

undoneundone

142117

share|improve this question

edited Jun 6 at 8:38

undone

asked Jun 5 at 14:27

undoneundone

142117

asked Jun 5 at 14:27

undoneundone

142117

asked Jun 5 at 14:27

undoneundone

142117