db2088 filling up
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Marostegui
	Apr 21 2022, 11:08 AM

Description

This multi-instance host (which is scheduled for a refresh: T297646 is filling up:

root@db2088:/srv# df -hT /srv
Filesystem            Type  Size  Used Avail Use% Mounted on
/dev/mapper/tank-data xfs   3.6T  3.3T  307G  92% /srv

Probably re-running an optimize and/or checking if all the tables are compressed would help and might be enough until the host can be replaced.

	Subject	Repo	Branch	Lines +/-
	db2088: Disable notifications	operations/puppet	production	+1 -0

Marostegui triaged this task as High priority.Apr 21 2022, 11:08 AM

Marostegui moved this task from Triage to Ready on the DBA board.

Change 785133 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db2088: Disable notifications

Mentioned in SAL (#wikimedia-operations) [2022-04-21T11:13:35Z] <marostegui> dbmaint s2@codfw T306604

I am compressing s2

Marostegui moved this task from Ready to In progress on the DBA board.

Change 785133 merged by Marostegui:

[operations/puppet@production] db2088: Disable notifications

It has s1 and s2 and in a week or two we will drop a couple hundred gigabytes from each one (rev_actor_temp tables). Would that help?

That will help for sure, but for now we are good with the compression:

root@db2088:~# df -hT /srv
Filesystem            Type  Size  Used Avail Use% Mounted on
/dev/mapper/tank-data xfs   3.6T  2.5T  1.2T  69% /srv