How to limit the range of an insert-update to only look at certain rows/ rows with field value: X?
Unfortunately, MySQL does not allow for filtered indexes (otherwise you can just filter on open tickets only). The next best thing is to do something similar to the two table approach you describe: Partitioned tables.