Scenario
--------

Let's say we need to store data in our database that is only relevant for a limited amount of time (e.g. user tokens). And after that time the data is completely irrelevant.

To make it a little bit more specific:

* The data itself is quite limited (couple of timestamps, short strings)
* The time is ~30 days
* There would be an index on another column than the primary key
* Every day there would be a couple of thousand new rows added
* InnoDB is the storage engine

Questions
---------

* What would be the preferred way to handle this scenario?
* Would it be ok to just delete old rows? Would this reclaim disk space?
* What about the index? Would the index need regular maintenance?

Thanks in advance!