Re: Too Many Connections-Not Reseting

[Tetsuro Ikeda]

Hi Jain,

Jain Jacob wrote:
> Hi,
>
> I am using MySql 4.0.20. Even if I closes the
> connection from my Java application using
> c.close(), the connections value in MYSql server
> is not getting updated. It is incrementing.
>
> Any soultion for updating this value.
> Thanks in advance
>
> Jain

What server variable did you see?

The variable "Connections" which you can get by "SHOW STATUS" is not
for current number of connections.

"Connections" means the total number which was attemped to connect server
and it is same to the most recent Thread ID.

And "Connections" is reset to zero when the server is rebooting.

The variable "Threads_connected"　is the current connections number
which youcan get by "SHOW STATUS".

You can also get information of current connections by using "SHOW PROCESSLIST"

Tetsuro IKEDA