Re: Too Many Connections-Not Reseting
Posted by: Tetsuro Ikeda
Date: May 31, 2005 10:37AM

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

Options: ReplyQuote

Written By
Re: Too Many Connections-Not Reseting
May 31, 2005 10:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.