Re: About connection reuse (NEARLY MAD)

[Zhili Xu]

Hi Rick,

As I said in previous comment, the jdbc connecting functionality is programmed by other guys, so I don't know whether any SETs is done after connecting.

Only one point I can confirm is that some errors occur when closing connections. Because when I see the connection pool status in my application, allocated connections are shown as still in use, but on the MySQL side, they are shown as "sleep"(can be reuse?).

And in my last effort, I have removed(apt-get remove) the mysql server components and installed a downloaded version(Debian version), it worked and with no connecting problem. But unfortunately, after I purged(apt-get purge) the mysql-common(or anything related), the connecting problem appeared again.

So I think this should be a configuration problem. Maybe I have misconfigured some options.