Truncate Databases

[FreddieAkeroyd]

In preparation for cycle we need to trim databases - instructions on how to contact scientists and do the truncation are at https://github.com/ISISComputingGroup/ibex_developers_manual/wiki/Database-Troubleshooting#reducing-database-disc-space

[isaachilly]

Instruments

Chosen based of if the inst is in or about to be in warning:

https://control-mon.isis.cclrc.ac.uk/nagios/cgi-bin/status.cgi?servicegroup=mysql_db&style=detail

Started:

• [x] chronus
• [x] detmon - not deliverable
• [x] imat - urgent
• [x] ines
• [x] inter
• [x] let - urgent
• [x] mari
• [x] merlin
• [x] muonfe
• [x] crisp
• [x] emu
• [x] alf
• [ ] emma-a
• [x] enginx - not deliverable
• [x] gem
• [ ] hifi-cryomag
• [x] hrpd
• [x] iris - urgent
• [x] larmor - urgent
• [x] loq
• [x] maps
• [x] mari
• [x] merlin
• [x] musr - urgent
• [ ] nimrod
• [x] offspec - urgent
• [x] osiris - urgent
• [ ] pearl
• [ ] polaris
• [ ] polref
• [x] rikenfe - urgent
• [x] sandals - urgent
• [x] sans2d - urgent
• [ ] softmat
• [x] tosca - urgent
• [ ] vesuvio
• [x] wish - urgent
• [x] zoom - urgent

Completed:

• [x] chronus
• [ ] detmon
• [x] imat
• [x] ines
• [x] inter
• [x] let
• [ ] mari
• [x] merlin
• [x] muonfe
• [x] crisp
• [x] emu
• [x] alf
• [ ] emma-a
• [ ] enginx
• [ ] gem
• [ ] hifi-cryomag
• [x] hrpd
• [x] iris
• [x] larmor
• [ ] loq
• [x] maps
• [ ] mari
• [x] merlin
• [x] musr
• [ ] nimrod
• [x] offspec
• [x] osiris
• [ ] pearl
• [ ] polaris
• [ ] polref
• [x] rikenfe
• [x] sandals
• [x] sans2d
• [ ] softmat
• [x] tosca
• [ ] vesuvio
• [x] wish
• [x] zoom

[rerpha]

all urgent done, isaac and i have made the executive decision to leave the rest as they aren't that big (biggest 8gb) and we have a maintenance day if needed to sort those ones out.

[rerpha]

to review check https://control-mon.isis.cclrc.ac.uk/nagios/cgi-bin/status.cgi?servicegroup=mysql_db&style=detail shows all OK