Deleting over a million old issues

Question

We have got approximately 3 million tickets and almost 5k tickets are being created daily.

Created a backup instance and also a snapshot of the instance.

Need a way to delete a million issues within a day or over 6k issues during 6 hours.

Already tried:

* Bulk Change: took almost 6 hours to delete 1k issues. Also, reduces performance.

** Mass Delete for Jira: took 24 hours to delete 2.5K

Ramin Ghanbari_32m6le · Answer

That sounds nice. Got the ScriptRunner.

Could you please help me with deleting issues matching something like this quary:  "updated <= -365d AND (status = Closed OR status = Resolved)"?

Nic Brough -Adaptavist- · Answer

Any method you use to do this properly is going to either be slow (because you throttle it) or cause performance reductions as it takes resources.

I would also try testing an external REST based script for speed and performance, and if you have ScriptRunner, that as well.  I once wrote a script that looped through issues I needed to delete with a 1 second delay between every other one.  This didn't cripple performance, but was able to delete 2000-2500 an hour.