Slow requests and poor availability

[AFRC]

Hi,

I'm experiencing some issues regarding connectivity.
I have new relic for monitoring and i'm getting poor results on some pings.

Globally the server performs well. It has only one site and the app performance is good.

I think these slow requests are on the connectivity and usually happen late in night (~3am).
During the day when the server has the highest load we rarely experience this.



Usually these requests take 600 to 900ms.
Backups are scheduled to 5am, so it is not related.

Thanks.

 

[abdi]

I have come to realise that MySQL has away of increasing ping response times on a server ...
This also be a result of slow queries, huge tables and lots more ...Normally I use mytop to monitor the MySQL queries and activities to give me an indea of what could be causing the same ..Give it a try, you might get an idea of the cause.

 

[AFRC]

Thanks for your feedback.
We currently dont have any issues with mysql. No slow queries. Database is performing really well: under 40ms

 

[AFRC]

It seems some it's some kind of routine that trigger services to restart.
We have pingers running every minute and sometimes the pingers catch these small downtimes. At least it's my suspicion

Is there any way to trace this?

Thanks.