ideal is probably the wrong word. I guess the 'minimum' is what we are looking for. Ideally, the event_expiry=1 so they are expired right after SELECT-ing them. However, you may have several queries referencing an event table, you have to consider their intervals, and how long the queries take, and the 'events_optimize' behavior.