This morning, after various WO apps were restarted overnight, there are zero 
CLOSE_WAITs on mysql, so I suspect there was a problem yesterday that may have 
cleared with an app restart. I will continue to monitor.

On 11 Mar 2014, at 18:47, John Pollard <j...@pollardweb.com> wrote:

> Hi List,
> 
> Using netstat -a | grep mysql, I see around 30 CLOSE_WAIT connections like 
> this:
> 
> tcp        1      0 localhost:50979             localhost:mysql             
> CLOSE_WAIT  
> tcp        1      0 localhost:47769             localhost:mysql             
> CLOSE_WAIT
> ...
> 
> I know that CLOSE_WAIT on the java apps are bad news, but is it normal for 
> mysql to be showing?
> 
> The counts are going down as well as up, so perhaps just normal operation?
> 
> Amazon Linux server, only WO apps using the database.
> 
> If this is an issue within particular WO apps issuing the sql requests, is 
> there a way to identify which apps are making the requests?
> 
> Thanks
> John
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-deploy mailing list      (Webobjects-deploy@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-deploy/jpollard%40inrax.com
> 
> This email sent to jpoll...@inrax.com


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list      (Webobjects-deploy@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to