On 6/15/06, Lakshmi <[EMAIL PROTECTED]> wrote:
Hi, The aborted clients seems to be increasing than the connections made. Any solution???? Aborted_clients 67529 where as the connection made is 60462 .
A client is aborted after wait_timeout seconds of inactivity, but as your app seem to be working OK, the aborted_clients is increasing because you are not closing the connection properly after dealing with data with that connection. The low number of seconds explains why you have no trouble at all, because MySQL simply kills that connection after you use it and leave it there hanging. Try closing your connections after you've used them in a proper way (that depends on the language you're using for your frontend) and that number should not increase anymore. -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
