MySQL 5.1 Partitioning Example for Ruby on Rails Migration

1. Creating table on mysql prompt : (separating partitions by 6 months each)
   
   


2. In the migration file 001_create_stats.rb:
   
   
   
   


3. After running rake db:migrate. On MySQL prompt, single partition being used in this example
   
   




4. On MySQL prompt, two partitions being used in this example:
   
   




5. On MySQL prompt, the default storage engine type is shown as InnoDB: