New relic database check - % connections aborted

RESOLVED WONTFIX

Status

Data & BI Services Team
DB: MySQL
RESOLVED WONTFIX
5 years ago
4 years ago

People

(Reporter: cyborgshadow, Unassigned)

Tracking

Details

(Reporter)

Description

5 years ago
This bug is to add a custom new relic database monitor for % connections aborted.

This can be accomplished with the below sql:

select gs1.variable_value/gs2.variable_value from information_schema.global_status gs1, information_schema.global_status gs2 where gs1.variable_name = 'Aborted_connects' and gs2.variable_name = 'Connections';

When the module is updated to allow custom sql, I will add this.
(Reporter)

Comment 1

5 years ago
Missed the conversion to percentage (*100). Added it:

select (gs1.variable_value/gs2.variable_value)*100 from information_schema.global_status gs1, information_schema.global_status gs2 where gs1.variable_name = 'Aborted_connects' and gs2.variable_name = 'Connections';
(Reporter)

Updated

5 years ago
Assignee: server-ops-database → bjohnson
Product: mozilla.org → Data & BI Services Team
Assignee: bjohnson → server-ops-database
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.