Opened 8 years ago

Closed 8 years ago

#328 closed enhancement (fixed)

Monitor used connections on sql.mit.edu

Reported by: adehnert Owned by:
Priority: normal Milestone:
Component: sql Keywords:
Cc:

Description

Now that #327 is fixed, we're somewhat less likely to notice when one user (probably hacked or DoSed?) is using a ton of connections. We should add monitoring of used connections, either max connections per user or total connections.

The check_mysql_query plugin in combination with the PROCESSLIST table in the information_schema database may be useful.

Change History (2)

comment:1 Changed 8 years ago by adehnert

The sql side has been fixed for a while. /mit/adehnert/Public/sipb/sipb-nagios.git branch sql-connections has a sipb-nagios side fix (which was emailed to sipb-nagios@, scripts-team@, and sql-team@ a while ago).

comment:2 Changed 8 years ago by quentin

  • Resolution set to fixed
  • Status changed from new to closed

Changes deployed. (Not sure why this is really necessary when we're tracking this in Munin, too.)

Note: See TracTickets for help on using tickets.