How to release back my connection to the pool? about mysql HOT 3 CLOSED

The reason why this currently is not possible, is that you could have changed the internal state of the connection compared to pool. (e.g. have chosen another database or issued some SET commands).

I was probably overly cautious here and we really should add a way to allow that.

And no, the project is not inactive, it's just one of many amphp libs. We're always replying to issues and also fixing things as necessary.

from mysql.

For the state, I think programmer should handle it well. If we have changed the state, we should reset the state or close the connection but not release it back to the pool. It is hard for us to handle the state perfectly, we need programmer to take care of it.

from mysql.

Transactions should use a dedicated API, all other things shouldn't return connections to the pool, as we can't know the state of these connections and things are probably going to break in subtle ways, which is hard to debug then. I think transactions have been implemented now, otherwise #24 is the issue to track that.

from mysql.