lideming

More information is needed. What are the value of MySQL server `wait_timeout` and the deno_mysql `idleTimeout` option? Does deno_mysql connect to a remote MySQL server or a localhost one? If...

So I think there is some network problem between the client and the server. You can set `idleTimeout` to `300000` (5 minutes) and see if the problem still persists. I...

Seems that there is no heartbeat in the protocol of MySQL. Maybe using `idleTimeout` is the correct way.

@BayoKwendo Is there "connection idle timeout" before "connection closed"?

Hi, could you please put some code here that can reproduce the problem?

The driver currently doesn't support [Authentication Method Mismatch](https://dev.mysql.com/doc/dev/mysql-server/8.0.12/page_protocol_connection_phase.html#sect_protocol_connection_phase_auth_method_mismatch). We need to implement it to fix the problem.

@ajasinski77 Thanks for reporting. 1. Which deno_mysql version did you used? 2. How frequently did the problem occur? 3. We have fixed some connection bugs recently. Could you try the...

@ajasinski77 Please try the latest commit I mentioned above. We have some unreleased fixes since v2.5.0. Hope there is the fix you need.

@TradeIdeasPhilip > All of my queries complete. However, the program never exits. It hangs in `function handleTimerMacrotask()` in 11_timers.js. An unclosed client with idle connections will prevent Deno from automatically...

Because [node-mysql2](https://github.com/sidorares/node-mysql2) is "with focus on performance" (as first sentence in its readme). It [generates JS code per query at runtime](https://github.com/sidorares/node-mysql2/blob/6fae0c20e7459b2dee6439a2cd2beab0c45ab08d/lib/parsers/text_parser.js#L72-L196) for parser performance. So it's no surprise that deno-mysql...