Requirements:

A) Master is using based row replication.

Procedure:

1) Create a partitioned and large table in MySQL 5.6, for example:

CREATE TABLE `large_table` (
  `sid` bigint(20) NOT NULL AUTO_INCREMENT,
  `id` bigint(20) NOT NULL,
  `version` bigint(20) NOT NULL DEFAULT '0',
  `accrued_interest` decimal(25,13) DEFAULT NULL,
  `accumulated_interest` decimal(25,13) DEFAULT NULL,
  `amount` decimal(25,13) DEFAULT NULL,
  `apr360` decimal(25,13) DEFAULT NULL,
  `apr` decimal(25,13) DEFAULT NULL,
  `as_of_date` datetime DEFAULT NULL,
  `average_days_delinquent` float DEFAULT '0',
  `balance` decimal(25,13) DEFAULT NULL,
  `charged_off_balance` decimal(25,13) DEFAULT NULL,
  `charged_off_by_id` int(11) NOT NULL DEFAULT '0',
  `charged_off_date` datetime DEFAULT NULL,
  `charged_off_fees` decimal(25,13) DEFAULT NULL,
  `charged_off_interest` decimal(25,13) DEFAULT NULL,
  `charged_off_principal` decimal(25,13) DEFAULT NULL,
  `collateral_number` varchar(255) DEFAULT NULL,
  `creator_id` int(11) NOT NULL DEFAULT '0',
  `credit_line_offset` int(11) NOT NULL DEFAULT '0',
  `credit_line_strategy` varchar(255) DEFAULT NULL,
  `daily_rate` decimal(25,13) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `days_delinquent` int(11) NOT NULL DEFAULT '0',
  `disbursement_date` datetime DEFAULT NULL,
  `fees_due` decimal(25,13) DEFAULT NULL,
  `first_payment_amount_override` decimal(25,13) DEFAULT NULL,
  `first_payment_amount` decimal(25,13) DEFAULT NULL,
  `first_payment_date_override` datetime DEFAULT NULL,
  `first_payment_date` datetime DEFAULT NULL,
  `interest_due` decimal(25,13) DEFAULT NULL,
  `last_full_payment_date` datetime DEFAULT NULL,
  `last_paycheck_date` datetime DEFAULT NULL,
  `last_payment_date` datetime DEFAULT NULL,
  `last_payment_event_date` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `late_date` datetime DEFAULT NULL,
  `loan_amount` decimal(25,13) DEFAULT NULL,
  `loan_rules` varchar(255) DEFAULT NULL,
  `max_days_delinquent` int(11) NOT NULL DEFAULT '0',
  `migrated` bit(1) NOT NULL DEFAULT b'0',
  `minimum_payment_to_rollback_delinquency119` decimal(25,13) DEFAULT NULL,
  `minimum_payment_to_rollback_delinquency29` decimal(25,13) DEFAULT NULL,
  `minimum_payment_to_rollback_delinquency59` decimal(25,13) DEFAULT NULL,
  `minimum_payment_to_rollback_delinquency89` decimal(25,13) DEFAULT NULL,
  `monthly_rate` decimal(25,13) DEFAULT NULL,
  `months` int(11) NOT NULL DEFAULT '0',
  `actual_months` int(11) DEFAULT '0',
  `next_late_fee_date` datetime DEFAULT NULL,
  `next_minimum_payment_to_rollback_delinquency119` decimal(25,13) DEFAULT NULL,
  `next_minimum_payment_to_rollback_delinquency29` decimal(25,13) DEFAULT NULL,
  `next_minimum_payment_to_rollback_delinquency59` decimal(25,13) DEFAULT NULL,
  `next_minimum_payment_to_rollback_delinquency89` decimal(25,13) DEFAULT NULL,
  `next_payment_due_date` datetime DEFAULT NULL,
  `number_of_payments` int(11) NOT NULL DEFAULT '0',
  `origination_fee` decimal(25,13) DEFAULT NULL,
  `paid_date` datetime DEFAULT NULL,
  `payment_amount_override` decimal(25,13) DEFAULT NULL,
  `payment_amount` decimal(25,13) DEFAULT NULL,
  `payment_day` int(11) NOT NULL DEFAULT '0',
  `payment_day2` int(11) NOT NULL DEFAULT '0',
  `payment_frequency` int(11) DEFAULT NULL,
  `payment_period` int(11) NOT NULL DEFAULT '0',
  `periodic_rate` decimal(25,13) DEFAULT NULL,
  `pf_loan` bigint(20) NOT NULL DEFAULT '0',
  `pool_no` varchar(255) DEFAULT NULL,
  `principal_due` decimal(25,13) DEFAULT NULL,
  `qb_client_id` bigint(20) NOT NULL DEFAULT '0',
  `qb_loan_id` bigint(20) NOT NULL DEFAULT '0',
  `real_apr` decimal(25,13) DEFAULT NULL,
  `rewritten_date` datetime DEFAULT NULL,
  `rewritten_loan_id` bigint(20) NOT NULL DEFAULT '0',
  `sip_client_id` bigint(20) NOT NULL DEFAULT '0',
  `sip_loan_id` bigint(20) NOT NULL DEFAULT '0',
  `snapshot_date` datetime NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `stop_credit_reporting` bit(1) NOT NULL DEFAULT b'0',
  `store_id` int(11) NOT NULL DEFAULT '0',
  `sub_pool_no` varchar(255) DEFAULT NULL,
  `total_accrued_interest` decimal(25,13) DEFAULT NULL,
  `total_additional_payments` int(11) NOT NULL DEFAULT '0',
  `total_charged_late_fees` decimal(25,13) DEFAULT NULL,
  `total_extra_interest` decimal(25,13) DEFAULT NULL,
  `total_extra_principal` decimal(25,13) DEFAULT NULL,
  `total_fees` decimal(25,13) DEFAULT NULL,
  `total_paid_amount` decimal(25,13) DEFAULT NULL,
  `total_paid_fees` decimal(25,13) DEFAULT NULL,
  `total_paid_installments_amount` decimal(25,13) DEFAULT NULL,
  `total_paid_interest` decimal(25,13) DEFAULT NULL,
  `total_paid_principal` decimal(25,13) DEFAULT NULL,
  `total_payment_due` decimal(25,13) DEFAULT NULL,
  `total_payment_overdue` decimal(25,13) DEFAULT NULL,
  `updater_id` int(11) NOT NULL DEFAULT '0',
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `first_full_payment_date` datetime DEFAULT NULL,
  `final_scheduled_payment_date` datetime DEFAULT NULL,
  `actual_interest` decimal(25,13) DEFAULT '0.0000000000000',
  `scheduled_principal_due` decimal(25,13) DEFAULT '0.0000000000000',
  `expected_accrued_interest` decimal(25,13) DEFAULT '0.0000000000000',
  `payoff_amount` decimal(25,13) DEFAULT '0.0000000000000',
  `origination_fees_due` decimal(25,13) DEFAULT '0.0000000000000',
  `collateral_no` int(11) NOT NULL DEFAULT '0',
  `previous_late_fee_date1` datetime DEFAULT NULL,
  `previous_late_fee_date2` datetime DEFAULT NULL,
  `delinquency_date` datetime DEFAULT NULL,
  `total_number_of_payments` int(11) DEFAULT '0',
  `refinanced_loan_id` bigint(20) NOT NULL DEFAULT '0',
  `refinanced_date` datetime DEFAULT NULL,
  `effective_through` date NOT NULL DEFAULT '0000-00-00',
  `prior` bigint(20) DEFAULT NULL,
  `starting_receivables` decimal(25,13) DEFAULT '0.0000000000000',
  `ending_receivables` decimal(25,13) DEFAULT '0.0000000000000',
  `renewal` int(2) NOT NULL DEFAULT '0',
  `refinance_ind` int(2) NOT NULL DEFAULT '0',
  `product_type` varchar(45) NOT NULL DEFAULT 'CONSUMER_INSTALLMENT_LOAN',
  `channel_id` int(11) DEFAULT NULL,
  `merchant_normal` int(2) NOT NULL DEFAULT '0',
  `merchant_adjust` int(2) NOT NULL DEFAULT '0',
  `payoff_balance_diff` decimal(25,13) DEFAULT '0.0000000000000',
  `eligible_for_pledge_bond_2013` int(2) NOT NULL DEFAULT '0',
  `eligible_for_pledge_bond_2014` int(2) NOT NULL DEFAULT '0',
  `pledged` int(2) NOT NULL DEFAULT '0',
  `pledged_to` varchar(255) DEFAULT NULL,
  `pledge_date` date DEFAULT NULL,
  `pledged_amount` decimal(25,13) DEFAULT '0.0000000000000',
  `auto_pledged_rw` int(2) DEFAULT '0',
  `ck_app_score` int(11) DEFAULT NULL,
  `pf_score` int(11) DEFAULT NULL,
  `rationalized_pf_score` int(11) DEFAULT NULL,
  `vantage_score` int(11) DEFAULT NULL,
  `payments` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `interest_billed` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `fees_billed` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `gross_charge_off` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `transfers_rewrite` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `overpaid_principal` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `retail_installment_adj` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `misc_adjustment` decimal(25,13) NOT NULL DEFAULT '0.0000000000000',
  `remaining_months` int(11) NOT NULL,
  `funding_months` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`,`effective_through`),
  UNIQUE KEY `loan_summ_detail_id_fact_date_idx` (`id`,`effective_through`),
  KEY `loan_summ_detail_fact_date_id_idx` (`effective_through`,`id`),
  KEY `loan_summ_detail_pf_loan_date_idx` (`pf_loan`,`effective_through`),
  KEY `loan_summ_detail_fact_date_sip_loan_id_pf_loan_idx` (`effective_through`,`sip_loan_id`,`pf_loan`),
  KEY `loan_summ_detail_pledging_idx` (`pledge_date`,`pledged_to`),
  KEY `loan_summ_detail_fact_date_pledged_to_idx` (`effective_through`,`pledged_to`),
  KEY `loan_summ_detail_fact_date_sip_client_id_pf_loan_idx` (`effective_through`,`sip_client_id`,`pf_loan`),
  KEY `loan_summ_detail_prior_ref` (`prior`)
) ENGINE=InnoDB AUTO_INCREMENT=1197238680 DEFAULT CHARSET=utf8
PARTITION BY RANGE  COLUMNS(effective_through)
(PARTITION p20150325 VALUES LESS THAN ('2015-03-26') ENGINE = InnoDB,
 PARTITION p20150326 VALUES LESS THAN ('2015-03-27') ENGINE = InnoDB,
 PARTITION p20150327 VALUES LESS THAN ('2015-03-28') ENGINE = InnoDB,
 PARTITION p20150328 VALUES LESS THAN ('2015-03-29') ENGINE = InnoDB,
 PARTITION p20150329 VALUES LESS THAN ('2015-03-30') ENGINE = InnoDB,
 PARTITION p20150330 VALUES LESS THAN ('2015-03-31') ENGINE = InnoDB,
 PARTITION p20150331 VALUES LESS THAN ('2015-04-01') ENGINE = InnoDB,
 PARTITION p20150401 VALUES LESS THAN ('2015-04-02') ENGINE = InnoDB,
 PARTITION p20150402 VALUES LESS THAN ('2015-04-03') ENGINE = InnoDB,
 PARTITION p20150403 VALUES LESS THAN ('2015-04-04') ENGINE = InnoDB,
 PARTITION p20150404 VALUES LESS THAN ('2015-04-05') ENGINE = InnoDB,
 PARTITION p20150405 VALUES LESS THAN ('2015-04-06') ENGINE = InnoDB,
 PARTITION p20150406 VALUES LESS THAN ('2015-04-07') ENGINE = InnoDB,
 PARTITION p20150407 VALUES LESS THAN ('2015-04-08') ENGINE = InnoDB,
 PARTITION p20150408 VALUES LESS THAN ('2015-04-09') ENGINE = InnoDB,
 PARTITION p20150409 VALUES LESS THAN ('2015-04-10') ENGINE = InnoDB,
 PARTITION p20150410 VALUES LESS THAN ('2015-04-11') ENGINE = InnoDB,
 PARTITION p20150411 VALUES LESS THAN ('2015-04-12') ENGINE = InnoDB,
 PARTITION p20150412 VALUES LESS THAN ('2015-04-13') ENGINE = InnoDB,
 PARTITION p20150413 VALUES LESS THAN ('2015-04-14') ENGINE = InnoDB,
 PARTITION p20150414 VALUES LESS THAN ('2015-04-15') ENGINE = InnoDB,
 PARTITION p20150415 VALUES LESS THAN ('2015-04-16') ENGINE = InnoDB,
 PARTITION p20150416 VALUES LESS THAN ('2015-04-17') ENGINE = InnoDB,
 PARTITION p20150417 VALUES LESS THAN ('2015-04-18') ENGINE = InnoDB,
 PARTITION p20150418 VALUES LESS THAN ('2015-04-19') ENGINE = InnoDB,
 PARTITION p20150419 VALUES LESS THAN ('2015-04-20') ENGINE = InnoDB,
 PARTITION p20150420 VALUES LESS THAN ('2015-04-21') ENGINE = InnoDB,
 PARTITION p20150421 VALUES LESS THAN ('2015-04-22') ENGINE = InnoDB,
 PARTITION p20150422 VALUES LESS THAN ('2015-04-23') ENGINE = InnoDB,
 PARTITION p20150423 VALUES LESS THAN ('2015-04-24') ENGINE = InnoDB,
 PARTITION p20150424 VALUES LESS THAN ('2015-04-25') ENGINE = InnoDB,
 PARTITION p20150425 VALUES LESS THAN ('2015-04-26') ENGINE = InnoDB,
 PARTITION p20150426 VALUES LESS THAN ('2015-04-27') ENGINE = InnoDB,
 PARTITION p20150427 VALUES LESS THAN ('2015-04-28') ENGINE = InnoDB,
 PARTITION p20150428 VALUES LESS THAN ('2015-04-29') ENGINE = InnoDB,
 PARTITION p20150429 VALUES LESS THAN ('2015-04-30') ENGINE = InnoDB,
 PARTITION p20150430 VALUES LESS THAN ('2015-05-01') ENGINE = InnoDB,
 PARTITION p20150501 VALUES LESS THAN ('2015-05-02') ENGINE = InnoDB,
 PARTITION p20150502 VALUES LESS THAN ('2015-05-03') ENGINE = InnoDB,
 PARTITION p20150503 VALUES LESS THAN ('2015-05-04') ENGINE = InnoDB,
 PARTITION p20150504 VALUES LESS THAN ('2015-05-05') ENGINE = InnoDB,
 PARTITION p20150505 VALUES LESS THAN ('2015-05-06') ENGINE = InnoDB,
 PARTITION p20150506 VALUES LESS THAN ('2015-05-07') ENGINE = InnoDB,
 PARTITION p20150507 VALUES LESS THAN ('2015-05-08') ENGINE = InnoDB,
 PARTITION p20150508 VALUES LESS THAN ('2015-05-09') ENGINE = InnoDB,
 PARTITION p20150509 VALUES LESS THAN ('2015-05-10') ENGINE = InnoDB,
 PARTITION p20150510 VALUES LESS THAN ('2015-05-11') ENGINE = InnoDB,
 PARTITION p20150511 VALUES LESS THAN ('2015-05-12') ENGINE = InnoDB,
 PARTITION p20150512 VALUES LESS THAN ('2015-05-13') ENGINE = InnoDB,
 PARTITION p20150513 VALUES LESS THAN ('2015-05-14') ENGINE = InnoDB,
 PARTITION p20150514 VALUES LESS THAN ('2015-05-15') ENGINE = InnoDB,
 PARTITION p20150515 VALUES LESS THAN ('2015-05-16') ENGINE = InnoDB,
 PARTITION p20150516 VALUES LESS THAN ('2015-05-17') ENGINE = InnoDB,
 PARTITION p20150517 VALUES LESS THAN ('2015-05-18') ENGINE = InnoDB,
 PARTITION p20150518 VALUES LESS THAN ('2015-05-19') ENGINE = InnoDB,
 PARTITION p20150519 VALUES LESS THAN ('2015-05-20') ENGINE = InnoDB,
 PARTITION p20150520 VALUES LESS THAN ('2015-05-21') ENGINE = InnoDB,
 PARTITION p20150521 VALUES LESS THAN ('2015-05-22') ENGINE = InnoDB,
 PARTITION p20150522 VALUES LESS THAN ('2015-05-23') ENGINE = InnoDB,
 PARTITION p20150523 VALUES LESS THAN ('2015-05-24') ENGINE = InnoDB,
 PARTITION p20150524 VALUES LESS THAN ('2015-05-25') ENGINE = InnoDB,
 PARTITION p20150525 VALUES LESS THAN ('2015-05-26') ENGINE = InnoDB,
 PARTITION p20150526 VALUES LESS THAN ('2015-05-27') ENGINE = InnoDB,
 PARTITION p20150527 VALUES LESS THAN ('2015-05-28') ENGINE = InnoDB,
 PARTITION p20150528 VALUES LESS THAN ('2015-05-29') ENGINE = InnoDB,
 PARTITION p20150529 VALUES LESS THAN ('2015-05-30') ENGINE = InnoDB,
 PARTITION p20150530 VALUES LESS THAN ('2015-05-31') ENGINE = InnoDB,
 PARTITION p20150531 VALUES LESS THAN ('2015-06-01') ENGINE = InnoDB,
 PARTITION p20150601 VALUES LESS THAN ('2015-06-02') ENGINE = InnoDB,
 PARTITION p20150602 VALUES LESS THAN ('2015-06-03') ENGINE = InnoDB,
 PARTITION p20150603 VALUES LESS THAN ('2015-06-04') ENGINE = InnoDB,
 PARTITION p20150604 VALUES LESS THAN ('2015-06-05') ENGINE = InnoDB,
 PARTITION p20150605 VALUES LESS THAN ('2015-06-06') ENGINE = InnoDB,
 PARTITION p20150606 VALUES LESS THAN ('2015-06-07') ENGINE = InnoDB,
 PARTITION p20150607 VALUES LESS THAN ('2015-06-08') ENGINE = InnoDB,
 PARTITION p20150608 VALUES LESS THAN ('2015-06-09') ENGINE = InnoDB,
 PARTITION p20150609 VALUES LESS THAN ('2015-06-10') ENGINE = InnoDB,
 PARTITION p20150610 VALUES LESS THAN ('2015-06-11') ENGINE = InnoDB,
 PARTITION p20150611 VALUES LESS THAN ('2015-06-12') ENGINE = InnoDB,
 PARTITION p20150612 VALUES LESS THAN ('2015-06-13') ENGINE = InnoDB,
 PARTITION p20150613 VALUES LESS THAN ('2015-06-14') ENGINE = InnoDB,
 PARTITION p20150614 VALUES LESS THAN ('2015-06-15') ENGINE = InnoDB,
 PARTITION p20150615 VALUES LESS THAN ('2015-06-16') ENGINE = InnoDB,
 PARTITION p20150616 VALUES LESS THAN ('2015-06-17') ENGINE = InnoDB,
 PARTITION p20150617 VALUES LESS THAN ('2015-06-18') ENGINE = InnoDB,
 PARTITION p20150618 VALUES LESS THAN ('2015-06-19') ENGINE = InnoDB,
 PARTITION p20150619 VALUES LESS THAN ('2015-06-20') ENGINE = InnoDB,
 PARTITION p20150620 VALUES LESS THAN ('2015-06-21') ENGINE = InnoDB,
 PARTITION p20150621 VALUES LESS THAN ('2015-06-22') ENGINE = InnoDB,
 PARTITION p20150622 VALUES LESS THAN ('2015-06-23') ENGINE = InnoDB,
 PARTITION p20150623 VALUES LESS THAN ('2015-06-24') ENGINE = InnoDB,
 PARTITION p20150624 VALUES LESS THAN ('2015-06-25') ENGINE = InnoDB,
 PARTITION p20150625 VALUES LESS THAN ('2015-06-26') ENGINE = InnoDB,
 PARTITION p20150626 VALUES LESS THAN ('2015-06-27') ENGINE = InnoDB,
 PARTITION p20150627 VALUES LESS THAN ('2015-06-28') ENGINE = InnoDB,
 PARTITION p20150628 VALUES LESS THAN ('2015-06-29') ENGINE = InnoDB,
 PARTITION p20150629 VALUES LESS THAN ('2015-06-30') ENGINE = InnoDB,
 PARTITION p20150630 VALUES LESS THAN ('2015-07-01') ENGINE = InnoDB,
 PARTITION p20150701 VALUES LESS THAN ('2015-07-02') ENGINE = InnoDB,
 PARTITION p20150702 VALUES LESS THAN ('2015-07-03') ENGINE = InnoDB,
 PARTITION p20150703 VALUES LESS THAN ('2015-07-04') ENGINE = InnoDB,
 PARTITION p20150704 VALUES LESS THAN ('2015-07-05') ENGINE = InnoDB,
 PARTITION p20150705 VALUES LESS THAN ('2015-07-06') ENGINE = InnoDB,
 PARTITION p20150706 VALUES LESS THAN ('2015-07-07') ENGINE = InnoDB,
 PARTITION p20150707 VALUES LESS THAN ('2015-07-08') ENGINE = InnoDB,
 PARTITION p20150708 VALUES LESS THAN ('2015-07-09') ENGINE = InnoDB,
 PARTITION p20150709 VALUES LESS THAN ('2015-07-10') ENGINE = InnoDB,
 PARTITION p20150710 VALUES LESS THAN ('2015-07-11') ENGINE = InnoDB,
 PARTITION p20150711 VALUES LESS THAN ('2015-07-12') ENGINE = InnoDB,
 PARTITION p20150712 VALUES LESS THAN ('2015-07-13') ENGINE = InnoDB,
 PARTITION p20150713 VALUES LESS THAN ('2015-07-14') ENGINE = InnoDB,
 PARTITION p20150714 VALUES LESS THAN ('2015-07-15') ENGINE = InnoDB,
 PARTITION p20150715 VALUES LESS THAN ('2015-07-16') ENGINE = InnoDB,
 PARTITION p20150716 VALUES LESS THAN ('2015-07-17') ENGINE = InnoDB,
 PARTITION p20150717 VALUES LESS THAN ('2015-07-18') ENGINE = InnoDB,
 PARTITION p20150718 VALUES LESS THAN ('2015-07-19') ENGINE = InnoDB,
 PARTITION p20150719 VALUES LESS THAN ('2015-07-20') ENGINE = InnoDB,
 PARTITION p20150720 VALUES LESS THAN ('2015-07-21') ENGINE = InnoDB,
 PARTITION p20150721 VALUES LESS THAN ('2015-07-22') ENGINE = InnoDB,
 PARTITION p20150722 VALUES LESS THAN ('2015-07-23') ENGINE = InnoDB,
 PARTITION p20150723 VALUES LESS THAN ('2015-07-24') ENGINE = InnoDB,
 PARTITION p20150724 VALUES LESS THAN ('2015-07-25') ENGINE = InnoDB,
 PARTITION p20150725 VALUES LESS THAN ('2015-07-26') ENGINE = InnoDB,
 PARTITION p20150726 VALUES LESS THAN ('2015-07-27') ENGINE = InnoDB,
 PARTITION p20150727 VALUES LESS THAN ('2015-07-28') ENGINE = InnoDB,
 PARTITION p20150728 VALUES LESS THAN ('2015-07-29') ENGINE = InnoDB,
 PARTITION p20150729 VALUES LESS THAN ('2015-07-30') ENGINE = InnoDB,
 PARTITION p20150730 VALUES LESS THAN ('2015-07-31') ENGINE = InnoDB,
 PARTITION p20150731 VALUES LESS THAN ('2015-08-01') ENGINE = InnoDB,
 PARTITION p20150801 VALUES LESS THAN ('2015-08-02') ENGINE = InnoDB,
 PARTITION p20150802 VALUES LESS THAN ('2015-08-03') ENGINE = InnoDB,
 PARTITION p20150803 VALUES LESS THAN ('2015-08-04') ENGINE = InnoDB,
 PARTITION p20150804 VALUES LESS THAN ('2015-08-05') ENGINE = InnoDB,
 PARTITION p20150805 VALUES LESS THAN ('2015-08-06') ENGINE = InnoDB,
 PARTITION p20150806 VALUES LESS THAN ('2015-08-07') ENGINE = InnoDB,
 PARTITION p20150807 VALUES LESS THAN ('2015-08-08') ENGINE = InnoDB,
 PARTITION p20150808 VALUES LESS THAN ('2015-08-09') ENGINE = InnoDB,
 PARTITION p20150809 VALUES LESS THAN ('2015-08-10') ENGINE = InnoDB,
 PARTITION p20150810 VALUES LESS THAN ('2015-08-11') ENGINE = InnoDB,
 PARTITION p20150811 VALUES LESS THAN ('2015-08-12') ENGINE = InnoDB,
 PARTITION p20150812 VALUES LESS THAN ('2015-08-13') ENGINE = InnoDB,
 PARTITION p20150813 VALUES LESS THAN ('2015-08-14') ENGINE = InnoDB,
 PARTITION p20150814 VALUES LESS THAN ('2015-08-15') ENGINE = InnoDB,
 PARTITION p20150815 VALUES LESS THAN ('2015-08-16') ENGINE = InnoDB,
 PARTITION p20150816 VALUES LESS THAN ('2015-08-17') ENGINE = InnoDB,
 PARTITION p20150817 VALUES LESS THAN ('2015-08-18') ENGINE = InnoDB,
 PARTITION p20150818 VALUES LESS THAN ('2015-08-19') ENGINE = InnoDB,
 PARTITION p20150819 VALUES LESS THAN ('2015-08-20') ENGINE = InnoDB,
 PARTITION p20150820 VALUES LESS THAN ('2015-08-21') ENGINE = InnoDB,
 PARTITION p20150821 VALUES LESS THAN ('2015-08-22') ENGINE = InnoDB,
 PARTITION p20150822 VALUES LESS THAN ('2015-08-23') ENGINE = InnoDB,
 PARTITION p20150823 VALUES LESS THAN ('2015-08-24') ENGINE = InnoDB,
 PARTITION p20150824 VALUES LESS THAN ('2015-08-25') ENGINE = InnoDB,
 PARTITION p20150825 VALUES LESS THAN ('2015-08-26') ENGINE = InnoDB,
 PARTITION p20150826 VALUES LESS THAN ('2015-08-27') ENGINE = InnoDB,
 PARTITION p20150827 VALUES LESS THAN ('2015-08-28') ENGINE = InnoDB,
 PARTITION p20150828 VALUES LESS THAN ('2015-08-29') ENGINE = InnoDB,
 PARTITION p20150829 VALUES LESS THAN ('2015-08-30') ENGINE = InnoDB,
 PARTITION p20150830 VALUES LESS THAN ('2015-08-31') ENGINE = InnoDB,
 PARTITION p20150831 VALUES LESS THAN ('2015-09-01') ENGINE = InnoDB,
 PARTITION p20150901 VALUES LESS THAN ('2015-09-02') ENGINE = InnoDB,
 PARTITION p20150902 VALUES LESS THAN ('2015-09-03') ENGINE = InnoDB,
 PARTITION p20150903 VALUES LESS THAN ('2015-09-04') ENGINE = InnoDB,
 PARTITION p20150904 VALUES LESS THAN ('2015-09-05') ENGINE = InnoDB,
 PARTITION p20150905 VALUES LESS THAN ('2015-09-06') ENGINE = InnoDB,
 PARTITION p20150906 VALUES LESS THAN ('2015-09-07') ENGINE = InnoDB,
 PARTITION p20150907 VALUES LESS THAN ('2015-09-08') ENGINE = InnoDB,
 PARTITION p20150908 VALUES LESS THAN ('2015-09-09') ENGINE = InnoDB,
 PARTITION p20150909 VALUES LESS THAN ('2015-09-10') ENGINE = InnoDB,
 PARTITION p20150910 VALUES LESS THAN ('2015-09-11') ENGINE = InnoDB,
 PARTITION p20150911 VALUES LESS THAN ('2015-09-12') ENGINE = InnoDB,
 PARTITION p20150912 VALUES LESS THAN ('2015-09-13') ENGINE = InnoDB,
 PARTITION p20150913 VALUES LESS THAN ('2015-09-14') ENGINE = InnoDB,
 PARTITION p20150914 VALUES LESS THAN ('2015-09-15') ENGINE = InnoDB,
 PARTITION p20150915 VALUES LESS THAN ('2015-09-16') ENGINE = InnoDB,
 PARTITION p20150916 VALUES LESS THAN ('2015-09-17') ENGINE = InnoDB,
 PARTITION p20150917 VALUES LESS THAN ('2015-09-18') ENGINE = InnoDB,
 PARTITION p20150918 VALUES LESS THAN ('2015-09-19') ENGINE = InnoDB,
 PARTITION p20150919 VALUES LESS THAN ('2015-09-20') ENGINE = InnoDB,
 PARTITION p20150920 VALUES LESS THAN ('2015-09-21') ENGINE = InnoDB,
 PARTITION p20150921 VALUES LESS THAN ('2015-09-22') ENGINE = InnoDB,
 PARTITION p20150922 VALUES LESS THAN ('2015-09-23') ENGINE = InnoDB,
 PARTITION p20150923 VALUES LESS THAN ('2015-09-24') ENGINE = InnoDB,
 PARTITION p20150924 VALUES LESS THAN ('2015-09-25') ENGINE = InnoDB,
 PARTITION p20150925 VALUES LESS THAN ('2015-09-26') ENGINE = InnoDB,
 PARTITION p20150926 VALUES LESS THAN ('2015-09-27') ENGINE = InnoDB,
 PARTITION p20150927 VALUES LESS THAN ('2015-09-28') ENGINE = InnoDB,
 PARTITION p20150928 VALUES LESS THAN ('2015-09-29') ENGINE = InnoDB,
 PARTITION p20150929 VALUES LESS THAN ('2015-09-30') ENGINE = InnoDB,
 PARTITION p20150930 VALUES LESS THAN ('2015-10-01') ENGINE = InnoDB,
 PARTITION p20151001 VALUES LESS THAN ('2015-10-02') ENGINE = InnoDB,
 PARTITION p20151002 VALUES LESS THAN ('2015-10-03') ENGINE = InnoDB,
 PARTITION p20151003 VALUES LESS THAN ('2015-10-04') ENGINE = InnoDB,
 PARTITION p20151004 VALUES LESS THAN ('2015-10-05') ENGINE = InnoDB,
 PARTITION p20151005 VALUES LESS THAN ('2015-10-06') ENGINE = InnoDB,
 PARTITION p20151006 VALUES LESS THAN ('2015-10-07') ENGINE = InnoDB,
 PARTITION p20151007 VALUES LESS THAN ('2015-10-08') ENGINE = InnoDB,
 PARTITION p20151008 VALUES LESS THAN ('2015-10-09') ENGINE = InnoDB,
 PARTITION p20151009 VALUES LESS THAN ('2015-10-10') ENGINE = InnoDB,
 PARTITION p20151010 VALUES LESS THAN ('2015-10-11') ENGINE = InnoDB,
 PARTITION p20151011 VALUES LESS THAN ('2015-10-12') ENGINE = InnoDB,
 PARTITION p20151012 VALUES LESS THAN ('2015-10-13') ENGINE = InnoDB,
 PARTITION p20151013 VALUES LESS THAN ('2015-10-14') ENGINE = InnoDB,
 PARTITION p20151014 VALUES LESS THAN ('2015-10-15') ENGINE = InnoDB,
 PARTITION p20151015 VALUES LESS THAN ('2015-10-16') ENGINE = InnoDB,
 PARTITION p20151016 VALUES LESS THAN ('2015-10-17') ENGINE = InnoDB,
 PARTITION p20151017 VALUES LESS THAN ('2015-10-18') ENGINE = InnoDB,
 PARTITION p20151018 VALUES LESS THAN ('2015-10-19') ENGINE = InnoDB,
 PARTITION p20151019 VALUES LESS THAN ('2015-10-20') ENGINE = InnoDB,
 PARTITION p20151020 VALUES LESS THAN ('2015-10-21') ENGINE = InnoDB,
 PARTITION p20151021 VALUES LESS THAN ('2015-10-22') ENGINE = InnoDB,
 PARTITION p20151022 VALUES LESS THAN ('2015-10-23') ENGINE = InnoDB,
 PARTITION p20151023 VALUES LESS THAN ('2015-10-24') ENGINE = InnoDB,
 PARTITION p20151024 VALUES LESS THAN ('2015-10-25') ENGINE = InnoDB,
 PARTITION p20151025 VALUES LESS THAN ('2015-10-26') ENGINE = InnoDB,
 PARTITION p20151026 VALUES LESS THAN ('2015-10-27') ENGINE = InnoDB,
 PARTITION p20151027 VALUES LESS THAN ('2015-10-28') ENGINE = InnoDB,
 PARTITION p20151028 VALUES LESS THAN ('2015-10-29') ENGINE = InnoDB,
 PARTITION p20151029 VALUES LESS THAN ('2015-10-30') ENGINE = InnoDB,
 PARTITION p20151030 VALUES LESS THAN ('2015-10-31') ENGINE = InnoDB,
 PARTITION p20151031 VALUES LESS THAN ('2015-11-01') ENGINE = InnoDB,
 PARTITION p20151101 VALUES LESS THAN ('2015-11-02') ENGINE = InnoDB,
 PARTITION p20151102 VALUES LESS THAN ('2015-11-03') ENGINE = InnoDB,
 PARTITION p20151103 VALUES LESS THAN ('2015-11-04') ENGINE = InnoDB,
 PARTITION p20151104 VALUES LESS THAN ('2015-11-05') ENGINE = InnoDB,
 PARTITION p20151105 VALUES LESS THAN ('2015-11-06') ENGINE = InnoDB,
 PARTITION p20151106 VALUES LESS THAN ('2015-11-07') ENGINE = InnoDB,
 PARTITION p20151107 VALUES LESS THAN ('2015-11-08') ENGINE = InnoDB,
 PARTITION p20151108 VALUES LESS THAN ('2015-11-09') ENGINE = InnoDB,
 PARTITION p20151109 VALUES LESS THAN ('2015-11-10') ENGINE = InnoDB,
 PARTITION p20151110 VALUES LESS THAN ('2015-11-11') ENGINE = InnoDB,
 PARTITION p20151111 VALUES LESS THAN ('2015-11-12') ENGINE = InnoDB,
 PARTITION p20151112 VALUES LESS THAN ('2015-11-13') ENGINE = InnoDB,
 PARTITION p20151113 VALUES LESS THAN ('2015-11-14') ENGINE = InnoDB,
 PARTITION p20151114 VALUES LESS THAN ('2015-11-15') ENGINE = InnoDB,
 PARTITION p20151115 VALUES LESS THAN ('2015-11-16') ENGINE = InnoDB,
 PARTITION p20151116 VALUES LESS THAN ('2015-11-17') ENGINE = InnoDB,
 PARTITION p20151117 VALUES LESS THAN ('2015-11-18') ENGINE = InnoDB,
 PARTITION p20151118 VALUES LESS THAN ('2015-11-19') ENGINE = InnoDB,
 PARTITION p20151119 VALUES LESS THAN ('2015-11-20') ENGINE = InnoDB,
 PARTITION p20151120 VALUES LESS THAN ('2015-11-21') ENGINE = InnoDB,
 PARTITION p20151121 VALUES LESS THAN ('2015-11-22') ENGINE = InnoDB,
 PARTITION p20151122 VALUES LESS THAN ('2015-11-23') ENGINE = InnoDB,
 PARTITION p20151123 VALUES LESS THAN ('2015-11-24') ENGINE = InnoDB,
 PARTITION p20151124 VALUES LESS THAN ('2015-11-25') ENGINE = InnoDB,
 PARTITION p20151125 VALUES LESS THAN ('2015-11-26') ENGINE = InnoDB,
 PARTITION p20151126 VALUES LESS THAN ('2015-11-27') ENGINE = InnoDB,
 PARTITION p20151127 VALUES LESS THAN ('2015-11-28') ENGINE = InnoDB,
 PARTITION p20151128 VALUES LESS THAN ('2015-11-29') ENGINE = InnoDB,
 PARTITION p20151129 VALUES LESS THAN ('2015-11-30') ENGINE = InnoDB,
 PARTITION p20151130 VALUES LESS THAN ('2015-12-01') ENGINE = InnoDB,
 PARTITION p20151201 VALUES LESS THAN ('2015-12-02') ENGINE = InnoDB,
 PARTITION p20151202 VALUES LESS THAN ('2015-12-03') ENGINE = InnoDB,
 PARTITION p20151203 VALUES LESS THAN ('2015-12-04') ENGINE = InnoDB,
 PARTITION p20151204 VALUES LESS THAN ('2015-12-05') ENGINE = InnoDB,
 PARTITION p20151205 VALUES LESS THAN ('2015-12-06') ENGINE = InnoDB,
 PARTITION p20151206 VALUES LESS THAN ('2015-12-07') ENGINE = InnoDB,
 PARTITION p20151207 VALUES LESS THAN ('2015-12-08') ENGINE = InnoDB,
 PARTITION p20151208 VALUES LESS THAN ('2015-12-09') ENGINE = InnoDB,
 PARTITION p20151209 VALUES LESS THAN ('2015-12-10') ENGINE = InnoDB,
 PARTITION p20151210 VALUES LESS THAN ('2015-12-11') ENGINE = InnoDB,
 PARTITION p20151211 VALUES LESS THAN ('2015-12-12') ENGINE = InnoDB,
 PARTITION p20151212 VALUES LESS THAN ('2015-12-13') ENGINE = InnoDB,
 PARTITION p20151213 VALUES LESS THAN ('2015-12-14') ENGINE = InnoDB,
 PARTITION p20151214 VALUES LESS THAN ('2015-12-15') ENGINE = InnoDB,
 PARTITION p20151215 VALUES LESS THAN ('2015-12-16') ENGINE = InnoDB,
 PARTITION p20151216 VALUES LESS THAN ('2015-12-17') ENGINE = InnoDB,
 PARTITION p20151217 VALUES LESS THAN ('2015-12-18') ENGINE = InnoDB,
 PARTITION p20151218 VALUES LESS THAN ('2015-12-19') ENGINE = InnoDB,
 PARTITION p20151219 VALUES LESS THAN ('2015-12-20') ENGINE = InnoDB,
 PARTITION p20151220 VALUES LESS THAN ('2015-12-21') ENGINE = InnoDB,
 PARTITION p20151221 VALUES LESS THAN ('2015-12-22') ENGINE = InnoDB,
 PARTITION p20151222 VALUES LESS THAN ('2015-12-23') ENGINE = InnoDB,
 PARTITION p20151223 VALUES LESS THAN ('2015-12-24') ENGINE = InnoDB,
 PARTITION p20151224 VALUES LESS THAN ('2015-12-25') ENGINE = InnoDB,
 PARTITION p20151225 VALUES LESS THAN ('2015-12-26') ENGINE = InnoDB,
 PARTITION p20151226 VALUES LESS THAN ('2015-12-27') ENGINE = InnoDB,
 PARTITION p20151227 VALUES LESS THAN ('2015-12-28') ENGINE = InnoDB,
 PARTITION p20151228 VALUES LESS THAN ('2015-12-29') ENGINE = InnoDB,
 PARTITION p20151229 VALUES LESS THAN ('2015-12-30') ENGINE = InnoDB,
 PARTITION p20151230 VALUES LESS THAN ('2015-12-31') ENGINE = InnoDB,
 PARTITION p20151231 VALUES LESS THAN ('2016-01-01') ENGINE = InnoDB,
 PARTITION p20160101 VALUES LESS THAN ('2016-01-02') ENGINE = InnoDB,
 PARTITION p20160102 VALUES LESS THAN ('2016-01-03') ENGINE = InnoDB,
 PARTITION p20160103 VALUES LESS THAN ('2016-01-04') ENGINE = InnoDB,
 PARTITION p20160104 VALUES LESS THAN ('2016-01-05') ENGINE = InnoDB,
 PARTITION p20160105 VALUES LESS THAN ('2016-01-06') ENGINE = InnoDB,
 PARTITION p20160106 VALUES LESS THAN ('2016-01-07') ENGINE = InnoDB,
 PARTITION p20160107 VALUES LESS THAN ('2016-01-08') ENGINE = InnoDB,
 PARTITION p20160108 VALUES LESS THAN ('2016-01-09') ENGINE = InnoDB,
 PARTITION p20160109 VALUES LESS THAN ('2016-01-10') ENGINE = InnoDB,
 PARTITION p20160110 VALUES LESS THAN ('2016-01-11') ENGINE = InnoDB,
 PARTITION p20160111 VALUES LESS THAN ('2016-01-12') ENGINE = InnoDB,
 PARTITION p20160112 VALUES LESS THAN ('2016-01-13') ENGINE = InnoDB,
 PARTITION p20160113 VALUES LESS THAN ('2016-01-14') ENGINE = InnoDB,
 PARTITION p20160114 VALUES LESS THAN ('2016-01-15') ENGINE = InnoDB,
 PARTITION p20160115 VALUES LESS THAN ('2016-01-16') ENGINE = InnoDB,
 PARTITION p20160116 VALUES LESS THAN ('2016-01-17') ENGINE = InnoDB,
 PARTITION p20160117 VALUES LESS THAN ('2016-01-18') ENGINE = InnoDB,
 PARTITION p20160118 VALUES LESS THAN ('2016-01-19') ENGINE = InnoDB,
 PARTITION p20160119 VALUES LESS THAN ('2016-01-20') ENGINE = InnoDB,
 PARTITION p20160120 VALUES LESS THAN ('2016-01-21') ENGINE = InnoDB,
 PARTITION p20160121 VALUES LESS THAN ('2016-01-22') ENGINE = InnoDB,
 PARTITION p20160122 VALUES LESS THAN ('2016-01-23') ENGINE = InnoDB,
 PARTITION p20160123 VALUES LESS THAN ('2016-01-24') ENGINE = InnoDB,
 PARTITION p20160124 VALUES LESS THAN ('2016-01-25') ENGINE = InnoDB,
 PARTITION p20160125 VALUES LESS THAN ('2016-01-26') ENGINE = InnoDB,
 PARTITION p20160126 VALUES LESS THAN ('2016-01-27') ENGINE = InnoDB,
 PARTITION p20160127 VALUES LESS THAN ('2016-01-28') ENGINE = InnoDB,
 PARTITION p20160128 VALUES LESS THAN ('2016-01-29') ENGINE = InnoDB,
 PARTITION p20160129 VALUES LESS THAN ('2016-01-30') ENGINE = InnoDB,
 PARTITION p20160130 VALUES LESS THAN ('2016-01-31') ENGINE = InnoDB,
 PARTITION p20160131 VALUES LESS THAN ('2016-02-01') ENGINE = InnoDB,
 PARTITION p20160201 VALUES LESS THAN ('2016-02-02') ENGINE = InnoDB,
 PARTITION p20160202 VALUES LESS THAN ('2016-02-03') ENGINE = InnoDB,
 PARTITION p20160203 VALUES LESS THAN ('2016-02-04') ENGINE = InnoDB,
 PARTITION p20160204 VALUES LESS THAN ('2016-02-05') ENGINE = InnoDB,
 PARTITION p20160205 VALUES LESS THAN ('2016-02-06') ENGINE = InnoDB,
 PARTITION p20160206 VALUES LESS THAN ('2016-02-07') ENGINE = InnoDB,
 PARTITION p20160207 VALUES LESS THAN ('2016-02-08') ENGINE = InnoDB,
 PARTITION p20160208 VALUES LESS THAN ('2016-02-09') ENGINE = InnoDB,
 PARTITION p20160209 VALUES LESS THAN ('2016-02-10') ENGINE = InnoDB,
 PARTITION p20160210 VALUES LESS THAN ('2016-02-11') ENGINE = InnoDB,
 PARTITION p20160211 VALUES LESS THAN ('2016-02-12') ENGINE = InnoDB,
 PARTITION p20160212 VALUES LESS THAN ('2016-02-13') ENGINE = InnoDB,
 PARTITION p20160213 VALUES LESS THAN ('2016-02-14') ENGINE = InnoDB,
 PARTITION p20160214 VALUES LESS THAN ('2016-02-15') ENGINE = InnoDB,
 PARTITION p20160215 VALUES LESS THAN ('2016-02-16') ENGINE = InnoDB,
 PARTITION p20160216 VALUES LESS THAN ('2016-02-17') ENGINE = InnoDB,
 PARTITION p20160217 VALUES LESS THAN ('2016-02-18') ENGINE = InnoDB,
 PARTITION p20160218 VALUES LESS THAN ('2016-02-19') ENGINE = InnoDB,
 PARTITION p20160219 VALUES LESS THAN ('2016-02-20') ENGINE = InnoDB,
 PARTITION p20160220 VALUES LESS THAN ('2016-02-21') ENGINE = InnoDB,
 PARTITION p20160221 VALUES LESS THAN ('2016-02-22') ENGINE = InnoDB,
 PARTITION p20160222 VALUES LESS THAN ('2016-02-23') ENGINE = InnoDB,
 PARTITION p20160223 VALUES LESS THAN ('2016-02-24') ENGINE = InnoDB,
 PARTITION p20160224 VALUES LESS THAN ('2016-02-25') ENGINE = InnoDB,
 PARTITION p20160225 VALUES LESS THAN ('2016-02-26') ENGINE = InnoDB,
 PARTITION p20160226 VALUES LESS THAN ('2016-02-27') ENGINE = InnoDB,
 PARTITION p20160227 VALUES LESS THAN ('2016-02-28') ENGINE = InnoDB,
 PARTITION p20160228 VALUES LESS THAN ('2016-02-29') ENGINE = InnoDB,
 PARTITION p20160229 VALUES LESS THAN ('2016-03-01') ENGINE = InnoDB,
 PARTITION p20160301 VALUES LESS THAN ('2016-03-02') ENGINE = InnoDB,
 PARTITION p20160302 VALUES LESS THAN ('2016-03-03') ENGINE = InnoDB,
 PARTITION p20160303 VALUES LESS THAN ('2016-03-04') ENGINE = InnoDB,
 PARTITION p20160304 VALUES LESS THAN ('2016-03-05') ENGINE = InnoDB,
 PARTITION p20160305 VALUES LESS THAN ('2016-03-06') ENGINE = InnoDB,
 PARTITION p20160306 VALUES LESS THAN ('2016-03-07') ENGINE = InnoDB,
 PARTITION p20160307 VALUES LESS THAN ('2016-03-08') ENGINE = InnoDB,
 PARTITION p20160308 VALUES LESS THAN ('2016-03-09') ENGINE = InnoDB,
 PARTITION p20160309 VALUES LESS THAN ('2016-03-10') ENGINE = InnoDB,
 PARTITION p20160310 VALUES LESS THAN ('2016-03-11') ENGINE = InnoDB,
 PARTITION p20160311 VALUES LESS THAN ('2016-03-12') ENGINE = InnoDB,
 PARTITION p20160312 VALUES LESS THAN ('2016-03-13') ENGINE = InnoDB,
 PARTITION p20160313 VALUES LESS THAN ('2016-03-14') ENGINE = InnoDB,
 PARTITION p20160314 VALUES LESS THAN ('2016-03-15') ENGINE = InnoDB,
 PARTITION p20160315 VALUES LESS THAN ('2016-03-16') ENGINE = InnoDB,
 PARTITION p20160316 VALUES LESS THAN ('2016-03-17') ENGINE = InnoDB,
 PARTITION p20160317 VALUES LESS THAN ('2016-03-18') ENGINE = InnoDB,
 PARTITION p20160318 VALUES LESS THAN ('2016-03-19') ENGINE = InnoDB,
 PARTITION p20160319 VALUES LESS THAN ('2016-03-20') ENGINE = InnoDB,
 PARTITION p20160320 VALUES LESS THAN ('2016-03-21') ENGINE = InnoDB,
 PARTITION p20160321 VALUES LESS THAN ('2016-03-22') ENGINE = InnoDB,
 PARTITION p20160322 VALUES LESS THAN ('2016-03-23') ENGINE = InnoDB,
 PARTITION p20160323 VALUES LESS THAN ('2016-03-24') ENGINE = InnoDB,
 PARTITION p20160324 VALUES LESS THAN ('2016-03-25') ENGINE = InnoDB,
 PARTITION p20160325 VALUES LESS THAN ('2016-03-26') ENGINE = InnoDB,
 PARTITION p20160326 VALUES LESS THAN ('2016-03-27') ENGINE = InnoDB,
 PARTITION p20160327 VALUES LESS THAN ('2016-03-28') ENGINE = InnoDB,
 PARTITION p20160328 VALUES LESS THAN ('2016-03-29') ENGINE = InnoDB,
 PARTITION p20160329 VALUES LESS THAN ('2016-03-30') ENGINE = InnoDB,
 PARTITION p20160330 VALUES LESS THAN ('2016-03-31') ENGINE = InnoDB,
 PARTITION p20160331 VALUES LESS THAN ('2016-04-01') ENGINE = InnoDB,
 PARTITION p20160401 VALUES LESS THAN ('2016-04-02') ENGINE = InnoDB,
 PARTITION p20160402 VALUES LESS THAN ('2016-04-03') ENGINE = InnoDB,
 PARTITION p20160403 VALUES LESS THAN ('2016-04-04') ENGINE = InnoDB,
 PARTITION p20160404 VALUES LESS THAN ('2016-04-05') ENGINE = InnoDB,
 PARTITION p20160405 VALUES LESS THAN ('2016-04-06') ENGINE = InnoDB,
 PARTITION p20160406 VALUES LESS THAN ('2016-04-07') ENGINE = InnoDB,
 PARTITION p20160407 VALUES LESS THAN ('2016-04-08') ENGINE = InnoDB,
 PARTITION p20160408 VALUES LESS THAN ('2016-04-09') ENGINE = InnoDB,
 PARTITION p20160409 VALUES LESS THAN ('2016-04-10') ENGINE = InnoDB,
 PARTITION p20160410 VALUES LESS THAN ('2016-04-11') ENGINE = InnoDB,
 PARTITION p20160411 VALUES LESS THAN ('2016-04-12') ENGINE = InnoDB,
 PARTITION p20160412 VALUES LESS THAN ('2016-04-13') ENGINE = InnoDB,
 PARTITION p20160413 VALUES LESS THAN ('2016-04-14') ENGINE = InnoDB,
 PARTITION p20160414 VALUES LESS THAN ('2016-04-15') ENGINE = InnoDB,
 PARTITION p20160415 VALUES LESS THAN ('2016-04-16') ENGINE = InnoDB,
 PARTITION p20160416 VALUES LESS THAN ('2016-04-17') ENGINE = InnoDB,
 PARTITION p20160417 VALUES LESS THAN ('2016-04-18') ENGINE = InnoDB,
 PARTITION p20160418 VALUES LESS THAN ('2016-04-19') ENGINE = InnoDB,
 PARTITION p20160419 VALUES LESS THAN ('2016-04-20') ENGINE = InnoDB,
 PARTITION p20160420 VALUES LESS THAN ('2016-04-21') ENGINE = InnoDB,
 PARTITION p20160421 VALUES LESS THAN ('2016-04-22') ENGINE = InnoDB,
 PARTITION p20160422 VALUES LESS THAN ('2016-04-23') ENGINE = InnoDB,
 PARTITION p20160423 VALUES LESS THAN ('2016-04-24') ENGINE = InnoDB,
 PARTITION p20160424 VALUES LESS THAN ('2016-04-25') ENGINE = InnoDB,
 PARTITION p20160425 VALUES LESS THAN ('2016-04-26') ENGINE = InnoDB,
 PARTITION p20160426 VALUES LESS THAN ('2016-04-27') ENGINE = InnoDB,
 PARTITION p20160427 VALUES LESS THAN ('2016-04-28') ENGINE = InnoDB,
 PARTITION p20160428 VALUES LESS THAN ('2016-04-29') ENGINE = InnoDB,
 PARTITION p20160429 VALUES LESS THAN ('2016-04-30') ENGINE = InnoDB,
 PARTITION p20160430 VALUES LESS THAN ('2016-05-01') ENGINE = InnoDB,
 PARTITION p20160501 VALUES LESS THAN ('2016-05-02') ENGINE = InnoDB,
 PARTITION p20160502 VALUES LESS THAN ('2016-05-03') ENGINE = InnoDB,
 PARTITION p20160503 VALUES LESS THAN ('2016-05-04') ENGINE = InnoDB,
 PARTITION p20160504 VALUES LESS THAN ('2016-05-05') ENGINE = InnoDB,
 PARTITION p20160505 VALUES LESS THAN ('2016-05-06') ENGINE = InnoDB,
 PARTITION p20160506 VALUES LESS THAN ('2016-05-07') ENGINE = InnoDB,
 PARTITION p20160507 VALUES LESS THAN ('2016-05-08') ENGINE = InnoDB,
 PARTITION p20160508 VALUES LESS THAN ('2016-05-09') ENGINE = InnoDB,
 PARTITION p20160509 VALUES LESS THAN ('2016-05-10') ENGINE = InnoDB,
 PARTITION p20160510 VALUES LESS THAN ('2016-05-11') ENGINE = InnoDB,
 PARTITION p20160511 VALUES LESS THAN ('2016-05-12') ENGINE = InnoDB,
 PARTITION p20160512 VALUES LESS THAN ('2016-05-13') ENGINE = InnoDB,
 PARTITION p20160513 VALUES LESS THAN ('2016-05-14') ENGINE = InnoDB,
 PARTITION p20160514 VALUES LESS THAN ('2016-05-15') ENGINE = InnoDB,
 PARTITION p20160515 VALUES LESS THAN ('2016-05-16') ENGINE = InnoDB,
 PARTITION p20160516 VALUES LESS THAN ('2016-05-17') ENGINE = InnoDB,
 PARTITION p20160517 VALUES LESS THAN ('2016-05-18') ENGINE = InnoDB,
 PARTITION p20160518 VALUES LESS THAN ('2016-05-19') ENGINE = InnoDB,
 PARTITION p20160519 VALUES LESS THAN ('2016-05-20') ENGINE = InnoDB,
 PARTITION p20160520 VALUES LESS THAN ('2016-05-21') ENGINE = InnoDB,
 PARTITION p20160521 VALUES LESS THAN ('2016-05-22') ENGINE = InnoDB,
 PARTITION p20160522 VALUES LESS THAN ('2016-05-23') ENGINE = InnoDB,
 PARTITION p20160523 VALUES LESS THAN ('2016-05-24') ENGINE = InnoDB,
 PARTITION p20160524 VALUES LESS THAN ('2016-05-25') ENGINE = InnoDB,
 PARTITION p20160525 VALUES LESS THAN ('2016-05-26') ENGINE = InnoDB,
 PARTITION p20160526 VALUES LESS THAN ('2016-05-27') ENGINE = InnoDB,
 PARTITION p20160527 VALUES LESS THAN ('2016-05-28') ENGINE = InnoDB,
 PARTITION p20160528 VALUES LESS THAN ('2016-05-29') ENGINE = InnoDB,
 PARTITION p20160529 VALUES LESS THAN ('2016-05-30') ENGINE = InnoDB,
 PARTITION p20160530 VALUES LESS THAN ('2016-05-31') ENGINE = InnoDB,
 PARTITION p20160531 VALUES LESS THAN ('2016-06-01') ENGINE = InnoDB,
 PARTITION p20160601 VALUES LESS THAN ('2016-06-02') ENGINE = InnoDB,
 PARTITION p20160602 VALUES LESS THAN ('2016-06-03') ENGINE = InnoDB,
 PARTITION p20160603 VALUES LESS THAN ('2016-06-04') ENGINE = InnoDB,
 PARTITION p20160604 VALUES LESS THAN ('2016-06-05') ENGINE = InnoDB,
 PARTITION p20160605 VALUES LESS THAN ('2016-06-06') ENGINE = InnoDB,
 PARTITION p20160606 VALUES LESS THAN ('2016-06-07') ENGINE = InnoDB,
 PARTITION p20160607 VALUES LESS THAN ('2016-06-08') ENGINE = InnoDB,
 PARTITION p20160608 VALUES LESS THAN ('2016-06-09') ENGINE = InnoDB,
 PARTITION p20160609 VALUES LESS THAN ('2016-06-10') ENGINE = InnoDB,
 PARTITION p20160610 VALUES LESS THAN ('2016-06-11') ENGINE = InnoDB,
 PARTITION p20160611 VALUES LESS THAN ('2016-06-12') ENGINE = InnoDB,
 PARTITION p20160612 VALUES LESS THAN ('2016-06-13') ENGINE = InnoDB,
 PARTITION p20160613 VALUES LESS THAN ('2016-06-14') ENGINE = InnoDB,
 PARTITION p20160614 VALUES LESS THAN ('2016-06-15') ENGINE = InnoDB,
 PARTITION p20160615 VALUES LESS THAN ('2016-06-16') ENGINE = InnoDB,
 PARTITION p20160616 VALUES LESS THAN ('2016-06-17') ENGINE = InnoDB,
 PARTITION p20160617 VALUES LESS THAN ('2016-06-18') ENGINE = InnoDB,
 PARTITION p20160618 VALUES LESS THAN ('2016-06-19') ENGINE = InnoDB,
 PARTITION p20160619 VALUES LESS THAN ('2016-06-20') ENGINE = InnoDB,
 PARTITION p20160620 VALUES LESS THAN ('2016-06-21') ENGINE = InnoDB,
 PARTITION p20160621 VALUES LESS THAN ('2016-06-22') ENGINE = InnoDB,
 PARTITION p20160622 VALUES LESS THAN ('2016-06-23') ENGINE = InnoDB,
 PARTITION p20160623 VALUES LESS THAN ('2016-06-24') ENGINE = InnoDB,
 PARTITION p20160624 VALUES LESS THAN ('2016-06-25') ENGINE = InnoDB,
 PARTITION p20160625 VALUES LESS THAN ('2016-06-26') ENGINE = InnoDB,
 PARTITION p20160626 VALUES LESS THAN ('2016-06-27') ENGINE = InnoDB,
 PARTITION p20160627 VALUES LESS THAN ('2016-06-28') ENGINE = InnoDB,
 PARTITION p20160628 VALUES LESS THAN ('2016-06-29') ENGINE = InnoDB,
 PARTITION p20160629 VALUES LESS THAN ('2016-06-30') ENGINE = InnoDB,
 PARTITION p20160630 VALUES LESS THAN ('2016-07-01') ENGINE = InnoDB,
 PARTITION p20160701 VALUES LESS THAN ('2016-07-02') ENGINE = InnoDB,
 PARTITION p20160702 VALUES LESS THAN ('2016-07-03') ENGINE = InnoDB,
 PARTITION p20160703 VALUES LESS THAN ('2016-07-04') ENGINE = InnoDB,
 PARTITION p20160704 VALUES LESS THAN ('2016-07-05') ENGINE = InnoDB,
 PARTITION p20160705 VALUES LESS THAN ('2016-07-06') ENGINE = InnoDB,
 PARTITION p20160706 VALUES LESS THAN ('2016-07-07') ENGINE = InnoDB,
 PARTITION p20160707 VALUES LESS THAN ('2016-07-08') ENGINE = InnoDB,
 PARTITION p20160708 VALUES LESS THAN ('2016-07-09') ENGINE = InnoDB,
 PARTITION p20160709 VALUES LESS THAN ('2016-07-10') ENGINE = InnoDB,
 PARTITION p20160710 VALUES LESS THAN ('2016-07-11') ENGINE = InnoDB,
 PARTITION p20160711 VALUES LESS THAN ('2016-07-12') ENGINE = InnoDB,
 PARTITION p20160712 VALUES LESS THAN ('2016-07-13') ENGINE = InnoDB,
 PARTITION p20160713 VALUES LESS THAN ('2016-07-14') ENGINE = InnoDB,
 PARTITION p20160714 VALUES LESS THAN ('2016-07-15') ENGINE = InnoDB,
 PARTITION p20160715 VALUES LESS THAN ('2016-07-16') ENGINE = InnoDB,
 PARTITION p20160716 VALUES LESS THAN ('2016-07-17') ENGINE = InnoDB,
 PARTITION p20160717 VALUES LESS THAN ('2016-07-18') ENGINE = InnoDB,
 PARTITION p20160718 VALUES LESS THAN ('2016-07-19') ENGINE = InnoDB,
 PARTITION p20160719 VALUES LESS THAN ('2016-07-20') ENGINE = InnoDB,
 PARTITION p20160720 VALUES LESS THAN ('2016-07-21') ENGINE = InnoDB,
 PARTITION p20160721 VALUES LESS THAN ('2016-07-22') ENGINE = InnoDB,
 PARTITION p20160722 VALUES LESS THAN ('2016-07-23') ENGINE = InnoDB,
 PARTITION p20160723 VALUES LESS THAN ('2016-07-24') ENGINE = InnoDB,
 PARTITION p20160724 VALUES LESS THAN ('2016-07-25') ENGINE = InnoDB,
 PARTITION p20160725 VALUES LESS THAN ('2016-07-26') ENGINE = InnoDB,
 PARTITION p20160726 VALUES LESS THAN ('2016-07-27') ENGINE = InnoDB,
 PARTITION p20160727 VALUES LESS THAN ('2016-07-28') ENGINE = InnoDB,
 PARTITION p20160728 VALUES LESS THAN ('2016-07-29') ENGINE = InnoDB,
 PARTITION p20160729 VALUES LESS THAN ('2016-07-30') ENGINE = InnoDB,
 PARTITION p20160730 VALUES LESS THAN ('2016-07-31') ENGINE = InnoDB,
 PARTITION p20160731 VALUES LESS THAN ('2016-08-01') ENGINE = InnoDB,
 PARTITION p20160801 VALUES LESS THAN ('2016-08-02') ENGINE = InnoDB,
 PARTITION p20160802 VALUES LESS THAN ('2016-08-03') ENGINE = InnoDB,
 PARTITION p20160803 VALUES LESS THAN ('2016-08-04') ENGINE = InnoDB,
 PARTITION p20160804 VALUES LESS THAN ('2016-08-05') ENGINE = InnoDB,
 PARTITION p20160805 VALUES LESS THAN ('2016-08-06') ENGINE = InnoDB,
 PARTITION p20160806 VALUES LESS THAN ('2016-08-07') ENGINE = InnoDB,
 PARTITION p20160807 VALUES LESS THAN ('2016-08-08') ENGINE = InnoDB,
 PARTITION p20160808 VALUES LESS THAN ('2016-08-09') ENGINE = InnoDB,
 PARTITION p20160809 VALUES LESS THAN ('2016-08-10') ENGINE = InnoDB,
 PARTITION p20160810 VALUES LESS THAN ('2016-08-11') ENGINE = InnoDB,
 PARTITION p20160811 VALUES LESS THAN ('2016-08-12') ENGINE = InnoDB,
 PARTITION p20160812 VALUES LESS THAN ('2016-08-13') ENGINE = InnoDB,
 PARTITION p20160813 VALUES LESS THAN ('2016-08-14') ENGINE = InnoDB,
 PARTITION p20160814 VALUES LESS THAN ('2016-08-15') ENGINE = InnoDB,
 PARTITION p20160815 VALUES LESS THAN ('2016-08-16') ENGINE = InnoDB,
 PARTITION p20160816 VALUES LESS THAN ('2016-08-17') ENGINE = InnoDB,
 PARTITION p20160817 VALUES LESS THAN ('2016-08-18') ENGINE = InnoDB,
 PARTITION p20160818 VALUES LESS THAN ('2016-08-19') ENGINE = InnoDB,
 PARTITION p20160819 VALUES LESS THAN ('2016-08-20') ENGINE = InnoDB,
 PARTITION p20160820 VALUES LESS THAN ('2016-08-21') ENGINE = InnoDB,
 PARTITION p20160821 VALUES LESS THAN ('2016-08-22') ENGINE = InnoDB,
 PARTITION p20160822 VALUES LESS THAN ('2016-08-23') ENGINE = InnoDB,
 PARTITION p20160823 VALUES LESS THAN ('2016-08-24') ENGINE = InnoDB,
 PARTITION p20160824 VALUES LESS THAN ('2016-08-25') ENGINE = InnoDB,
 PARTITION p20160825 VALUES LESS THAN ('2016-08-26') ENGINE = InnoDB,
 PARTITION p20160826 VALUES LESS THAN ('2016-08-27') ENGINE = InnoDB,
 PARTITION p20160827 VALUES LESS THAN ('2016-08-28') ENGINE = InnoDB,
 PARTITION p20160828 VALUES LESS THAN ('2016-08-29') ENGINE = InnoDB,
 PARTITION p20160829 VALUES LESS THAN ('2016-08-30') ENGINE = InnoDB,
 PARTITION p20160830 VALUES LESS THAN ('2016-08-31') ENGINE = InnoDB,
 PARTITION p20160831 VALUES LESS THAN ('2016-09-01') ENGINE = InnoDB,
 PARTITION p20160901 VALUES LESS THAN ('2016-09-02') ENGINE = InnoDB,
 PARTITION p20160902 VALUES LESS THAN ('2016-09-03') ENGINE = InnoDB,
 PARTITION p20160903 VALUES LESS THAN ('2016-09-04') ENGINE = InnoDB,
 PARTITION p20160904 VALUES LESS THAN ('2016-09-05') ENGINE = InnoDB,
 PARTITION p20160905 VALUES LESS THAN ('2016-09-06') ENGINE = InnoDB,
 PARTITION p20160906 VALUES LESS THAN ('2016-09-07') ENGINE = InnoDB,
 PARTITION p20160907 VALUES LESS THAN ('2016-09-08') ENGINE = InnoDB,
 PARTITION p20160908 VALUES LESS THAN ('2016-09-09') ENGINE = InnoDB,
 PARTITION p20160909 VALUES LESS THAN ('2016-09-10') ENGINE = InnoDB,
 PARTITION p20160910 VALUES LESS THAN ('2016-09-11') ENGINE = InnoDB,
 PARTITION p20160911 VALUES LESS THAN ('2016-09-12') ENGINE = InnoDB,
 PARTITION p20160912 VALUES LESS THAN ('2016-09-13') ENGINE = InnoDB,
 PARTITION p20160913 VALUES LESS THAN ('2016-09-14') ENGINE = InnoDB,
 PARTITION p20160914 VALUES LESS THAN ('2016-09-15') ENGINE = InnoDB,
 PARTITION p20160915 VALUES LESS THAN ('2016-09-16') ENGINE = InnoDB,
 PARTITION p20160916 VALUES LESS THAN ('2016-09-17') ENGINE = InnoDB,
 PARTITION p20160917 VALUES LESS THAN ('2016-09-18') ENGINE = InnoDB,
 PARTITION p20160918 VALUES LESS THAN ('2016-09-19') ENGINE = InnoDB,
 PARTITION p20160919 VALUES LESS THAN ('2016-09-20') ENGINE = InnoDB,
 PARTITION p20160920 VALUES LESS THAN ('2016-09-21') ENGINE = InnoDB,
 PARTITION p20160921 VALUES LESS THAN ('2016-09-22') ENGINE = InnoDB,
 PARTITION p20160922 VALUES LESS THAN ('2016-09-23') ENGINE = InnoDB,
 PARTITION p20160923 VALUES LESS THAN ('2016-09-24') ENGINE = InnoDB,
 PARTITION p20160924 VALUES LESS THAN ('2016-09-25') ENGINE = InnoDB,
 PARTITION p20160925 VALUES LESS THAN ('2016-09-26') ENGINE = InnoDB,
 PARTITION p20160926 VALUES LESS THAN ('2016-09-27') ENGINE = InnoDB,
 PARTITION p20160927 VALUES LESS THAN ('2016-09-28') ENGINE = InnoDB,
 PARTITION p20160928 VALUES LESS THAN ('2016-09-29') ENGINE = InnoDB,
 PARTITION p20160929 VALUES LESS THAN ('2016-09-30') ENGINE = InnoDB,
 PARTITION p20160930 VALUES LESS THAN ('2016-10-01') ENGINE = InnoDB,
 PARTITION p20161001 VALUES LESS THAN ('2016-10-02') ENGINE = InnoDB,
 PARTITION p20161002 VALUES LESS THAN ('2016-10-03') ENGINE = InnoDB,
 PARTITION p20161003 VALUES LESS THAN ('2016-10-04') ENGINE = InnoDB,
 PARTITION p20161004 VALUES LESS THAN ('2016-10-05') ENGINE = InnoDB,
 PARTITION p20161005 VALUES LESS THAN ('2016-10-06') ENGINE = InnoDB,
 PARTITION p20161006 VALUES LESS THAN ('2016-10-07') ENGINE = InnoDB,
 PARTITION p20161007 VALUES LESS THAN ('2016-10-08') ENGINE = InnoDB,
 PARTITION p20161008 VALUES LESS THAN ('2016-10-09') ENGINE = InnoDB,
 PARTITION p20161009 VALUES LESS THAN ('2016-10-10') ENGINE = InnoDB,
 PARTITION p20161010 VALUES LESS THAN ('2016-10-11') ENGINE = InnoDB,
 PARTITION p20161011 VALUES LESS THAN ('2016-10-12') ENGINE = InnoDB,
 PARTITION p20161012 VALUES LESS THAN ('2016-10-13') ENGINE = InnoDB,
 PARTITION p20161013 VALUES LESS THAN ('2016-10-14') ENGINE = InnoDB,
 PARTITION p20161014 VALUES LESS THAN ('2016-10-15') ENGINE = InnoDB,
 PARTITION p20161015 VALUES LESS THAN ('2016-10-16') ENGINE = InnoDB,
 PARTITION p20161016 VALUES LESS THAN ('2016-10-17') ENGINE = InnoDB,
 PARTITION p20161017 VALUES LESS THAN ('2016-10-18') ENGINE = InnoDB,
 PARTITION p20161018 VALUES LESS THAN ('2016-10-19') ENGINE = InnoDB,
 PARTITION p20161019 VALUES LESS THAN ('2016-10-20') ENGINE = InnoDB,
 PARTITION p20161020 VALUES LESS THAN ('2016-10-21') ENGINE = InnoDB,
 PARTITION p20161021 VALUES LESS THAN ('2016-10-22') ENGINE = InnoDB,
 PARTITION p20161022 VALUES LESS THAN ('2016-10-23') ENGINE = InnoDB,
 PARTITION p20161023 VALUES LESS THAN ('2016-10-24') ENGINE = InnoDB,
 PARTITION p20161024 VALUES LESS THAN ('2016-10-25') ENGINE = InnoDB,
 PARTITION p20161025 VALUES LESS THAN ('2016-10-26') ENGINE = InnoDB,
 PARTITION p20161026 VALUES LESS THAN ('2016-10-27') ENGINE = InnoDB,
 PARTITION p20161027 VALUES LESS THAN ('2016-10-28') ENGINE = InnoDB,
 PARTITION p20161028 VALUES LESS THAN ('2016-10-29') ENGINE = InnoDB,
 PARTITION p20161029 VALUES LESS THAN ('2016-10-30') ENGINE = InnoDB,
 PARTITION p20161030 VALUES LESS THAN ('2016-10-31') ENGINE = InnoDB,
 PARTITION p20161031 VALUES LESS THAN ('2016-11-01') ENGINE = InnoDB,
 PARTITION p20161101 VALUES LESS THAN ('2016-11-02') ENGINE = InnoDB,
 PARTITION p20161102 VALUES LESS THAN ('2016-11-03') ENGINE = InnoDB,
 PARTITION p20161103 VALUES LESS THAN ('2016-11-04') ENGINE = InnoDB,
 PARTITION p20161104 VALUES LESS THAN ('2016-11-05') ENGINE = InnoDB,
 PARTITION p20161105 VALUES LESS THAN ('2016-11-06') ENGINE = InnoDB,
 PARTITION p20161106 VALUES LESS THAN ('2016-11-07') ENGINE = InnoDB,
 PARTITION p20161107 VALUES LESS THAN ('2016-11-08') ENGINE = InnoDB,
 PARTITION p20161108 VALUES LESS THAN ('2016-11-09') ENGINE = InnoDB,
 PARTITION p20161109 VALUES LESS THAN ('2016-11-10') ENGINE = InnoDB,
 PARTITION p20161110 VALUES LESS THAN ('2016-11-11') ENGINE = InnoDB,
 PARTITION p20161111 VALUES LESS THAN ('2016-11-12') ENGINE = InnoDB,
 PARTITION p20161112 VALUES LESS THAN ('2016-11-13') ENGINE = InnoDB,
 PARTITION p20161113 VALUES LESS THAN ('2016-11-14') ENGINE = InnoDB,
 PARTITION p20161114 VALUES LESS THAN ('2016-11-15') ENGINE = InnoDB,
 PARTITION p20161115 VALUES LESS THAN ('2016-11-16') ENGINE = InnoDB,
 PARTITION p20161116 VALUES LESS THAN ('2016-11-17') ENGINE = InnoDB,
 PARTITION p20161117 VALUES LESS THAN ('2016-11-18') ENGINE = InnoDB,
 PARTITION p20161118 VALUES LESS THAN ('2016-11-19') ENGINE = InnoDB,
 PARTITION p20161119 VALUES LESS THAN ('2016-11-20') ENGINE = InnoDB,
 PARTITION p20161120 VALUES LESS THAN ('2016-11-21') ENGINE = InnoDB,
 PARTITION p20161121 VALUES LESS THAN ('2016-11-22') ENGINE = InnoDB,
 PARTITION p20161122 VALUES LESS THAN ('2016-11-23') ENGINE = InnoDB,
 PARTITION p20161123 VALUES LESS THAN ('2016-11-24') ENGINE = InnoDB,
 PARTITION p20161124 VALUES LESS THAN ('2016-11-25') ENGINE = InnoDB,
 PARTITION p20161125 VALUES LESS THAN ('2016-11-26') ENGINE = InnoDB,
 PARTITION p20161126 VALUES LESS THAN ('2016-11-27') ENGINE = InnoDB,
 PARTITION p20161127 VALUES LESS THAN ('2016-11-28') ENGINE = InnoDB,
 PARTITION p20161128 VALUES LESS THAN ('2016-11-29') ENGINE = InnoDB,
 PARTITION p20161129 VALUES LESS THAN ('2016-11-30') ENGINE = InnoDB,
 PARTITION p20161130 VALUES LESS THAN ('2016-12-01') ENGINE = InnoDB,
 PARTITION p20161201 VALUES LESS THAN ('2016-12-02') ENGINE = InnoDB,
 PARTITION p20161202 VALUES LESS THAN ('2016-12-03') ENGINE = InnoDB,
 PARTITION p20161203 VALUES LESS THAN ('2016-12-04') ENGINE = InnoDB,
 PARTITION p20161204 VALUES LESS THAN ('2016-12-05') ENGINE = InnoDB,
 PARTITION p20161205 VALUES LESS THAN ('2016-12-06') ENGINE = InnoDB,
 PARTITION p20161206 VALUES LESS THAN ('2016-12-07') ENGINE = InnoDB,
 PARTITION p20161207 VALUES LESS THAN ('2016-12-08') ENGINE = InnoDB,
 PARTITION p20161208 VALUES LESS THAN ('2016-12-09') ENGINE = InnoDB,
 PARTITION p20161209 VALUES LESS THAN ('2016-12-10') ENGINE = InnoDB,
 PARTITION p20161210 VALUES LESS THAN ('2016-12-11') ENGINE = InnoDB,
 PARTITION p20161211 VALUES LESS THAN ('2016-12-12') ENGINE = InnoDB,
 PARTITION p20161212 VALUES LESS THAN ('2016-12-13') ENGINE = InnoDB,
 PARTITION p20161213 VALUES LESS THAN ('2016-12-14') ENGINE = InnoDB,
 PARTITION p20161214 VALUES LESS THAN ('2016-12-15') ENGINE = InnoDB,
 PARTITION p20161215 VALUES LESS THAN ('2016-12-16') ENGINE = InnoDB,
 PARTITION p20161216 VALUES LESS THAN ('2016-12-17') ENGINE = InnoDB,
 PARTITION p20161217 VALUES LESS THAN ('2016-12-18') ENGINE = InnoDB,
 PARTITION p20161218 VALUES LESS THAN ('2016-12-19') ENGINE = InnoDB,
 PARTITION p20161219 VALUES LESS THAN ('2016-12-20') ENGINE = InnoDB,
 PARTITION p20161220 VALUES LESS THAN ('2016-12-21') ENGINE = InnoDB,
 PARTITION p20161221 VALUES LESS THAN ('2016-12-22') ENGINE = InnoDB,
 PARTITION p20161222 VALUES LESS THAN ('2016-12-23') ENGINE = InnoDB,
 PARTITION p20161223 VALUES LESS THAN ('2016-12-24') ENGINE = InnoDB,
 PARTITION p20161224 VALUES LESS THAN ('2016-12-25') ENGINE = InnoDB,
 PARTITION p20161225 VALUES LESS THAN ('2016-12-26') ENGINE = InnoDB,
 PARTITION p20161226 VALUES LESS THAN ('2016-12-27') ENGINE = InnoDB,
 PARTITION p20161227 VALUES LESS THAN ('2016-12-28') ENGINE = InnoDB,
 PARTITION p20161228 VALUES LESS THAN ('2016-12-29') ENGINE = InnoDB,
 PARTITION p20161229 VALUES LESS THAN ('2016-12-30') ENGINE = InnoDB,
 PARTITION p20161230 VALUES LESS THAN ('2016-12-31') ENGINE = InnoDB,
 PARTITION p20161231 VALUES LESS THAN ('2017-01-01') ENGINE = InnoDB,
 PARTITION p20170101 VALUES LESS THAN ('2017-01-02') ENGINE = InnoDB,
 PARTITION p20170102 VALUES LESS THAN ('2017-01-03') ENGINE = InnoDB,
 PARTITION p20170103 VALUES LESS THAN ('2017-01-04') ENGINE = InnoDB,
 PARTITION p20170104 VALUES LESS THAN ('2017-01-05') ENGINE = InnoDB,
 PARTITION p20170105 VALUES LESS THAN ('2017-01-06') ENGINE = InnoDB,
 PARTITION p20170106 VALUES LESS THAN ('2017-01-07') ENGINE = InnoDB,
 PARTITION p20170107 VALUES LESS THAN ('2017-01-08') ENGINE = InnoDB,
 PARTITION p20170108 VALUES LESS THAN ('2017-01-09') ENGINE = InnoDB,
 PARTITION p20170109 VALUES LESS THAN ('2017-01-10') ENGINE = InnoDB,
 PARTITION p20170110 VALUES LESS THAN ('2017-01-11') ENGINE = InnoDB,
 PARTITION p20170111 VALUES LESS THAN ('2017-01-12') ENGINE = InnoDB,
 PARTITION p20170112 VALUES LESS THAN ('2017-01-13') ENGINE = InnoDB,
 PARTITION p20170113 VALUES LESS THAN ('2017-01-14') ENGINE = InnoDB,
 PARTITION p20170114 VALUES LESS THAN ('2017-01-15') ENGINE = InnoDB,
 PARTITION p20170115 VALUES LESS THAN ('2017-01-16') ENGINE = InnoDB,
 PARTITION p20170116 VALUES LESS THAN ('2017-01-17') ENGINE = InnoDB,
 PARTITION p20170117 VALUES LESS THAN ('2017-01-18') ENGINE = InnoDB,
 PARTITION p20170118 VALUES LESS THAN ('2017-01-19') ENGINE = InnoDB,
 PARTITION p20170119 VALUES LESS THAN ('2017-01-20') ENGINE = InnoDB,
 PARTITION p20170120 VALUES LESS THAN ('2017-01-21') ENGINE = InnoDB,
 PARTITION p20170121 VALUES LESS THAN ('2017-01-22') ENGINE = InnoDB,
 PARTITION p20170122 VALUES LESS THAN ('2017-01-23') ENGINE = InnoDB,
 PARTITION p20170123 VALUES LESS THAN ('2017-01-24') ENGINE = InnoDB,
 PARTITION p20170124 VALUES LESS THAN ('2017-01-25') ENGINE = InnoDB,
 PARTITION p20170125 VALUES LESS THAN ('2017-01-26') ENGINE = InnoDB,
 PARTITION p20170126 VALUES LESS THAN ('2017-01-27') ENGINE = InnoDB,
 PARTITION p20170127 VALUES LESS THAN ('2017-01-28') ENGINE = InnoDB,
 PARTITION p20170128 VALUES LESS THAN ('2017-01-29') ENGINE = InnoDB,
 PARTITION p20170129 VALUES LESS THAN ('2017-01-30') ENGINE = InnoDB,
 PARTITION p20170130 VALUES LESS THAN ('2017-01-31') ENGINE = InnoDB,
 PARTITION p20170131 VALUES LESS THAN ('2017-02-01') ENGINE = InnoDB,
 PARTITION p20170201 VALUES LESS THAN ('2017-02-02') ENGINE = InnoDB,
 PARTITION p20170202 VALUES LESS THAN ('2017-02-03') ENGINE = InnoDB,
 PARTITION p20170203 VALUES LESS THAN ('2017-02-04') ENGINE = InnoDB,
 PARTITION p20170204 VALUES LESS THAN ('2017-02-05') ENGINE = InnoDB,
 PARTITION p20170205 VALUES LESS THAN ('2017-02-06') ENGINE = InnoDB,
 PARTITION p20170206 VALUES LESS THAN ('2017-02-07') ENGINE = InnoDB,
 PARTITION p20170207 VALUES LESS THAN ('2017-02-08') ENGINE = InnoDB,
 PARTITION p20170208 VALUES LESS THAN ('2017-02-09') ENGINE = InnoDB,
 PARTITION p20170209 VALUES LESS THAN ('2017-02-10') ENGINE = InnoDB,
 PARTITION p20170210 VALUES LESS THAN ('2017-02-11') ENGINE = InnoDB,
 PARTITION p20170211 VALUES LESS THAN ('2017-02-12') ENGINE = InnoDB,
 PARTITION p20170212 VALUES LESS THAN ('2017-02-13') ENGINE = InnoDB,
 PARTITION p20170213 VALUES LESS THAN ('2017-02-14') ENGINE = InnoDB,
 PARTITION p20170214 VALUES LESS THAN ('2017-02-15') ENGINE = InnoDB,
 PARTITION p20170215 VALUES LESS THAN ('2017-02-16') ENGINE = InnoDB,
 PARTITION p20170216 VALUES LESS THAN ('2017-02-17') ENGINE = InnoDB,
 PARTITION p20170217 VALUES LESS THAN ('2017-02-18') ENGINE = InnoDB,
 PARTITION p20170218 VALUES LESS THAN ('2017-02-19') ENGINE = InnoDB,
 PARTITION p20170219 VALUES LESS THAN ('2017-02-20') ENGINE = InnoDB,
 PARTITION p20170220 VALUES LESS THAN ('2017-02-21') ENGINE = InnoDB,
 PARTITION p20170221 VALUES LESS THAN ('2017-02-22') ENGINE = InnoDB,
 PARTITION p20170222 VALUES LESS THAN ('2017-02-23') ENGINE = InnoDB,
 PARTITION p20170223 VALUES LESS THAN ('2017-02-24') ENGINE = InnoDB,
 PARTITION p20170224 VALUES LESS THAN ('2017-02-25') ENGINE = InnoDB,
 PARTITION p20170225 VALUES LESS THAN ('2017-02-26') ENGINE = InnoDB,
 PARTITION p20170226 VALUES LESS THAN ('2017-02-27') ENGINE = InnoDB,
 PARTITION p20170227 VALUES LESS THAN ('2017-02-28') ENGINE = InnoDB,
 PARTITION p20170228 VALUES LESS THAN ('2017-03-01') ENGINE = InnoDB);

2) Insert random data in the table:

DELIMITER $$
CREATE PROCEDURE fill_large_table()
BEGIN
DECLARE sid INT ;
DECLARE id INT ;
DECLARE prior INT ;
DECLARE date date ;
DECLARE date_p date ;
 
SET sid = 100000 ;
SET id = 1 ;
SET prior = 1 ;
SET date =  '2017:02:28' ;
SET date_p = '2017:02:27' ;
 
WHILE sid  <= 200000 DO
insert into large_table (sid,id,effective_through) values (prior,id,date_p), (sid,id,date);
SET sid = sid + 1 ; 
SET prior = prior + 1 ;
SET id = id + 1;
END WHILE; 
END$$
DELIMITER ;

call fill_large_table();

3) Execute large update in this table:

update `large_table` n inner join `large_table` o
on n.effective_through = '2017-02-28' and o.effective_through = date_sub('2017-02-28', interval 1 day) and
n.id = o.id
set n.prior = o.sid
where n.effective_through = '2017-02-28'; 

4) Check replication lag using show slave status. Compare replication performance with MySQL version 5.5 or with unpartitioned table.