blocking on get data with pdo from db about swoole-src HOT 5 CLOSED

Do you instantiate a new database connection for each request or do you retrieve it from a database connection pool?
If you are retrieving the database connection from a connection pool, you may need to attempt a reconnection when disconnected.

from swoole-src.

Do you instantiate a new database connection for each request or do you retrieve it from a database connection pool? If you are retrieving the database connection from a connection pool, you may need to attempt a reconnection when disconnected.

i use separate pdo connection in each Coroutine
i think some function like ksort , sort or fetch big data from mysql blocked whole my file

from swoole-src.

when my query have more than 30000 result mysql say PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

my time_wait and other config on mysql is set but we get error on this step i think when we use fetchAll or foreach or some other function that take long time whole of our Coroutine blocked for that process is it true? if it is true how can we fix this problem?

It sounds like you need to increase "max_allowed_packet" in your mysql config my.ini

from swoole-src.

Try to reconnect to the database.
reference

1. #4131 (comment)
2. #2041
3. https://github.com/swoole/swoole-wiki/blob/master/doc/15.11%20-%20MySQL%E7%9A%84%E8%BF%9E%E6%8E%A5%E6%B1%A0%E3%80%81%E5%BC%82%E6%AD%A5%E3%80%81%E6%96%AD%E7%BA%BF%E9%87%8D%E8%BF%9E.md
4. #4141
5. #5143

最佳的方案是进行断线重连

from swoole-src.

You should catch this exception and reconnect to the MySQL server after disconnection.

from swoole-src.