Try to partition the data by making the value of "time" part of the table name and dropping the tables as they become old. InnoDB is slow at deleting records if there are many secondary indexes. For inserting to secondary indexes, the insert buffer makes access more sequential. There is no such buffering for deletes. However, DROP TABLE is a very fast operation.
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --