MySQL Forums
Forum List  »  InnoDB

innodb parition iops increase as partition grows
Posted by: Len Rugen
Date: June 01, 2018 08:05AM

This was prompted by a discussion on the #zabbix IRC channel, some of have had mysql iops grow during the day to a level that we couldn't support. I found that it was related to some particular tables that are partitioned by the timestamp of an event into 24 hour blocks. When a new day started IOPS was trivial, by 18:00, it was unsustainable. I just changed to partition every 4 hours, resulting in about a 4G partition size for the largest partitions. The IOPS still grow over the 4 hour interval, but not to a level that causes problems.

Our question, why would IOPS grow as the partition grows when the data rows written should remain fairly constant?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb parition iops increase as partition grows
77
June 01, 2018 08:05AM


Sorry, only registered users may post in this forum.

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.