MySQL Archive table: improvements to truncation processes - Githubissues

ISISComputingGroup / IBEX

Top level repository for IBEX stories

4 stars 2 forks source link

MySQL Archive table: improvements to truncation processes #8365

Open GRyall opened 1 month ago

GRyall commented 1 month ago

As a systems administrator, I would like to reduce the overheads involved in truncating the MySQL archive table.

Acceptance Criteria

[ ] There exists a script that can truncate the archive table on all instruments (by the same process as the existing truncation script).
[ ] There is an agreed, and documented, process for notifying scientists of when this script will run (usually preceding a new cycle)

Extra Information

This ticket is a result of the discussion that took place as part of #8321 .

See also: developer wiki page.

How to Test

verbose instructions for reviewer to test changes (Add before making a PR)