MySQL Forums
Forum List  »  Partitioning

Re: Thoughts on partitioning by hour - and which partition type?
Posted by: Adrian Snow
Date: June 04, 2008 04:15PM


One slight issue that has just cropped up.
Due to the poor performance of counting rows on an InnoDB table, I was maintining row counts in a separate table using triggers on the insert and deletion of records in the events table. The counts are based upon site_id.

Obviously dropping a partition doesn't cause the triggers to fire, so I guess that when I archive an existing partition I'm going to have to perform some counts in order to update my counts table before dropping the partition.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.