title: MySQL Partitioning on a small table with potential to grow
body: <p>I have few tables on which I have been asked to perform partitioning. The tables contain less than a 100000 records. There is no requirement to partition it based on time. Partitioning needs to be done on active or inactive records.</p>
  
  <p>The intention is to perform analysis on inactive records after a while.  And the active records are used for reporting.</p>
  
  <p>The growth rate of the tables is slow.</p>
  
  <p>So, in this case is partitioning still a solution to fetch active and inactive records efficiently?</p>
  
  <p>THanks in advance</p>