Opened 10 years ago
Closed 10 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 10 years ago by adehnert
comment:2 Changed 10 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.
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).