Page MenuHomeMiraheze

Have a way to monitor open connections / usage to a Database
Closed, DeclinedPublic

Description

During a wiki rename (or anything when we drop the database), we should monitor the database so that we know all activity on it has stopped.

Event Timeline

RhinosF1 created this task.
Unknown Object (User) moved this task from Backlog to Long Term on the MediaWiki (SRE) board.Jun 25 2021, 18:40
Reception123 removed a subscriber: Unknown Object (User).Aug 24 2021, 19:05
Unknown Object (User) added a comment.Oct 17 2021, 19:19

Do you mean like connections to a specific wiki database, or a database server?

Unknown Object (User) subscribed.Oct 17 2021, 19:19

Do you mean like connections to a specific wiki database, or a database server?

Specfic database. Mainly to warn if we have any issue simmilar to WikiBase client and some query is still running on the database.

Unknown Object (User) added a comment.Oct 17 2021, 19:51

Do you mean like connections to a specific wiki database, or a database server?

Specfic database

How do you purpose we do that? Any graph or table in Grafana would be to large as we can't do such specific logging there, I'm not sure how we'd do this. Unless you have thoughts for monitoring elsewhere, besides Grafana?

Probably some sort of select on PROCESSLIST

Unknown Object (User) added a comment.Jan 21 2022, 21:39

Probably some sort of select on PROCESSLIST

This then?

Probably some sort of select on PROCESSLIST

This then?

It does the same thing but the whole thing was to warn during a wiki rename. I'm not sure that would do that.

Unknown Object (User) added a comment.Jan 21 2022, 21:50

Probably some sort of select on PROCESSLIST

This then?

It does the same thing but the whole thing was to warn during a wiki rename. I'm not sure that would do that.

When have renames caused issues?

One with WikiBase repo set on other wikis to that wiki

Unknown Object (User) added a comment.Jan 21 2022, 22:13

One with WikiBase repo set on other wikis to that wiki

That shouldn't happen anymore though, I fixed that.

Unknown Object (User) closed this task as Invalid.Jan 21 2022, 23:20
Unknown Object (User) claimed this task.

Since the only reason for this task should no longer be occurring, I'm going to go ahead and close this as invalid (since no actions for it were taken). If I'm incorrect in assuming the only reason for this task was for this, then I apologise and please reopen.

If there isn't any other known issues besides the wikibase one, since fixed, then I don't think this should be reopened and attempted, unless we have a valid use-case and need to do so. However if we do have one, once again I apologise and please reopen.

Unknown Object (User) changed the task status from Invalid to Declined.Jan 21 2022, 23:21
Unknown Object (User) moved this task from Unsorted to Long Term on the Universal Omega board.

On second thought this can be declined since it was originally valid.