Percona Server moved to https://jira.percona.com/projects/PS

PXC uses all partitions instead of only the necessary ones when using CASE THEN ELSE END

Series 5.6
Bug #1304610

Bug #1304610 reported by Alex Smith on 2014-04-08

This bug affects 1 person

	Status	Importance	Assigned to
MySQL Server	Unknown	Unknown	mysql-bugs #73094
Percona Server moved to https://jira.percona.com/projects/PS	Status tracked in 5.7
5.1	Won't Fix	Undecided	Unassigned
5.5	Triaged	Medium	Unassigned
5.6	Triaged	Medium	Unassigned
5.7	Triaged	Medium	Unassigned

Bug Description

When using a CASE WHEN THEN ELSE END condition to build the Where clause of a query, MySQL will search ALL of that tables partitions instead of just the ones the Where clause should be limiting it to.

EXPLAIN PARTITIONS SELECT COUNT( * ) AS Count
FROM GPSI.tblDataSentSMS du
JOIN GPSI.vwUnits un ON ( du.ESN = un.ESN
AND un.CarrierName = 'Cingular' )
WHERE
CASE
WHEN DATE_FORMAT( NOW( ) , '%e' ) <=8
THEN du.DateSent
BETWEEN DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-9' ) , INTERVAL 1
MONTH )
AND DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) , INTERVAL 1
DAY )
ELSE du.DateSent
BETWEEN DATE_FORMAT( NOW( ) , '%Y-%m-09' )
AND DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) , INTERVAL 1
DAY )
END\G

I get

*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblCellularCarriers
   partitions: NULL
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 50
          ref: const
         rows: 2
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblUnits
   partitions: NULL
         type: ALL
possible_keys: ESN
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 542853
        Extra: Using where; Using join buffer
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: du
   partitions: P21Nov2012,P22Nov2012,P23Nov2012,P24Nov2012,P25Nov2012,P26Nov2012,P27Nov2012,P28Nov2012,P29Nov2012,P30Nov2012,P01Dec2012,P02Dec2012,P03Dec2012,P04Dec2012,P05Dec2012,P06Dec2012,P07Dec2012,P08Dec2012,P09Dec2012,P10Dec2012,P11Dec2012,P12Dec2012,P13Dec2012,P14Dec2012,P15Dec2012,P16Dec2012,P17Dec2012,P18Dec2012,P19Dec2012,P20Dec2012,P21Dec2012,P22Dec2012,P23Dec2012,P24Dec2012,P25Dec2012,P26Dec2012,P27Dec2012,P28Dec2012,P29Dec2012,P30Dec2012,P31Dec2012,P01Jan2013,P02Jan2013,P03Jan2013,P04Jan2013,P05Jan2013,P06Jan2013,P07Jan2013,P08Jan2013,P09Jan2013,P10Jan2013,P11Jan2013,P12Jan2013,P13Jan2013,P14Jan2013,P15Jan2013,P16Jan2013,P17Jan2013,P18Jan2013,P19Jan2013,P20Jan2013,P21Jan2013,P22Jan2013,P23Jan2013,P24Jan2013,P25Jan2013,P26Jan2013,P27Jan2013,P28Jan2013,P29Jan2013,P30Jan2013,P31Jan2013,P01Feb2013,P02Feb2013,P03Feb2013,P04Feb2013,P05Feb2013,P06Feb2013,P07Feb2013,P08Feb2013,P09Feb2013,P10Feb2013,P11Feb2013,P12Feb2013,P13Feb2013,P14Feb2013,P15Feb2013,P16Feb2013,P17Feb2013,P18Feb2013,P19Feb2013,P20Feb2013,P21Feb2013,P22Feb2013,P23Feb2013,P24Feb2013,P25Feb2013,P26Feb2013,P27Feb2013,P28Feb2013,P01Mar2013,P02Mar2013,P03Mar2013,P04Mar2013,P05Mar2013,P06Mar2013,P07Mar2013,P08Mar2013,P09Mar2013,P10Mar2013,P11Mar2013,P12Mar2013,P13Mar2013,P14Mar2013,P15Mar2013,P16Mar2013,P17Mar2013,P18Mar2013,P19Mar2013,P20Mar2013,P21Mar2013,P22Mar2013,P23Mar2013,P24Mar2013,P25Mar2013,P26Mar2013,P27Mar2013,P28Mar2013,P29Mar2013,P30Mar2013,P31Mar2013,P01Apr2013,P02Apr2013,P03Apr2013,P04Apr2013,P05Apr2013,P06Apr2013,P07Apr2013,P08Apr2013,P09Apr2013,P10Apr2013,P11Apr2013,P12Apr2013,P13Apr2013,P14Apr2013,P15Apr2013,P16Apr2013,P17Apr2013,P18Apr2013,P19Apr2013,P20Apr2013,P21Apr2013,P22Apr2013,P23Apr2013,P24Apr2013,P25Apr2013,P26Apr2013,P27Apr2013,P28Apr2013,P29Apr2013,P30Apr2013,P01May2013,P02May2013,P03May2013,P04May2013,P05May2013,P06May2013,P07May2013,P08May2013,P09May2013,P10May2013,P11May2013,P12May2013,P13May2013,P14May2013,P15May2013,P16May2013,P17May2013,P18May2013,P19May2013,P20May2013,P21May2013,P22May2013,P23May2013,P24May2013,P25May2013,P26May2013,P27May2013,P28May2013,P29May2013,P30May2013,P31May2013,P01Jun2013,P02Jun2013,P03Jun2013,P04Jun2013,P05Jun2013,P06Jun2013,P07Jun2013,P08Jun2013,P09Jun2013,P10Jun2013,P11Jun2013,P12Jun2013,P13Jun2013,P14Jun2013,P15Jun2013,P16Jun2013,P17Jun2013,P18Jun2013,P19Jun2013,P20Jun2013,P21Jun2013,P22Jun2013,P23Jun2013,P24Jun2013,P25Jun2013,P26Jun2013,P27Jun2013,P28Jun2013,P29Jun2013,P30Jun2013,P01Jul2013,P02Jul2013,P03Jul2013,P04Jul2013,P05Jul2013,P06Jul2013,P07Jul2013,P08Jul2013,P09Jul2013,P10Jul2013,P11Jul2013,P12Jul2013,P13Jul2013,P14Jul2013,P15Jul2013,P16Jul2013,P17Jul2013,P18Jul2013,P19Jul2013,P20Jul2013,P21Jul2013,P22Jul2013,P23Jul2013,P24Jul2013,P25Jul2013,P26Jul2013,P27Jul2013,P28Jul2013,P29Jul2013,P30Jul2013,P31Jul2013,P01Aug2013,P02Aug2013,P03Aug2013,P04Aug2013,P05Aug2013,P06Aug2013,P07Aug2013,P08Aug2013,P09Aug2013,P10Aug2013,P11Aug2013,P12Aug2013,P13Aug2013,P14Aug2013,P15Aug2013,P16Aug2013,P17Aug2013,P18Aug2013,P19Aug2013,P20Aug2013,P21Aug2013,P22Aug2013,P23Aug2013,P24Aug2013,P25Aug2013,P26Aug2013,P27Aug2013,P28Aug2013,P29Aug2013,P30Aug2013,P31Aug2013,P01Sep2013,P02Sep2013,P03Sep2013,P04Sep2013,P05Sep2013,P06Sep2013,P07Sep2013,P08Sep2013,P09Sep2013,P10Sep2013,P11Sep2013,P12Sep2013,P13Sep2013,P14Sep2013,P15Sep2013,P16Sep2013,P17Sep2013,P18Sep2013,P19Sep2013,P20Sep2013,P21Sep2013,P22Sep2013,P23Sep2013,P24Sep2013,P25Sep2013,P26Sep2013,P27Sep2013,P28Sep2013,P29Sep2013,P30Sep2013,P01Oct2013,P02Oct2013,P03Oct2013,P04Oct2013,P05Oct2013,P06Oct2013,P07Oct2013,P08Oct2013,P09Oct2013,P10Oct2013,P11Oct2013,P12Oct2013,P13Oct2013,P14Oct2013,P15Oct2013,P16Oct2013,P17Oct2013,P18Oct2013,P19Oct2013,P20Oct2013,P21Oct2013,P22Oct2013,P23Oct2013,P24Oct2013,P25Oct2013,P26Oct2013,P27Oct2013,P28Oct2013,P29Oct2013,P30Oct2013,P31Oct2013,P01Nov2013,P02Nov2013,P03Nov2013,P04Nov2013,P05Nov2013,P06Nov2013,P07Nov2013,P08Nov2013,P09Nov2013,P10Nov2013,P11Nov2013,P12Nov2013,P13Nov2013,P14Nov2013,P15Nov2013,P16Nov2013,P17Nov2013,P18Nov2013,P19Nov2013,P20Nov2013,P21Nov2013,P22Nov2013,P23Nov2013,P24Nov2013,P25Nov2013,P26Nov2013,P27Nov2013,P28Nov2013,P29Nov2013,P30Nov2013,P01Dec2013,P02Dec2013,P03Dec2013,P04Dec2013,P05Dec2013,P06Dec2013,P07Dec2013,P08Dec2013,P09Dec2013,P10Dec2013,P11Dec2013,P12Dec2013,P13Dec2013,P14Dec2013,P15Dec2013,P16Dec2013,P17Dec2013,P18Dec2013,P19Dec2013,P20Dec2013,P21Dec2013,P22Dec2013,P23Dec2013,P24Dec2013,P25Dec2013,P26Dec2013,P27Dec2013,P28Dec2013,P29Dec2013,P30Dec2013,P31Dec2013,P01Jan2014,P02Jan2014,P03Jan2014,P04Jan2014,P05Jan2014,P06Jan2014,P07Jan2014,P08Jan2014,P09Jan2014,P10Jan2014,P11Jan2014,P12Jan2014,P13Jan2014,P14Jan2014,P15Jan2014,P16Jan2014,P17Jan2014,P18Jan2014,P19Jan2014,P20Jan2014,P21Jan2014,P22Jan2014,P23Jan2014,P24Jan2014,P25Jan2014,P26Jan2014,P27Jan2014,P28Jan2014,P29Jan2014,P30Jan2014,P31Jan2014,P01Feb2014,P02Feb2014,P03Feb2014,P04Feb2014,P05Feb2014,P06Feb2014,P07Feb2014,P08Feb2014,P09Feb2014,P10Feb2014,P11Feb2014,P12Feb2014,P13Feb2014,P14Feb2014,P15Feb2014,P16Feb2014,P17Feb2014,P18Feb2014,P19Feb2014,P20Feb2014,P21Feb2014,P22Feb2014,P23Feb2014,P24Feb2014,P25Feb2014,P26Feb2014,P27Feb2014,P28Feb2014,P01Mar2014,P02Mar2014,P03Mar2014,P04Mar2014,P05Mar2014,P06Mar2014,P07Mar2014,P08Mar2014,P09Mar2014,P10Mar2014,P11Mar2014,P12Mar2014,P13Mar2014,P14Mar2014,P15Mar2014,P16Mar2014,P17Mar2014,P18Mar2014,P19Mar2014,P20Mar2014,P21Mar2014,P22Mar2014,P23Mar2014,P24Mar2014,P25Mar2014,P26Mar2014,P27Mar2014,P28Mar2014,P29Mar2014,P30Mar2014,P31Mar2014,P01Apr2014,P02Apr2014,P03Apr2014,P04Apr2014,P05Apr2014,P06Apr2014,P07Apr2014,P08Apr2014,P09Apr2014,P10Apr2014,P11Apr2014,P12Apr2014,P13Apr2014,P14Apr2014,P15Apr2014,P16Apr2014,P17Apr2014,P18Apr2014,P19Apr2014,P20Apr2014,P21Apr2014,P22Apr2014,P23Apr2014,P24Apr2014,P25Apr2014,P26Apr2014,P27Apr2014,P28Apr2014,P29Apr2014,P30Apr2014,P01May2014,P02May2014,P03May2014,P04May2014,P05May2014,P06May2014,P07May2014,P08May2014,P09May2014,P10May2014,P11May2014,P12May2014,P13May2014,P14May2014,P15May2014,P16May2014,P17May2014,P18May2014,P19May2014,P20May2014,P21May2014,P22May2014,P23May2014,P24May2014,P25May2014,P26May2014,P27May2014,P28May2014,P29May2014,P30May2014,P31May2014,P01Jun2014,P02Jun2014,P03Jun2014,P04Jun2014,P05Jun2014,P06Jun2014,P07Jun2014,P08Jun2014,P09Jun2014,P10Jun2014,P11Jun2014,P12Jun2014,P13Jun2014,P14Jun2014,P15Jun2014,P16Jun2014,P17Jun2014,P18Jun2014,P19Jun2014,P20Jun2014,P21Jun2014,P22Jun2014,P23Jun2014,P24Jun2014,P25Jun2014,P26Jun2014,P27Jun2014,P28Jun2014,P29Jun2014,P30Jun2014,P01Jul2014,P02Jul2014,P03Jul2014,P04Jul2014,P05Jul2014,P06Jul2014,P07Jul2014,P08Jul2014,P09Jul2014,P10Jul2014,P11Jul2014,P12Jul2014,P13Jul2014,P14Jul2014,P15Jul2014,P16Jul2014,P17Jul2014,P18Jul2014,P19Jul2014,P20Jul2014,P21Jul2014,P22Jul2014,P23Jul2014,P24Jul2014,P25Jul2014,P26Jul2014,P27Jul2014,P28Jul2014,P29Jul2014,P30Jul2014,P31Jul2014,P01Aug2014,P02Aug2014,P03Aug2014,P04Aug2014,P05Aug2014,P06Aug2014,P07Aug2014,P08Aug2014,P09Aug2014,P10Aug2014,P11Aug2014,P12Aug2014,P13Aug2014,P14Aug2014,P15Aug2014,P16Aug2014,P17Aug2014,P18Aug2014,P19Aug2014,P20Aug2014,P21Aug2014,P22Aug2014,P23Aug2014,P24Aug2014,P25Aug2014,P26Aug2014,P27Aug2014,P28Aug2014,P29Aug2014,P30Aug2014,P31Aug2014,P01Sep2014,P02Sep2014,P03Sep2014,P04Sep2014,P05Sep2014,P06Sep2014,P07Sep2014,P08Sep2014,P09Sep2014,P10Sep2014,P11Sep2014,P12Sep2014,P13Sep2014,P14Sep2014,P15Sep2014,P16Sep2014,P17Sep2014,P18Sep2014,P19Sep2014,P20Sep2014,P21Sep2014,P22Sep2014,P23Sep2014,P24Sep2014,P25Sep2014,P26Sep2014,P27Sep2014,P28Sep2014,P29Sep2014,P30Sep2014,P01Oct2014,P02Oct2014,P03Oct2014,P04Oct2014,P05Oct2014,P06Oct2014,P07Oct2014,P08Oct2014,P09Oct2014,P10Oct2014,P11Oct2014,P12Oct2014,P13Oct2014,P14Oct2014,P15Oct2014,P16Oct2014,P17Oct2014,P18Oct2014,P19Oct2014,P20Oct2014,P21Oct2014,P22Oct2014,P23Oct2014,P24Oct2014,P25Oct2014,P26Oct2014,P27Oct2014,P28Oct2014,P29Oct2014,P30Oct2014,P31Oct2014,P01Nov2014,P02Nov2014,P03Nov2014,P04Nov2014,P05Nov2014,P06Nov2014,P07Nov2014,P08Nov2014,P09Nov2014,P10Nov2014,P11Nov2014,P12Nov2014,P13Nov2014,P14Nov2014,P15Nov2014,P16Nov2014,P17Nov2014,P18Nov2014,P19Nov2014,P20Nov2014,P21Nov2014,P22Nov2014,P23Nov2014,P24Nov2014,P25Nov2014,P26Nov2014,P27Nov2014,P28Nov2014,P29Nov2014,P30Nov2014,P01Dec2014,P02Dec2014,P03Dec2014,P04Dec2014,P05Dec2014,P06Dec2014,P07Dec2014,P08Dec2014,P09Dec2014,P10Dec2014,P11Dec2014,P12Dec2014,P13Dec2014,P14Dec2014,P15Dec2014,P16Dec2014,P17Dec2014,P18Dec2014,P19Dec2014,P20Dec2014,P21Dec2014,P22Dec2014,P23Dec2014,P24Dec2014,P25Dec2014,P26Dec2014,P27Dec2014,P28Dec2014,P29Dec2014,P30Dec2014,P31Dec2014,P01Jan2015,P02Jan2015,P03Jan2015,P04Jan2015,P05Jan2015,P06Jan2015,P07Jan2015,P08Jan2015,P09Jan2015,P10Jan2015,P11Jan2015,P12Jan2015,P13Jan2015,P14Jan2015,P15Jan2015,P16Jan2015,P17Jan2015,P18Jan2015,P19Jan2015,P20Jan2015,P21Jan2015,P22Jan2015,P23Jan2015,P24Jan2015,P25Jan2015,P26Jan2015,P27Jan2015,P28Jan2015,P29Jan2015,P30Jan2015,P31Jan2015,P01Feb2015,P02Feb2015,P03Feb2015,P04Feb2015,P05Feb2015,P06Feb2015,P07Feb2015,P08Feb2015,P09Feb2015,P10Feb2015,P11Feb2015,P12Feb2015,P13Feb2015,P14Feb2015,P15Feb2015,P16Feb2015,P17Feb2015,P18Feb2015,P19Feb2015,P20Feb2015,P21Feb2015,P22Feb2015,P23Feb2015,P24Feb2015,P25Feb2015,P26Feb2015,P27Feb2015,P28Feb2015,P01Mar2015,P02Mar2015,P03Mar2015,P04Mar2015,P05Mar2015,P06Mar2015,P07Mar2015,P08Mar2015,P09Mar2015,P10Mar2015,P11Mar2015,P12Mar2015,P13Mar2015,P14Mar2015,P15Mar2015,P16Mar2015,P17Mar2015,P18Mar2015,P19Mar2015,P20Mar2015,P21Mar2015,P22Mar2015,P23Mar2015,P24Mar2015,P25Mar2015,P26Mar2015,P27Mar2015,P28Mar2015,P29Mar2015,P30Mar2015,P31Mar2015,P01Apr2015,PMaxValue
         type: ref
possible_keys: ESN
          key: ESN
      key_len: 21
          ref: func
         rows: 22
        Extra: Using where; Using index
*************************** 4. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblModelPrefixes
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 26
        Extra:

If I reduce the above query to the case which will return based off of the given condition I get this:

mysql> explain partitions (SELECT count(*) as Count FROM GPSI.tblDataSentSMS du
    -> JOIN GPSI.vwUnits un on (du.ESN = un.ESN and un.CarrierName = 'Cingular')
    -> WHERE du.DateSent Between DATE_SUB(date_format(now(), '%Y-%m-9'), interval 1 MONTH) AND DATE_SUB(date_format(now(), '%Y-%m-%d'), interval 1 day))\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblCellularCarriers
   partitions: NULL
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 50
          ref: const
         rows: 2
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: du
   partitions: P21Nov2012,P10Mar2014,P11Mar2014,P12Mar2014,P13Mar2014,P14Mar2014,P15Mar2014,P16Mar2014,P17Mar2014,P18Mar2014,P19Mar2014,P20Mar2014,P21Mar2014,P22Mar2014,P23Mar2014,P24Mar2014,P25Mar2014,P26Mar2014,P27Mar2014,P28Mar2014,P29Mar2014,P30Mar2014,P31Mar2014,P01Apr2014,P02Apr2014,P03Apr2014,P04Apr2014,P05Apr2014,P06Apr2014,P07Apr2014,P08Apr2014
         type: index
possible_keys: ESN
          key: ESN
      key_len: 21
          ref: NULL
         rows: 986889
        Extra: Using where; Using index; Using join buffer
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblUnits
   partitions: NULL
         type: eq_ref
possible_keys: ESN
          key: ESN
      key_len: 16
          ref: GPSI.du.ESN
         rows: 1
        Extra: Using where
*************************** 4. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblModelPrefixes
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 26
        Extra:
4 rows in set (0.01 sec)

You can see that ONLY the partitions that matter are scanned. But I would expect the first query to do the same thing.

I have to build my where condition in PHP first do achieve the results that I'm looking for without the query taking forever to run because of all the loockups it's trying.

Tags:

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2014-04-08:

@Alex,

Can you reproduce this with PS as well? This is because PXC
usually doesn't touch much of parser/optimizer bits.

Revision history for this message

Alex Smith (q-alex-k) wrote on 2014-04-09:

@raghavendra

Unfortunately, I do not have the resources to test that.
If I can find a non used machine, I'll try setting up PS and making a partitioned table, fill it with data and then run some queries against it with the WHEN CASE THEN ELSE END statements in it like the original query.

Revision history for this message

Valerii Kravchuk (valerii-kravchuk) wrote on 2014-04-09:

Please, send the output of:

show create table tblDataSentSMS\G

and, if possible, CREATE VIEW for vwUnits (and corresponding CREATE TABLE statements for tables it refers to).

What exact PXC version do you use?

Changed in percona-server:
status:	New → Incomplete

Revision history for this message

Alex Smith (q-alex-k) wrote on 2014-04-09:

Download full text (62.9 KiB)

Here is my version:
mysql> SHOW VARIABLES LIKE "%version%"\G
*************************** 1. row ***************************
Variable_name: innodb_version
        Value: 5.5.34-rel32.0
*************************** 2. row ***************************
Variable_name: protocol_version
        Value: 10
*************************** 3. row ***************************
Variable_name: slave_type_conversions
        Value:
*************************** 4. row ***************************
Variable_name: version
        Value: 5.5.34-34.1-log
*************************** 5. row ***************************
Variable_name: version_comment
        Value: Percona XtraDB Cluster (GPL), Release 34.1, wsrep_23.7.6.r3936
*************************** 6. row ***************************
Variable_name: version_compile_machine
        Value: x86_64
*************************** 7. row ***************************
Variable_name: version_compile_os
        Value: Linux
7 rows in set (0.00 sec)

----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------

mysql> show create table tblDataSentSMS\G
*************************** 1. row ***************************
       Table: tblDataSentSMS
Create Table: CREATE TABLE `tblDataSentSMS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ESN` char(20) DEFAULT NULL,
  `SMSMethod` enum('HTTP','SMTP','SMPP') NOT NULL,
  `DateSent` datetime NOT NULL,
  `ICCID` char(22) DEFAULT NULL,
  `MSISDN` char(10) NOT NULL,
  `RatePlan` char(4) DEFAULT NULL,
  `Bytes` mediumint(9) NOT NULL,
  `Msg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`,`DateSent`),
  KEY `ESN` (`ESN`),
  KEY `ICCID` (`ICCID`),
  KEY `MSISDN` (`MSISDN`),
  KEY `Msg` (`Msg`)
) ENGINE=InnoDB AUTO_INCREMENT=40075202 DEFAULT CHARSET=latin1 COMMENT='Record of SMS messages sent to units'
/*!50100 PARTITION BY RANGE ( TO_DAYS(DateSent))
(PARTITION P21Nov2012 VALUES LESS THAN (735193) ENGINE = InnoDB,
 PARTITION P22Nov2012 VALUES LESS THAN (735194) ENGINE = InnoDB,
 PARTITION P23Nov2012 VALUES LESS THAN (735195) ENGINE = InnoDB,
 PARTITION P24Nov2012 VALUES LESS THAN (735196) ENGINE = InnoDB,
 PARTITION P25Nov2012 VALUES LESS THAN (735197) ENGINE = InnoDB,
 PARTITION P26Nov2012 VALUES LESS THAN (735198) ENGINE = InnoDB,
 PARTITION P27Nov2012 VALUES LESS THAN (735199) ENGINE = InnoDB,
 PARTITION P28Nov2012 VALUES LESS THAN (735200) ENGINE = InnoDB,
 PARTITION P29Nov2012 VALUES LESS THAN (735201) ENGINE = InnoDB,
 PARTITION P30Nov2012 VALUES LESS THAN (735202) ENGINE = InnoDB,
 PARTITION P01Dec2012 VALUES LESS THAN (735203) ENGINE = InnoDB,
 PARTITION P02Dec2012 VALUES LESS THAN (735204) ENGINE = InnoDB,
 PARTITION P03Dec2012 VALUES LESS THAN (735205) ENGINE = InnoDB,
 PARTITION P04Dec2012 VALUES LESS THAN (735206) ENGINE = InnoDB,
 PARTITION P05Dec2012 VALUES LESS THAN (735207) ENGINE = InnoDB,
 PARTITION P06Dec2012 VALUES LESS THAN (735208) ENGINE = InnoDB,
 PARTITION P07Dec2012 VALUES LESS THAN (735209) ENGINE = InnoDB,
 PARTITION P08Dec2012 VALUES LESS THAN (735210) ENGINE = InnoDB,
 PARTITION P09Dec2012 VALUES LESS THAN (735211) ENGINE = InnoDB,
 PARTITION P10Dec2012 VALUES LESS THAN (735212) ENGINE = InnoDB,
 PARTITION P11Dec2012 VALUES LESS THAN (735213) ENGINE = InnoDB,
 PARTITION P12Dec2012 VALUES LESS THAN (735214) ENGINE = InnoDB,
 PARTITION P13Dec2012 VALUES LESS THAN (735215) ENGINE = InnoDB,
 PARTITION P14Dec2012 VALUES LESS THAN (735216) ENGINE = InnoDB,
 PARTITION P15Dec2012 VALUES LESS THAN (735217) ENGINE = InnoDB,
 PARTITION P16Dec2012 VALUES LESS THAN (735218) ENGINE = InnoDB,
 PARTITION P17Dec2012 VALUES LESS THAN (735219) ENGINE = InnoDB,
 PARTITION P18Dec2012 VALUES LESS THAN (735220) ENGINE = InnoDB,
 PARTITION P19Dec2012 VALUES LESS THAN (735221) ENGINE = InnoDB,
 PARTITION P20Dec2012 VALUES LESS THAN (735222) ENGINE = InnoDB,
 PARTITION P21Dec2012 VALUES LESS THAN (735223) ENGINE = InnoDB,
 PARTITION P22Dec2012 VALUES LESS THAN (735224) ENGINE = InnoDB,
 PARTITION P23Dec2012 VALUES LESS THAN (735225) ENGINE = InnoDB,
 PARTITION P24Dec2012 VALUES LESS THAN (735226) ENGINE = InnoDB,
 PARTITION P25Dec2012 VALUES LESS THAN (735227) ENGINE = InnoDB,
 PARTITION P26Dec2012 VALUES LESS THAN (735228) ENGINE = InnoDB,
 PARTITION P27Dec2012 VALUES LESS THAN (735229) ENGINE = InnoDB,
 PARTITION P28Dec2012 VALUES LESS THAN (735230) ENGINE = InnoDB,
 PARTITION P29Dec2012 VALUES LESS THAN (735231) ENGINE = InnoDB,
 PARTITION P30Dec2012 VALUES LESS THAN (735232) ENGINE = InnoDB,
 PARTITION P31Dec2012 VALUES LESS THAN (735233) ENGINE = InnoDB,
 PARTITION P01Jan2013 VALUES LESS THAN (735234) ENGINE = InnoDB,
 PARTITION P02Jan2013 VALUES LESS THAN (735235) ENGINE = InnoDB,
 PARTITION P03Jan2013 VALUES LESS THAN (735236) ENGINE = InnoDB,
 PARTITION P04Jan2013 VALUES LESS THAN (735237) ENGINE = InnoDB,
 PARTITION P05Jan2013 VALUES LESS THAN (735238) ENGINE = InnoDB,
 PARTITION P06Jan2013 VALUES LESS THAN (735239) ENGINE = InnoDB,
 PARTITION P07Jan2013 VALUES LESS THAN (735240) ENGINE = InnoDB,
 PARTITION P08Jan2013 VALUES LESS THAN (735241) ENGINE = InnoDB,
 PARTITION P09Jan2013 VALUES LESS THAN (735242) ENGINE = InnoDB,
 PARTITION P10Jan2013 VALUES LESS THAN (735243) ENGINE = InnoDB,
 PARTITION P11Jan2013 VALUES LESS THAN (735244) ENGINE = InnoDB,
 PARTITION P12Jan2013 VALUES LESS THAN (735245) ENGINE = InnoDB,
 PARTITION P13Jan2013 VALUES LESS THAN (735246) ENGINE = InnoDB,
 PARTITION P14Jan2013 VALUES LESS THAN (735247) ENGINE = InnoDB,
 PARTITION P15Jan2013 VALUES LESS THAN (735248) ENGINE = InnoDB,
 PARTITION P16Jan2013 VALUES LESS THAN (735249) ENGINE = InnoDB,
 PARTITION P17Jan2013 VALUES LESS THAN (735250) ENGINE = InnoDB,
 PARTITION P18Jan2013 VALUES LESS THAN (735251) ENGINE = InnoDB,
 PARTITION P19Jan2013 VALUES LESS THAN (735252) ENGINE = InnoDB,
 PARTITION P20Jan2013 VALUES LESS THAN (735253) ENGINE = InnoDB,
 PARTITION P21Jan2013 VALUES LESS THAN (735254) ENGINE = InnoDB,
 PARTITION P22Jan2013 VALUES LESS THAN (735255) ENGINE = InnoDB,
 PARTITION P23Jan2013 VALUES LESS THAN (735256) ENGINE = InnoDB,
 PARTITION P24Jan2013 VALUES LESS THAN (735257) ENGINE = InnoDB,
 PARTITION P25Jan2013 VALUES LESS THAN (735258) ENGINE = InnoDB,
 PARTITION P26Jan2013 VALUES LESS THAN (735259) ENGINE = InnoDB,
 PARTITION P27Jan2013 VALUES LESS THAN (735260) ENGINE = InnoDB,
 PARTITION P28Jan2013 VALUES LESS THAN (735261) ENGINE = InnoDB,
 PARTITION P29Jan2013 VALUES LESS THAN (735262) ENGINE = InnoDB,
 PARTITION P30Jan2013 VALUES LESS THAN (735263) ENGINE = InnoDB,
 PARTITION P31Jan2013 VALUES LESS THAN (735264) ENGINE = InnoDB,
 PARTITION P01Feb2013 VALUES LESS THAN (735265) ENGINE = InnoDB,
 PARTITION P02Feb2013 VALUES LESS THAN (735266) ENGINE = InnoDB,
 PARTITION P03Feb2013 VALUES LESS THAN (735267) ENGINE = InnoDB,
 PARTITION P04Feb2013 VALUES LESS THAN (735268) ENGINE = InnoDB,
 PARTITION P05Feb2013 VALUES LESS THAN (735269) ENGINE = InnoDB,
 PARTITION P06Feb2013 VALUES LESS THAN (735270) ENGINE = InnoDB,
 PARTITION P07Feb2013 VALUES LESS THAN (735271) ENGINE = InnoDB,
 PARTITION P08Feb2013 VALUES LESS THAN (735272) ENGINE = InnoDB,
 PARTITION P09Feb2013 VALUES LESS THAN (735273) ENGINE = InnoDB,
 PARTITION P10Feb2013 VALUES LESS THAN (735274) ENGINE = InnoDB,
 PARTITION P11Feb2013 VALUES LESS THAN (735275) ENGINE = InnoDB,
 PARTITION P12Feb2013 VALUES LESS THAN (735276) ENGINE = InnoDB,
 PARTITION P13Feb2013 VALUES LESS THAN (735277) ENGINE = InnoDB,
 PARTITION P14Feb2013 VALUES LESS THAN (735278) ENGINE = InnoDB,
 PARTITION P15Feb2013 VALUES LESS THAN (735279) ENGINE = InnoDB,
 PARTITION P16Feb2013 VALUES LESS THAN (735280) ENGINE = InnoDB,
 PARTITION P17Feb2013 VALUES LESS THAN (735281) ENGINE = InnoDB,
 PARTITION P18Feb2013 VALUES LESS THAN (735282) ENGINE = InnoDB,
 PARTITION P19Feb2013 VALUES LESS THAN (735283) ENGINE = InnoDB,
 PARTITION P20Feb2013 VALUES LESS THAN (735284) ENGINE = InnoDB,
 PARTITION P21Feb2013 VALUES LESS THAN (735285) ENGINE = InnoDB,
 PARTITION P22Feb2013 VALUES LESS THAN (735286) ENGINE = InnoDB,
 PARTITION P23Feb2013 VALUES LESS THAN (735287) ENGINE = InnoDB,
 PARTITION P24Feb2013 VALUES LESS THAN (735288) ENGINE = InnoDB,
 PARTITION P25Feb2013 VALUES LESS THAN (735289) ENGINE = InnoDB,
 PARTITION P26Feb2013 VALUES LESS THAN (735290) ENGINE = InnoDB,
 PARTITION P27Feb2013 VALUES LESS THAN (735291) ENGINE = InnoDB,
 PARTITION P28Feb2013 VALUES LESS THAN (735292) ENGINE = InnoDB,
 PARTITION P01Mar2013 VALUES LESS THAN (735293) ENGINE = InnoDB,
 PARTITION P02Mar2013 VALUES LESS THAN (735294) ENGINE = InnoDB,
 PARTITION P03Mar2013 VALUES LESS THAN (735295) ENGINE = InnoDB,
 PARTITION P04Mar2013 VALUES LESS THAN (735296) ENGINE = InnoDB,
 PARTITION P05Mar2013 VALUES LESS THAN (735297) ENGINE = InnoDB,
 PARTITION P06Mar2013 VALUES LESS THAN (735298) ENGINE = InnoDB,
 PARTITION P07Mar2013 VALUES LESS THAN (735299) ENGINE = InnoDB,
 PARTITION P08Mar2013 VALUES LESS THAN (735300) ENGINE = InnoDB,
 PARTITION P09Mar2013 VALUES LESS THAN (735301) ENGINE = InnoDB,
 PARTITION P10Mar2013 VALUES LESS THAN (735302) ENGINE = InnoDB,
 PARTITION P11Mar2013 VALUES LESS THAN (735303) ENGINE = InnoDB,
 PARTITION P12Mar2013 VALUES LESS THAN (735304) ENGINE = InnoDB,
 PARTITION P13Mar2013 VALUES LESS THAN (735305) ENGINE = InnoDB,
 PARTITION P14Mar2013 VALUES LESS THAN (735306) ENGINE = InnoDB,
 PARTITION P15Mar2013 VALUES LESS THAN (735307) ENGINE = InnoDB,
 PARTITION P16Mar2013 VALUES LESS THAN (735308) ENGINE = InnoDB,
 PARTITION P17Mar2013 VALUES LESS THAN (735309) ENGINE = InnoDB,
 PARTITION P18Mar2013 VALUES LESS THAN (735310) ENGINE = InnoDB,
 PARTITION P19Mar2013 VALUES LESS THAN (735311) ENGINE = InnoDB,
 PARTITION P20Mar2013 VALUES LESS THAN (735312) ENGINE = InnoDB,
 PARTITION P21Mar2013 VALUES LESS THAN (735313) ENGINE = InnoDB,
 PARTITION P22Mar2013 VALUES LESS THAN (735314) ENGINE = InnoDB,
 PARTITION P23Mar2013 VALUES LESS THAN (735315) ENGINE = InnoDB,
 PARTITION P24Mar2013 VALUES LESS THAN (735316) ENGINE = InnoDB,
 PARTITION P25Mar2013 VALUES LESS THAN (735317) ENGINE = InnoDB,
 PARTITION P26Mar2013 VALUES LESS THAN (735318) ENGINE = InnoDB,
 PARTITION P27Mar2013 VALUES LESS THAN (735319) ENGINE = InnoDB,
 PARTITION P28Mar2013 VALUES LESS THAN (735320) ENGINE = InnoDB,
 PARTITION P29Mar2013 VALUES LESS THAN (735321) ENGINE = InnoDB,
 PARTITION P30Mar2013 VALUES LESS THAN (735322) ENGINE = InnoDB,
 PARTITION P31Mar2013 VALUES LESS THAN (735323) ENGINE = InnoDB,
 PARTITION P01Apr2013 VALUES LESS THAN (735324) ENGINE = InnoDB,
 PARTITION P02Apr2013 VALUES LESS THAN (735325) ENGINE = InnoDB,
 PARTITION P03Apr2013 VALUES LESS THAN (735326) ENGINE = InnoDB,
 PARTITION P04Apr2013 VALUES LESS THAN (735327) ENGINE = InnoDB,
 PARTITION P05Apr2013 VALUES LESS THAN (735328) ENGINE = InnoDB,
 PARTITION P06Apr2013 VALUES LESS THAN (735329) ENGINE = InnoDB,
 PARTITION P07Apr2013 VALUES LESS THAN (735330) ENGINE = InnoDB,
 PARTITION P08Apr2013 VALUES LESS THAN (735331) ENGINE = InnoDB,
 PARTITION P09Apr2013 VALUES LESS THAN (735332) ENGINE = InnoDB,
 PARTITION P10Apr2013 VALUES LESS THAN (735333) ENGINE = InnoDB,
 PARTITION P11Apr2013 VALUES LESS THAN (735334) ENGINE = InnoDB,
 PARTITION P12Apr2013 VALUES LESS THAN (735335) ENGINE = InnoDB,
 PARTITION P13Apr2013 VALUES LESS THAN (735336) ENGINE = InnoDB,
 PARTITION P14Apr2013 VALUES LESS THAN (735337) ENGINE = InnoDB,
 PARTITION P15Apr2013 VALUES LESS THAN (735338) ENGINE = InnoDB,
 PARTITION P16Apr2013 VALUES LESS THAN (735339) ENGINE = InnoDB,
 PARTITION P17Apr2013 VALUES LESS THAN (735340) ENGINE = InnoDB,
 PARTITION P18Apr2013 VALUES LESS THAN (735341) ENGINE = InnoDB,
 PARTITION P19Apr2013 VALUES LESS THAN (735342) ENGINE = InnoDB,
 PARTITION P20Apr2013 VALUES LESS THAN (735343) ENGINE = InnoDB,
 PARTITION P21Apr2013 VALUES LESS THAN (735344) ENGINE = InnoDB,
 PARTITION P22Apr2013 VALUES LESS THAN (735345) ENGINE = InnoDB,
 PARTITION P23Apr2013 VALUES LESS THAN (735346) ENGINE = InnoDB,
 PARTITION P24Apr2013 VALUES LESS THAN (735347) ENGINE = InnoDB,
 PARTITION P25Apr2013 VALUES LESS THAN (735348) ENGINE = InnoDB,
 PARTITION P26Apr2013 VALUES LESS THAN (735349) ENGINE = InnoDB,
 PARTITION P27Apr2013 VALUES LESS THAN (735350) ENGINE = InnoDB,
 PARTITION P28Apr2013 VALUES LESS THAN (735351) ENGINE = InnoDB,
 PARTITION P29Apr2013 VALUES LESS THAN (735352) ENGINE = InnoDB,
 PARTITION P30Apr2013 VALUES LESS THAN (735353) ENGINE = InnoDB,
 PARTITION P01May2013 VALUES LESS THAN (735354) ENGINE = InnoDB,
 PARTITION P02May2013 VALUES LESS THAN (735355) ENGINE = InnoDB,
 PARTITION P03May2013 VALUES LESS THAN (735356) ENGINE = InnoDB,
 PARTITION P04May2013 VALUES LESS THAN (735357) ENGINE = InnoDB,
 PARTITION P05May2013 VALUES LESS THAN (735358) ENGINE = InnoDB,
 PARTITION P06May2013 VALUES LESS THAN (735359) ENGINE = InnoDB,
 PARTITION P07May2013 VALUES LESS THAN (735360) ENGINE = InnoDB,
 PARTITION P08May2013 VALUES LESS THAN (735361) ENGINE = InnoDB,
 PARTITION P09May2013 VALUES LESS THAN (735362) ENGINE = InnoDB,
 PARTITION P10May2013 VALUES LESS THAN (735363) ENGINE = InnoDB,
 PARTITION P11May2013 VALUES LESS THAN (735364) ENGINE = InnoDB,
 PARTITION P12May2013 VALUES LESS THAN (735365) ENGINE = InnoDB,
 PARTITION P13May2013 VALUES LESS THAN (735366) ENGINE = InnoDB,
 PARTITION P14May2013 VALUES LESS THAN (735367) ENGINE = InnoDB,
 PARTITION P15May2013 VALUES LESS THAN (735368) ENGINE = InnoDB,
 PARTITION P16May2013 VALUES LESS THAN (735369) ENGINE = InnoDB,
 PARTITION P17May2013 VALUES LESS THAN (735370) ENGINE = InnoDB,
 PARTITION P18May2013 VALUES LESS THAN (735371) ENGINE = InnoDB,
 PARTITION P19May2013 VALUES LESS THAN (735372) ENGINE = InnoDB,
 PARTITION P20May2013 VALUES LESS THAN (735373) ENGINE = InnoDB,
 PARTITION P21May2013 VALUES LESS THAN (735374) ENGINE = InnoDB,
 PARTITION P22May2013 VALUES LESS THAN (735375) ENGINE = InnoDB,
 PARTITION P23May2013 VALUES LESS THAN (735376) ENGINE = InnoDB,
 PARTITION P24May2013 VALUES LESS THAN (735377) ENGINE = InnoDB,
 PARTITION P25May2013 VALUES LESS THAN (735378) ENGINE = InnoDB,
 PARTITION P26May2013 VALUES LESS THAN (735379) ENGINE = InnoDB,
 PARTITION P27May2013 VALUES LESS THAN (735380) ENGINE = InnoDB,
 PARTITION P28May2013 VALUES LESS THAN (735381) ENGINE = InnoDB,
 PARTITION P29May2013 VALUES LESS THAN (735382) ENGINE = InnoDB,
 PARTITION P30May2013 VALUES LESS THAN (735383) ENGINE = InnoDB,
 PARTITION P31May2013 VALUES LESS THAN (735384) ENGINE = InnoDB,
 PARTITION P01Jun2013 VALUES LESS THAN (735385) ENGINE = InnoDB,
 PARTITION P02Jun2013 VALUES LESS THAN (735386) ENGINE = InnoDB,
 PARTITION P03Jun2013 VALUES LESS THAN (735387) ENGINE = InnoDB,
 PARTITION P04Jun2013 VALUES LESS THAN (735388) ENGINE = InnoDB,
 PARTITION P05Jun2013 VALUES LESS THAN (735389) ENGINE = InnoDB,
 PARTITION P06Jun2013 VALUES LESS THAN (735390) ENGINE = InnoDB,
 PARTITION P07Jun2013 VALUES LESS THAN (735391) ENGINE = InnoDB,
 PARTITION P08Jun2013 VALUES LESS THAN (735392) ENGINE = InnoDB,
 PARTITION P09Jun2013 VALUES LESS THAN (735393) ENGINE = InnoDB,
 PARTITION P10Jun2013 VALUES LESS THAN (735394) ENGINE = InnoDB,
 PARTITION P11Jun2013 VALUES LESS THAN (735395) ENGINE = InnoDB,
 PARTITION P12Jun2013 VALUES LESS THAN (735396) ENGINE = InnoDB,
 PARTITION P13Jun2013 VALUES LESS THAN (735397) ENGINE = InnoDB,
 PARTITION P14Jun2013 VALUES LESS THAN (735398) ENGINE = InnoDB,
 PARTITION P15Jun2013 VALUES LESS THAN (735399) ENGINE = InnoDB,
 PARTITION P16Jun2013 VALUES LESS THAN (735400) ENGINE = InnoDB,
 PARTITION P17Jun2013 VALUES LESS THAN (735401) ENGINE = InnoDB,
 PARTITION P18Jun2013 VALUES LESS THAN (735402) ENGINE = InnoDB,
 PARTITION P19Jun2013 VALUES LESS THAN (735403) ENGINE = InnoDB,
 PARTITION P20Jun2013 VALUES LESS THAN (735404) ENGINE = InnoDB,
 PARTITION P21Jun2013 VALUES LESS THAN (735405) ENGINE = InnoDB,
 PARTITION P22Jun2013 VALUES LESS THAN (735406) ENGINE = InnoDB,
 PARTITION P23Jun2013 VALUES LESS THAN (735407) ENGINE = InnoDB,
 PARTITION P24Jun2013 VALUES LESS THAN (735408) ENGINE = InnoDB,
 PARTITION P25Jun2013 VALUES LESS THAN (735409) ENGINE = InnoDB,
 PARTITION P26Jun2013 VALUES LESS THAN (735410) ENGINE = InnoDB,
 PARTITION P27Jun2013 VALUES LESS THAN (735411) ENGINE = InnoDB,
 PARTITION P28Jun2013 VALUES LESS THAN (735412) ENGINE = InnoDB,
 PARTITION P29Jun2013 VALUES LESS THAN (735413) ENGINE = InnoDB,
 PARTITION P30Jun2013 VALUES LESS THAN (735414) ENGINE = InnoDB,
 PARTITION P01Jul2013 VALUES LESS THAN (735415) ENGINE = InnoDB,
 PARTITION P02Jul2013 VALUES LESS THAN (735416) ENGINE = InnoDB,
 PARTITION P03Jul2013 VALUES LESS THAN (735417) ENGINE = InnoDB,
 PARTITION P04Jul2013 VALUES LESS THAN (735418) ENGINE = InnoDB,
 PARTITION P05Jul2013 VALUES LESS THAN (735419) ENGINE = InnoDB,
 PARTITION P06Jul2013 VALUES LESS THAN (735420) ENGINE = InnoDB,
 PARTITION P07Jul2013 VALUES LESS THAN (735421) ENGINE = InnoDB,
 PARTITION P08Jul2013 VALUES LESS THAN (735422) ENGINE = InnoDB,
 PARTITION P09Jul2013 VALUES LESS THAN (735423) ENGINE = InnoDB,
 PARTITION P10Jul2013 VALUES LESS THAN (735424) ENGINE = InnoDB,
 PARTITION P11Jul2013 VALUES LESS THAN (735425) ENGINE = InnoDB,
 PARTITION P12Jul2013 VALUES LESS THAN (735426) ENGINE = InnoDB,
 PARTITION P13Jul2013 VALUES LESS THAN (735427) ENGINE = InnoDB,
 PARTITION P14Jul2013 VALUES LESS THAN (735428) ENGINE = InnoDB,
 PARTITION P15Jul2013 VALUES LESS THAN (735429) ENGINE = InnoDB,
 PARTITION P16Jul2013 VALUES LESS THAN (735430) ENGINE = InnoDB,
 PARTITION P17Jul2013 VALUES LESS THAN (735431) ENGINE = InnoDB,
 PARTITION P18Jul2013 VALUES LESS THAN (735432) ENGINE = InnoDB,
 PARTITION P19Jul2013 VALUES LESS THAN (735433) ENGINE = InnoDB,
 PARTITION P20Jul2013 VALUES LESS THAN (735434) ENGINE = InnoDB,
 PARTITION P21Jul2013 VALUES LESS THAN (735435) ENGINE = InnoDB,
 PARTITION P22Jul2013 VALUES LESS THAN (735436) ENGINE = InnoDB,
 PARTITION P23Jul2013 VALUES LESS THAN (735437) ENGINE = InnoDB,
 PARTITION P24Jul2013 VALUES LESS THAN (735438) ENGINE = InnoDB,
 PARTITION P25Jul2013 VALUES LESS THAN (735439) ENGINE = InnoDB,
 PARTITION P26Jul2013 VALUES LESS THAN (735440) ENGINE = InnoDB,
 PARTITION P27Jul2013 VALUES LESS THAN (735441) ENGINE = InnoDB,
 PARTITION P28Jul2013 VALUES LESS THAN (735442) ENGINE = InnoDB,
 PARTITION P29Jul2013 VALUES LESS THAN (735443) ENGINE = InnoDB,
 PARTITION P30Jul2013 VALUES LESS THAN (735444) ENGINE = InnoDB,
 PARTITION P31Jul2013 VALUES LESS THAN (735445) ENGINE = InnoDB,
 PARTITION P01Aug2013 VALUES LESS THAN (735446) ENGINE = InnoDB,
 PARTITION P02Aug2013 VALUES LESS THAN (735447) ENGINE = InnoDB,
 PARTITION P03Aug2013 VALUES LESS THAN (735448) ENGINE = InnoDB,
 PARTITION P04Aug2013 VALUES LESS THAN (735449) ENGINE = InnoDB,
 PARTITION P05Aug2013 VALUES LESS THAN (735450) ENGINE = InnoDB,
 PARTITION P06Aug2013 VALUES LESS THAN (735451) ENGINE = InnoDB,
 PARTITION P07Aug2013 VALUES LESS THAN (735452) ENGINE = InnoDB,
 PARTITION P08Aug2013 VALUES LESS THAN (735453) ENGINE = InnoDB,
 PARTITION P09Aug2013 VALUES LESS THAN (735454) ENGINE = InnoDB,
 PARTITION P10Aug2013 VALUES LESS THAN (735455) ENGINE = InnoDB,
 PARTITION P11Aug2013 VALUES LESS THAN (735456) ENGINE = InnoDB,
 PARTITION P12Aug2013 VALUES LESS THAN (735457) ENGINE = InnoDB,
 PARTITION P13Aug2013 VALUES LESS THAN (735458) ENGINE = InnoDB,
 PARTITION P14Aug2013 VALUES LESS THAN (735459) ENGINE = InnoDB,
 PARTITION P15Aug2013 VALUES LESS THAN (735460) ENGINE = InnoDB,
 PARTITION P16Aug2013 VALUES LESS THAN (735461) ENGINE = InnoDB,
 PARTITION P17Aug2013 VALUES LESS THAN (735462) ENGINE = InnoDB,
 PARTITION P18Aug2013 VALUES LESS THAN (735463) ENGINE = InnoDB,
 PARTITION P19Aug2013 VALUES LESS THAN (735464) ENGINE = InnoDB,
 PARTITION P20Aug2013 VALUES LESS THAN (735465) ENGINE = InnoDB,
 PARTITION P21Aug2013 VALUES LESS THAN (735466) ENGINE = InnoDB,
 PARTITION P22Aug2013 VALUES LESS THAN (735467) ENGINE = InnoDB,
 PARTITION P23Aug2013 VALUES LESS THAN (735468) ENGINE = InnoDB,
 PARTITION P24Aug2013 VALUES LESS THAN (735469) ENGINE = InnoDB,
 PARTITION P25Aug2013 VALUES LESS THAN (735470) ENGINE = InnoDB,
 PARTITION P26Aug2013 VALUES LESS THAN (735471) ENGINE = InnoDB,
 PARTITION P27Aug2013 VALUES LESS THAN (735472) ENGINE = InnoDB,
 PARTITION P28Aug2013 VALUES LESS THAN (735473) ENGINE = InnoDB,
 PARTITION P29Aug2013 VALUES LESS THAN (735474) ENGINE = InnoDB,
 PARTITION P30Aug2013 VALUES LESS THAN (735475) ENGINE = InnoDB,
 PARTITION P31Aug2013 VALUES LESS THAN (735476) ENGINE = InnoDB,
 PARTITION P01Sep2013 VALUES LESS THAN (735477) ENGINE = InnoDB,
 PARTITION P02Sep2013 VALUES LESS THAN (735478) ENGINE = InnoDB,
 PARTITION P03Sep2013 VALUES LESS THAN (735479) ENGINE = InnoDB,
 PARTITION P04Sep2013 VALUES LESS THAN (735480) ENGINE = InnoDB,
 PARTITION P05Sep2013 VALUES LESS THAN (735481) ENGINE = InnoDB,
 PARTITION P06Sep2013 VALUES LESS THAN (735482) ENGINE = InnoDB,
 PARTITION P07Sep2013 VALUES LESS THAN (735483) ENGINE = InnoDB,
 PARTITION P08Sep2013 VALUES LESS THAN (735484) ENGINE = InnoDB,
 PARTITION P09Sep2013 VALUES LESS THAN (735485) ENGINE = InnoDB,
 PARTITION P10Sep2013 VALUES LESS THAN (735486) ENGINE = InnoDB,
 PARTITION P11Sep2013 VALUES LESS THAN (735487) ENGINE = InnoDB,
 PARTITION P12Sep2013 VALUES LESS THAN (735488) ENGINE = InnoDB,
 PARTITION P13Sep2013 VALUES LESS THAN (735489) ENGINE = InnoDB,
 PARTITION P14Sep2013 VALUES LESS THAN (735490) ENGINE = InnoDB,
 PARTITION P15Sep2013 VALUES LESS THAN (735491) ENGINE = InnoDB,
 PARTITION P16Sep2013 VALUES LESS THAN (735492) ENGINE = InnoDB,
 PARTITION P17Sep2013 VALUES LESS THAN (735493) ENGINE = InnoDB,
 PARTITION P18Sep2013 VALUES LESS THAN (735494) ENGINE = InnoDB,
 PARTITION P19Sep2013 VALUES LESS THAN (735495) ENGINE = InnoDB,
 PARTITION P20Sep2013 VALUES LESS THAN (735496) ENGINE = InnoDB,
 PARTITION P21Sep2013 VALUES LESS THAN (735497) ENGINE = InnoDB,
 PARTITION P22Sep2013 VALUES LESS THAN (735498) ENGINE = InnoDB,
 PARTITION P23Sep2013 VALUES LESS THAN (735499) ENGINE = InnoDB,
 PARTITION P24Sep2013 VALUES LESS THAN (735500) ENGINE = InnoDB,
 PARTITION P25Sep2013 VALUES LESS THAN (735501) ENGINE = InnoDB,
 PARTITION P26Sep2013 VALUES LESS THAN (735502) ENGINE = InnoDB,
 PARTITION P27Sep2013 VALUES LESS THAN (735503) ENGINE = InnoDB,
 PARTITION P28Sep2013 VALUES LESS THAN (735504) ENGINE = InnoDB,
 PARTITION P29Sep2013 VALUES LESS THAN (735505) ENGINE = InnoDB,
 PARTITION P30Sep2013 VALUES LESS THAN (735506) ENGINE = InnoDB,
 PARTITION P01Oct2013 VALUES LESS THAN (735507) ENGINE = InnoDB,
 PARTITION P02Oct2013 VALUES LESS THAN (735508) ENGINE = InnoDB,
 PARTITION P03Oct2013 VALUES LESS THAN (735509) ENGINE = InnoDB,
 PARTITION P04Oct2013 VALUES LESS THAN (735510) ENGINE = InnoDB,
 PARTITION P05Oct2013 VALUES LESS THAN (735511) ENGINE = InnoDB,
 PARTITION P06Oct2013 VALUES LESS THAN (735512) ENGINE = InnoDB,
 PARTITION P07Oct2013 VALUES LESS THAN (735513) ENGINE = InnoDB,
 PARTITION P08Oct2013 VALUES LESS THAN (735514) ENGINE = InnoDB,
 PARTITION P09Oct2013 VALUES LESS THAN (735515) ENGINE = InnoDB,
 PARTITION P10Oct2013 VALUES LESS THAN (735516) ENGINE = InnoDB,
 PARTITION P11Oct2013 VALUES LESS THAN (735517) ENGINE = InnoDB,
 PARTITION P12Oct2013 VALUES LESS THAN (735518) ENGINE = InnoDB,
 PARTITION P13Oct2013 VALUES LESS THAN (735519) ENGINE = InnoDB,
 PARTITION P14Oct2013 VALUES LESS THAN (735520) ENGINE = InnoDB,
 PARTITION P15Oct2013 VALUES LESS THAN (735521) ENGINE = InnoDB,
 PARTITION P16Oct2013 VALUES LESS THAN (735522) ENGINE = InnoDB,
 PARTITION P17Oct2013 VALUES LESS THAN (735523) ENGINE = InnoDB,
 PARTITION P18Oct2013 VALUES LESS THAN (735524) ENGINE = InnoDB,
 PARTITION P19Oct2013 VALUES LESS THAN (735525) ENGINE = InnoDB,
 PARTITION P20Oct2013 VALUES LESS THAN (735526) ENGINE = InnoDB,
 PARTITION P21Oct2013 VALUES LESS THAN (735527) ENGINE = InnoDB,
 PARTITION P22Oct2013 VALUES LESS THAN (735528) ENGINE = InnoDB,
 PARTITION P23Oct2013 VALUES LESS THAN (735529) ENGINE = InnoDB,
 PARTITION P24Oct2013 VALUES LESS THAN (735530) ENGINE = InnoDB,
 PARTITION P25Oct2013 VALUES LESS THAN (735531) ENGINE = InnoDB,
 PARTITION P26Oct2013 VALUES LESS THAN (735532) ENGINE = InnoDB,
 PARTITION P27Oct2013 VALUES LESS THAN (735533) ENGINE = InnoDB,
 PARTITION P28Oct2013 VALUES LESS THAN (735534) ENGINE = InnoDB,
 PARTITION P29Oct2013 VALUES LESS THAN (735535) ENGINE = InnoDB,
 PARTITION P30Oct2013 VALUES LESS THAN (735536) ENGINE = InnoDB,
 PARTITION P31Oct2013 VALUES LESS THAN (735537) ENGINE = InnoDB,
 PARTITION P01Nov2013 VALUES LESS THAN (735538) ENGINE = InnoDB,
 PARTITION P02Nov2013 VALUES LESS THAN (735539) ENGINE = InnoDB,
 PARTITION P03Nov2013 VALUES LESS THAN (735540) ENGINE = InnoDB,
 PARTITION P04Nov2013 VALUES LESS THAN (735541) ENGINE = InnoDB,
 PARTITION P05Nov2013 VALUES LESS THAN (735542) ENGINE = InnoDB,
 PARTITION P06Nov2013 VALUES LESS THAN (735543) ENGINE = InnoDB,
 PARTITION P07Nov2013 VALUES LESS THAN (735544) ENGINE = InnoDB,
 PARTITION P08Nov2013 VALUES LESS THAN (735545) ENGINE = InnoDB,
 PARTITION P09Nov2013 VALUES LESS THAN (735546) ENGINE = InnoDB,
 PARTITION P10Nov2013 VALUES LESS THAN (735547) ENGINE = InnoDB,
 PARTITION P11Nov2013 VALUES LESS THAN (735548) ENGINE = InnoDB,
 PARTITION P12Nov2013 VALUES LESS THAN (735549) ENGINE = InnoDB,
 PARTITION P13Nov2013 VALUES LESS THAN (735550) ENGINE = InnoDB,
 PARTITION P14Nov2013 VALUES LESS THAN (735551) ENGINE = InnoDB,
 PARTITION P15Nov2013 VALUES LESS THAN (735552) ENGINE = InnoDB,
 PARTITION P16Nov2013 VALUES LESS THAN (735553) ENGINE = InnoDB,
 PARTITION P17Nov2013 VALUES LESS THAN (735554) ENGINE = InnoDB,
 PARTITION P18Nov2013 VALUES LESS THAN (735555) ENGINE = InnoDB,
 PARTITION P19Nov2013 VALUES LESS THAN (735556) ENGINE = InnoDB,
 PARTITION P20Nov2013 VALUES LESS THAN (735557) ENGINE = InnoDB,
 PARTITION P21Nov2013 VALUES LESS THAN (735558) ENGINE = InnoDB,
 PARTITION P22Nov2013 VALUES LESS THAN (735559) ENGINE = InnoDB,
 PARTITION P23Nov2013 VALUES LESS THAN (735560) ENGINE = InnoDB,
 PARTITION P24Nov2013 VALUES LESS THAN (735561) ENGINE = InnoDB,
 PARTITION P25Nov2013 VALUES LESS THAN (735562) ENGINE = InnoDB,
 PARTITION P26Nov2013 VALUES LESS THAN (735563) ENGINE = InnoDB,
 PARTITION P27Nov2013 VALUES LESS THAN (735564) ENGINE = InnoDB,
 PARTITION P28Nov2013 VALUES LESS THAN (735565) ENGINE = InnoDB,
 PARTITION P29Nov2013 VALUES LESS THAN (735566) ENGINE = InnoDB,
 PARTITION P30Nov2013 VALUES LESS THAN (735567) ENGINE = InnoDB,
 PARTITION P01Dec2013 VALUES LESS THAN (735568) ENGINE = InnoDB,
 PARTITION P02Dec2013 VALUES LESS THAN (735569) ENGINE = InnoDB,
 PARTITION P03Dec2013 VALUES LESS THAN (735570) ENGINE = InnoDB,
 PARTITION P04Dec2013 VALUES LESS THAN (735571) ENGINE = InnoDB,
 PARTITION P05Dec2013 VALUES LESS THAN (735572) ENGINE = InnoDB,
 PARTITION P06Dec2013 VALUES LESS THAN (735573) ENGINE = InnoDB,
 PARTITION P07Dec2013 VALUES LESS THAN (735574) ENGINE = InnoDB,
 PARTITION P08Dec2013 VALUES LESS THAN (735575) ENGINE = InnoDB,
 PARTITION P09Dec2013 VALUES LESS THAN (735576) ENGINE = InnoDB,
 PARTITION P10Dec2013 VALUES LESS THAN (735577) ENGINE = InnoDB,
 PARTITION P11Dec2013 VALUES LESS THAN (735578) ENGINE = InnoDB,
 PARTITION P12Dec2013 VALUES LESS THAN (735579) ENGINE = InnoDB,
 PARTITION P13Dec2013 VALUES LESS THAN (735580) ENGINE = InnoDB,
 PARTITION P14Dec2013 VALUES LESS THAN (735581) ENGINE = InnoDB,
 PARTITION P15Dec2013 VALUES LESS THAN (735582) ENGINE = InnoDB,
 PARTITION P16Dec2013 VALUES LESS THAN (735583) ENGINE = InnoDB,
 PARTITION P17Dec2013 VALUES LESS THAN (735584) ENGINE = InnoDB,
 PARTITION P18Dec2013 VALUES LESS THAN (735585) ENGINE = InnoDB,
 PARTITION P19Dec2013 VALUES LESS THAN (735586) ENGINE = InnoDB,
 PARTITION P20Dec2013 VALUES LESS THAN (735587) ENGINE = InnoDB,
 PARTITION P21Dec2013 VALUES LESS THAN (735588) ENGINE = InnoDB,
 PARTITION P22Dec2013 VALUES LESS THAN (735589) ENGINE = InnoDB,
 PARTITION P23Dec2013 VALUES LESS THAN (735590) ENGINE = InnoDB,
 PARTITION P24Dec2013 VALUES LESS THAN (735591) ENGINE = InnoDB,
 PARTITION P25Dec2013 VALUES LESS THAN (735592) ENGINE = InnoDB,
 PARTITION P26Dec2013 VALUES LESS THAN (735593) ENGINE = InnoDB,
 PARTITION P27Dec2013 VALUES LESS THAN (735594) ENGINE = InnoDB,
 PARTITION P28Dec2013 VALUES LESS THAN (735595) ENGINE = InnoDB,
 PARTITION P29Dec2013 VALUES LESS THAN (735596) ENGINE = InnoDB,
 PARTITION P30Dec2013 VALUES LESS THAN (735597) ENGINE = InnoDB,
 PARTITION P31Dec2013 VALUES LESS THAN (735598) ENGINE = InnoDB,
 PARTITION P01Jan2014 VALUES LESS THAN (735599) ENGINE = InnoDB,
 PARTITION P02Jan2014 VALUES LESS THAN (735600) ENGINE = InnoDB,
 PARTITION P03Jan2014 VALUES LESS THAN (735601) ENGINE = InnoDB,
 PARTITION P04Jan2014 VALUES LESS THAN (735602) ENGINE = InnoDB,
 PARTITION P05Jan2014 VALUES LESS THAN (735603) ENGINE = InnoDB,
 PARTITION P06Jan2014 VALUES LESS THAN (735604) ENGINE = InnoDB,
 PARTITION P07Jan2014 VALUES LESS THAN (735605) ENGINE = InnoDB,
 PARTITION P08Jan2014 VALUES LESS THAN (735606) ENGINE = InnoDB,
 PARTITION P09Jan2014 VALUES LESS THAN (735607) ENGINE = InnoDB,
 PARTITION P10Jan2014 VALUES LESS THAN (735608) ENGINE = InnoDB,
 PARTITION P11Jan2014 VALUES LESS THAN (735609) ENGINE = InnoDB,
 PARTITION P12Jan2014 VALUES LESS THAN (735610) ENGINE = InnoDB,
 PARTITION P13Jan2014 VALUES LESS THAN (735611) ENGINE = InnoDB,
 PARTITION P14Jan2014 VALUES LESS THAN (735612) ENGINE = InnoDB,
 PARTITION P15Jan2014 VALUES LESS THAN (735613) ENGINE = InnoDB,
 PARTITION P16Jan2014 VALUES LESS THAN (735614) ENGINE = InnoDB,
 PARTITION P17Jan2014 VALUES LESS THAN (735615) ENGINE = InnoDB,
 PARTITION P18Jan2014 VALUES LESS THAN (735616) ENGINE = InnoDB,
 PARTITION P19Jan2014 VALUES LESS THAN (735617) ENGINE = InnoDB,
 PARTITION P20Jan2014 VALUES LESS THAN (735618) ENGINE = InnoDB,
 PARTITION P21Jan2014 VALUES LESS THAN (735619) ENGINE = InnoDB,
 PARTITION P22Jan2014 VALUES LESS THAN (735620) ENGINE = InnoDB,
 PARTITION P23Jan2014 VALUES LESS THAN (735621) ENGINE = InnoDB,
 PARTITION P24Jan2014 VALUES LESS THAN (735622) ENGINE = InnoDB,
 PARTITION P25Jan2014 VALUES LESS THAN (735623) ENGINE = InnoDB,
 PARTITION P26Jan2014 VALUES LESS THAN (735624) ENGINE = InnoDB,
 PARTITION P27Jan2014 VALUES LESS THAN (735625) ENGINE = InnoDB,
 PARTITION P28Jan2014 VALUES LESS THAN (735626) ENGINE = InnoDB,
 PARTITION P29Jan2014 VALUES LESS THAN (735627) ENGINE = InnoDB,
 PARTITION P30Jan2014 VALUES LESS THAN (735628) ENGINE = InnoDB,
 PARTITION P31Jan2014 VALUES LESS THAN (735629) ENGINE = InnoDB,
 PARTITION P01Feb2014 VALUES LESS THAN (735630) ENGINE = InnoDB,
 PARTITION P02Feb2014 VALUES LESS THAN (735631) ENGINE = InnoDB,
 PARTITION P03Feb2014 VALUES LESS THAN (735632) ENGINE = InnoDB,
 PARTITION P04Feb2014 VALUES LESS THAN (735633) ENGINE = InnoDB,
 PARTITION P05Feb2014 VALUES LESS THAN (735634) ENGINE = InnoDB,
 PARTITION P06Feb2014 VALUES LESS THAN (735635) ENGINE = InnoDB,
 PARTITION P07Feb2014 VALUES LESS THAN (735636) ENGINE = InnoDB,
 PARTITION P08Feb2014 VALUES LESS THAN (735637) ENGINE = InnoDB,
 PARTITION P09Feb2014 VALUES LESS THAN (735638) ENGINE = InnoDB,
 PARTITION P10Feb2014 VALUES LESS THAN (735639) ENGINE = InnoDB,
 PARTITION P11Feb2014 VALUES LESS THAN (735640) ENGINE = InnoDB,
 PARTITION P12Feb2014 VALUES LESS THAN (735641) ENGINE = InnoDB,
 PARTITION P13Feb2014 VALUES LESS THAN (735642) ENGINE = InnoDB,
 PARTITION P14Feb2014 VALUES LESS THAN (735643) ENGINE = InnoDB,
 PARTITION P15Feb2014 VALUES LESS THAN (735644) ENGINE = InnoDB,
 PARTITION P16Feb2014 VALUES LESS THAN (735645) ENGINE = InnoDB,
 PARTITION P17Feb2014 VALUES LESS THAN (735646) ENGINE = InnoDB,
 PARTITION P18Feb2014 VALUES LESS THAN (735647) ENGINE = InnoDB,
 PARTITION P19Feb2014 VALUES LESS THAN (735648) ENGINE = InnoDB,
 PARTITION P20Feb2014 VALUES LESS THAN (735649) ENGINE = InnoDB,
 PARTITION P21Feb2014 VALUES LESS THAN (735650) ENGINE = InnoDB,
 PARTITION P22Feb2014 VALUES LESS THAN (735651) ENGINE = InnoDB,
 PARTITION P23Feb2014 VALUES LESS THAN (735652) ENGINE = InnoDB,
 PARTITION P24Feb2014 VALUES LESS THAN (735653) ENGINE = InnoDB,
 PARTITION P25Feb2014 VALUES LESS THAN (735654) ENGINE = InnoDB,
 PARTITION P26Feb2014 VALUES LESS THAN (735655) ENGINE = InnoDB,
 PARTITION P27Feb2014 VALUES LESS THAN (735656) ENGINE = InnoDB,
 PARTITION P28Feb2014 VALUES LESS THAN (735657) ENGINE = InnoDB,
 PARTITION P01Mar2014 VALUES LESS THAN (735658) ENGINE = InnoDB,
 PARTITION P02Mar2014 VALUES LESS THAN (735659) ENGINE = InnoDB,
 PARTITION P03Mar2014 VALUES LESS THAN (735660) ENGINE = InnoDB,
 PARTITION P04Mar2014 VALUES LESS THAN (735661) ENGINE = InnoDB,
 PARTITION P05Mar2014 VALUES LESS THAN (735662) ENGINE = InnoDB,
 PARTITION P06Mar2014 VALUES LESS THAN (735663) ENGINE = InnoDB,
 PARTITION P07Mar2014 VALUES LESS THAN (735664) ENGINE = InnoDB,
 PARTITION P08Mar2014 VALUES LESS THAN (735665) ENGINE = InnoDB,
 PARTITION P09Mar2014 VALUES LESS THAN (735666) ENGINE = InnoDB,
 PARTITION P10Mar2014 VALUES LESS THAN (735667) ENGINE = InnoDB,
 PARTITION P11Mar2014 VALUES LESS THAN (735668) ENGINE = InnoDB,
 PARTITION P12Mar2014 VALUES LESS THAN (735669) ENGINE = InnoDB,
 PARTITION P13Mar2014 VALUES LESS THAN (735670) ENGINE = InnoDB,
 PARTITION P14Mar2014 VALUES LESS THAN (735671) ENGINE = InnoDB,
 PARTITION P15Mar2014 VALUES LESS THAN (735672) ENGINE = InnoDB,
 PARTITION P16Mar2014 VALUES LESS THAN (735673) ENGINE = InnoDB,
 PARTITION P17Mar2014 VALUES LESS THAN (735674) ENGINE = InnoDB,
 PARTITION P18Mar2014 VALUES LESS THAN (735675) ENGINE = InnoDB,
 PARTITION P19Mar2014 VALUES LESS THAN (735676) ENGINE = InnoDB,
 PARTITION P20Mar2014 VALUES LESS THAN (735677) ENGINE = InnoDB,
 PARTITION P21Mar2014 VALUES LESS THAN (735678) ENGINE = InnoDB,
 PARTITION P22Mar2014 VALUES LESS THAN (735679) ENGINE = InnoDB,
 PARTITION P23Mar2014 VALUES LESS THAN (735680) ENGINE = InnoDB,
 PARTITION P24Mar2014 VALUES LESS THAN (735681) ENGINE = InnoDB,
 PARTITION P25Mar2014 VALUES LESS THAN (735682) ENGINE = InnoDB,
 PARTITION P26Mar2014 VALUES LESS THAN (735683) ENGINE = InnoDB,
 PARTITION P27Mar2014 VALUES LESS THAN (735684) ENGINE = InnoDB,
 PARTITION P28Mar2014 VALUES LESS THAN (735685) ENGINE = InnoDB,
 PARTITION P29Mar2014 VALUES LESS THAN (735686) ENGINE = InnoDB,
 PARTITION P30Mar2014 VALUES LESS THAN (735687) ENGINE = InnoDB,
 PARTITION P31Mar2014 VALUES LESS THAN (735688) ENGINE = InnoDB,
 PARTITION P01Apr2014 VALUES LESS THAN (735689) ENGINE = InnoDB,
 PARTITION P02Apr2014 VALUES LESS THAN (735690) ENGINE = InnoDB,
 PARTITION P03Apr2014 VALUES LESS THAN (735691) ENGINE = InnoDB,
 PARTITION P04Apr2014 VALUES LESS THAN (735692) ENGINE = InnoDB,
 PARTITION P05Apr2014 VALUES LESS THAN (735693) ENGINE = InnoDB,
 PARTITION P06Apr2014 VALUES LESS THAN (735694) ENGINE = InnoDB,
 PARTITION P07Apr2014 VALUES LESS THAN (735695) ENGINE = InnoDB,
 PARTITION P08Apr2014 VALUES LESS THAN (735696) ENGINE = InnoDB,
 PARTITION P09Apr2014 VALUES LESS THAN (735697) ENGINE = InnoDB,
 PARTITION P10Apr2014 VALUES LESS THAN (735698) ENGINE = InnoDB,
 PARTITION P11Apr2014 VALUES LESS THAN (735699) ENGINE = InnoDB,
 PARTITION P12Apr2014 VALUES LESS THAN (735700) ENGINE = InnoDB,
 PARTITION P13Apr2014 VALUES LESS THAN (735701) ENGINE = InnoDB,
 PARTITION P14Apr2014 VALUES LESS THAN (735702) ENGINE = InnoDB,
 PARTITION P15Apr2014 VALUES LESS THAN (735703) ENGINE = InnoDB,
 PARTITION P16Apr2014 VALUES LESS THAN (735704) ENGINE = InnoDB,
 PARTITION P17Apr2014 VALUES LESS THAN (735705) ENGINE = InnoDB,
 PARTITION P18Apr2014 VALUES LESS THAN (735706) ENGINE = InnoDB,
 PARTITION P19Apr2014 VALUES LESS THAN (735707) ENGINE = InnoDB,
 PARTITION P20Apr2014 VALUES LESS THAN (735708) ENGINE = InnoDB,
 PARTITION P21Apr2014 VALUES LESS THAN (735709) ENGINE = InnoDB,
 PARTITION P22Apr2014 VALUES LESS THAN (735710) ENGINE = InnoDB,
 PARTITION P23Apr2014 VALUES LESS THAN (735711) ENGINE = InnoDB,
 PARTITION P24Apr2014 VALUES LESS THAN (735712) ENGINE = InnoDB,
 PARTITION P25Apr2014 VALUES LESS THAN (735713) ENGINE = InnoDB,
 PARTITION P26Apr2014 VALUES LESS THAN (735714) ENGINE = InnoDB,
 PARTITION P27Apr2014 VALUES LESS THAN (735715) ENGINE = InnoDB,
 PARTITION P28Apr2014 VALUES LESS THAN (735716) ENGINE = InnoDB,
 PARTITION P29Apr2014 VALUES LESS THAN (735717) ENGINE = InnoDB,
 PARTITION P30Apr2014 VALUES LESS THAN (735718) ENGINE = InnoDB,
 PARTITION P01May2014 VALUES LESS THAN (735719) ENGINE = InnoDB,
 PARTITION P02May2014 VALUES LESS THAN (735720) ENGINE = InnoDB,
 PARTITION P03May2014 VALUES LESS THAN (735721) ENGINE = InnoDB,
 PARTITION P04May2014 VALUES LESS THAN (735722) ENGINE = InnoDB,
 PARTITION P05May2014 VALUES LESS THAN (735723) ENGINE = InnoDB,
 PARTITION P06May2014 VALUES LESS THAN (735724) ENGINE = InnoDB,
 PARTITION P07May2014 VALUES LESS THAN (735725) ENGINE = InnoDB,
 PARTITION P08May2014 VALUES LESS THAN (735726) ENGINE = InnoDB,
 PARTITION P09May2014 VALUES LESS THAN (735727) ENGINE = InnoDB,
 PARTITION P10May2014 VALUES LESS THAN (735728) ENGINE = InnoDB,
 PARTITION P11May2014 VALUES LESS THAN (735729) ENGINE = InnoDB,
 PARTITION P12May2014 VALUES LESS THAN (735730) ENGINE = InnoDB,
 PARTITION P13May2014 VALUES LESS THAN (735731) ENGINE = InnoDB,
 PARTITION P14May2014 VALUES LESS THAN (735732) ENGINE = InnoDB,
 PARTITION P15May2014 VALUES LESS THAN (735733) ENGINE = InnoDB,
 PARTITION P16May2014 VALUES LESS THAN (735734) ENGINE = InnoDB,
 PARTITION P17May2014 VALUES LESS THAN (735735) ENGINE = InnoDB,
 PARTITION P18May2014 VALUES LESS THAN (735736) ENGINE = InnoDB,
 PARTITION P19May2014 VALUES LESS THAN (735737) ENGINE = InnoDB,
 PARTITION P20May2014 VALUES LESS THAN (735738) ENGINE = InnoDB,
 PARTITION P21May2014 VALUES LESS THAN (735739) ENGINE = InnoDB,
 PARTITION P22May2014 VALUES LESS THAN (735740) ENGINE = InnoDB,
 PARTITION P23May2014 VALUES LESS THAN (735741) ENGINE = InnoDB,
 PARTITION P24May2014 VALUES LESS THAN (735742) ENGINE = InnoDB,
 PARTITION P25May2014 VALUES LESS THAN (735743) ENGINE = InnoDB,
 PARTITION P26May2014 VALUES LESS THAN (735744) ENGINE = InnoDB,
 PARTITION P27May2014 VALUES LESS THAN (735745) ENGINE = InnoDB,
 PARTITION P28May2014 VALUES LESS THAN (735746) ENGINE = InnoDB,
 PARTITION P29May2014 VALUES LESS THAN (735747) ENGINE = InnoDB,
 PARTITION P30May2014 VALUES LESS THAN (735748) ENGINE = InnoDB,
 PARTITION P31May2014 VALUES LESS THAN (735749) ENGINE = InnoDB,
 PARTITION P01Jun2014 VALUES LESS THAN (735750) ENGINE = InnoDB,
 PARTITION P02Jun2014 VALUES LESS THAN (735751) ENGINE = InnoDB,
 PARTITION P03Jun2014 VALUES LESS THAN (735752) ENGINE = InnoDB,
 PARTITION P04Jun2014 VALUES LESS THAN (735753) ENGINE = InnoDB,
 PARTITION P05Jun2014 VALUES LESS THAN (735754) ENGINE = InnoDB,
 PARTITION P06Jun2014 VALUES LESS THAN (735755) ENGINE = InnoDB,
 PARTITION P07Jun2014 VALUES LESS THAN (735756) ENGINE = InnoDB,
 PARTITION P08Jun2014 VALUES LESS THAN (735757) ENGINE = InnoDB,
 PARTITION P09Jun2014 VALUES LESS THAN (735758) ENGINE = InnoDB,
 PARTITION P10Jun2014 VALUES LESS THAN (735759) ENGINE = InnoDB,
 PARTITION P11Jun2014 VALUES LESS THAN (735760) ENGINE = InnoDB,
 PARTITION P12Jun2014 VALUES LESS THAN (735761) ENGINE = InnoDB,
 PARTITION P13Jun2014 VALUES LESS THAN (735762) ENGINE = InnoDB,
 PARTITION P14Jun2014 VALUES LESS THAN (735763) ENGINE = InnoDB,
 PARTITION P15Jun2014 VALUES LESS THAN (735764) ENGINE = InnoDB,
 PARTITION P16Jun2014 VALUES LESS THAN (735765) ENGINE = InnoDB,
 PARTITION P17Jun2014 VALUES LESS THAN (735766) ENGINE = InnoDB,
 PARTITION P18Jun2014 VALUES LESS THAN (735767) ENGINE = InnoDB,
 PARTITION P19Jun2014 VALUES LESS THAN (735768) ENGINE = InnoDB,
 PARTITION P20Jun2014 VALUES LESS THAN (735769) ENGINE = InnoDB,
 PARTITION P21Jun2014 VALUES LESS THAN (735770) ENGINE = InnoDB,
 PARTITION P22Jun2014 VALUES LESS THAN (735771) ENGINE = InnoDB,
 PARTITION P23Jun2014 VALUES LESS THAN (735772) ENGINE = InnoDB,
 PARTITION P24Jun2014 VALUES LESS THAN (735773) ENGINE = InnoDB,
 PARTITION P25Jun2014 VALUES LESS THAN (735774) ENGINE = InnoDB,
 PARTITION P26Jun2014 VALUES LESS THAN (735775) ENGINE = InnoDB,
 PARTITION P27Jun2014 VALUES LESS THAN (735776) ENGINE = InnoDB,
 PARTITION P28Jun2014 VALUES LESS THAN (735777) ENGINE = InnoDB,
 PARTITION P29Jun2014 VALUES LESS THAN (735778) ENGINE = InnoDB,
 PARTITION P30Jun2014 VALUES LESS THAN (735779) ENGINE = InnoDB,
 PARTITION P01Jul2014 VALUES LESS THAN (735780) ENGINE = InnoDB,
 PARTITION P02Jul2014 VALUES LESS THAN (735781) ENGINE = InnoDB,
 PARTITION P03Jul2014 VALUES LESS THAN (735782) ENGINE = InnoDB,
 PARTITION P04Jul2014 VALUES LESS THAN (735783) ENGINE = InnoDB,
 PARTITION P05Jul2014 VALUES LESS THAN (735784) ENGINE = InnoDB,
 PARTITION P06Jul2014 VALUES LESS THAN (735785) ENGINE = InnoDB,
 PARTITION P07Jul2014 VALUES LESS THAN (735786) ENGINE = InnoDB,
 PARTITION P08Jul2014 VALUES LESS THAN (735787) ENGINE = InnoDB,
 PARTITION P09Jul2014 VALUES LESS THAN (735788) ENGINE = InnoDB,
 PARTITION P10Jul2014 VALUES LESS THAN (735789) ENGINE = InnoDB,
 PARTITION P11Jul2014 VALUES LESS THAN (735790) ENGINE = InnoDB,
 PARTITION P12Jul2014 VALUES LESS THAN (735791) ENGINE = InnoDB,
 PARTITION P13Jul2014 VALUES LESS THAN (735792) ENGINE = InnoDB,
 PARTITION P14Jul2014 VALUES LESS THAN (735793) ENGINE = InnoDB,
 PARTITION P15Jul2014 VALUES LESS THAN (735794) ENGINE = InnoDB,
 PARTITION P16Jul2014 VALUES LESS THAN (735795) ENGINE = InnoDB,
 PARTITION P17Jul2014 VALUES LESS THAN (735796) ENGINE = InnoDB,
 PARTITION P18Jul2014 VALUES LESS THAN (735797) ENGINE = InnoDB,
 PARTITION P19Jul2014 VALUES LESS THAN (735798) ENGINE = InnoDB,
 PARTITION P20Jul2014 VALUES LESS THAN (735799) ENGINE = InnoDB,
 PARTITION P21Jul2014 VALUES LESS THAN (735800) ENGINE = InnoDB,
 PARTITION P22Jul2014 VALUES LESS THAN (735801) ENGINE = InnoDB,
 PARTITION P23Jul2014 VALUES LESS THAN (735802) ENGINE = InnoDB,
 PARTITION P24Jul2014 VALUES LESS THAN (735803) ENGINE = InnoDB,
 PARTITION P25Jul2014 VALUES LESS THAN (735804) ENGINE = InnoDB,
 PARTITION P26Jul2014 VALUES LESS THAN (735805) ENGINE = InnoDB,
 PARTITION P27Jul2014 VALUES LESS THAN (735806) ENGINE = InnoDB,
 PARTITION P28Jul2014 VALUES LESS THAN (735807) ENGINE = InnoDB,
 PARTITION P29Jul2014 VALUES LESS THAN (735808) ENGINE = InnoDB,
 PARTITION P30Jul2014 VALUES LESS THAN (735809) ENGINE = InnoDB,
 PARTITION P31Jul2014 VALUES LESS THAN (735810) ENGINE = InnoDB,
 PARTITION P01Aug2014 VALUES LESS THAN (735811) ENGINE = InnoDB,
 PARTITION P02Aug2014 VALUES LESS THAN (735812) ENGINE = InnoDB,
 PARTITION P03Aug2014 VALUES LESS THAN (735813) ENGINE = InnoDB,
 PARTITION P04Aug2014 VALUES LESS THAN (735814) ENGINE = InnoDB,
 PARTITION P05Aug2014 VALUES LESS THAN (735815) ENGINE = InnoDB,
 PARTITION P06Aug2014 VALUES LESS THAN (735816) ENGINE = InnoDB,
 PARTITION P07Aug2014 VALUES LESS THAN (735817) ENGINE = InnoDB,
 PARTITION P08Aug2014 VALUES LESS THAN (735818) ENGINE = InnoDB,
 PARTITION P09Aug2014 VALUES LESS THAN (735819) ENGINE = InnoDB,
 PARTITION P10Aug2014 VALUES LESS THAN (735820) ENGINE = InnoDB,
 PARTITION P11Aug2014 VALUES LESS THAN (735821) ENGINE = InnoDB,
 PARTITION P12Aug2014 VALUES LESS THAN (735822) ENGINE = InnoDB,
 PARTITION P13Aug2014 VALUES LESS THAN (735823) ENGINE = InnoDB,
 PARTITION P14Aug2014 VALUES LESS THAN (735824) ENGINE = InnoDB,
 PARTITION P15Aug2014 VALUES LESS THAN (735825) ENGINE = InnoDB,
 PARTITION P16Aug2014 VALUES LESS THAN (735826) ENGINE = InnoDB,
 PARTITION P17Aug2014 VALUES LESS THAN (735827) ENGINE = InnoDB,
 PARTITION P18Aug2014 VALUES LESS THAN (735828) ENGINE = InnoDB,
 PARTITION P19Aug2014 VALUES LESS THAN (735829) ENGINE = InnoDB,
 PARTITION P20Aug2014 VALUES LESS THAN (735830) ENGINE = InnoDB,
 PARTITION P21Aug2014 VALUES LESS THAN (735831) ENGINE = InnoDB,
 PARTITION P22Aug2014 VALUES LESS THAN (735832) ENGINE = InnoDB,
 PARTITION P23Aug2014 VALUES LESS THAN (735833) ENGINE = InnoDB,
 PARTITION P24Aug2014 VALUES LESS THAN (735834) ENGINE = InnoDB,
 PARTITION P25Aug2014 VALUES LESS THAN (735835) ENGINE = InnoDB,
 PARTITION P26Aug2014 VALUES LESS THAN (735836) ENGINE = InnoDB,
 PARTITION P27Aug2014 VALUES LESS THAN (735837) ENGINE = InnoDB,
 PARTITION P28Aug2014 VALUES LESS THAN (735838) ENGINE = InnoDB,
 PARTITION P29Aug2014 VALUES LESS THAN (735839) ENGINE = InnoDB,
 PARTITION P30Aug2014 VALUES LESS THAN (735840) ENGINE = InnoDB,
 PARTITION P31Aug2014 VALUES LESS THAN (735841) ENGINE = InnoDB,
 PARTITION P01Sep2014 VALUES LESS THAN (735842) ENGINE = InnoDB,
 PARTITION P02Sep2014 VALUES LESS THAN (735843) ENGINE = InnoDB,
 PARTITION P03Sep2014 VALUES LESS THAN (735844) ENGINE = InnoDB,
 PARTITION P04Sep2014 VALUES LESS THAN (735845) ENGINE = InnoDB,
 PARTITION P05Sep2014 VALUES LESS THAN (735846) ENGINE = InnoDB,
 PARTITION P06Sep2014 VALUES LESS THAN (735847) ENGINE = InnoDB,
 PARTITION P07Sep2014 VALUES LESS THAN (735848) ENGINE = InnoDB,
 PARTITION P08Sep2014 VALUES LESS THAN (735849) ENGINE = InnoDB,
 PARTITION P09Sep2014 VALUES LESS THAN (735850) ENGINE = InnoDB,
 PARTITION P10Sep2014 VALUES LESS THAN (735851) ENGINE = InnoDB,
 PARTITION P11Sep2014 VALUES LESS THAN (735852) ENGINE = InnoDB,
 PARTITION P12Sep2014 VALUES LESS THAN (735853) ENGINE = InnoDB,
 PARTITION P13Sep2014 VALUES LESS THAN (735854) ENGINE = InnoDB,
 PARTITION P14Sep2014 VALUES LESS THAN (735855) ENGINE = InnoDB,
 PARTITION P15Sep2014 VALUES LESS THAN (735856) ENGINE = InnoDB,
 PARTITION P16Sep2014 VALUES LESS THAN (735857) ENGINE = InnoDB,
 PARTITION P17Sep2014 VALUES LESS THAN (735858) ENGINE = InnoDB,
 PARTITION P18Sep2014 VALUES LESS THAN (735859) ENGINE = InnoDB,
 PARTITION P19Sep2014 VALUES LESS THAN (735860) ENGINE = InnoDB,
 PARTITION P20Sep2014 VALUES LESS THAN (735861) ENGINE = InnoDB,
 PARTITION P21Sep2014 VALUES LESS THAN (735862) ENGINE = InnoDB,
 PARTITION P22Sep2014 VALUES LESS THAN (735863) ENGINE = InnoDB,
 PARTITION P23Sep2014 VALUES LESS THAN (735864) ENGINE = InnoDB,
 PARTITION P24Sep2014 VALUES LESS THAN (735865) ENGINE = InnoDB,
 PARTITION P25Sep2014 VALUES LESS THAN (735866) ENGINE = InnoDB,
 PARTITION P26Sep2014 VALUES LESS THAN (735867) ENGINE = InnoDB,
 PARTITION P27Sep2014 VALUES LESS THAN (735868) ENGINE = InnoDB,
 PARTITION P28Sep2014 VALUES LESS THAN (735869) ENGINE = InnoDB,
 PARTITION P29Sep2014 VALUES LESS THAN (735870) ENGINE = InnoDB,
 PARTITION P30Sep2014 VALUES LESS THAN (735871) ENGINE = InnoDB,
 PARTITION P01Oct2014 VALUES LESS THAN (735872) ENGINE = InnoDB,
 PARTITION P02Oct2014 VALUES LESS THAN (735873) ENGINE = InnoDB,
 PARTITION P03Oct2014 VALUES LESS THAN (735874) ENGINE = InnoDB,
 PARTITION P04Oct2014 VALUES LESS THAN (735875) ENGINE = InnoDB,
 PARTITION P05Oct2014 VALUES LESS THAN (735876) ENGINE = InnoDB,
 PARTITION P06Oct2014 VALUES LESS THAN (735877) ENGINE = InnoDB,
 PARTITION P07Oct2014 VALUES LESS THAN (735878) ENGINE = InnoDB,
 PARTITION P08Oct2014 VALUES LESS THAN (735879) ENGINE = InnoDB,
 PARTITION P09Oct2014 VALUES LESS THAN (735880) ENGINE = InnoDB,
 PARTITION P10Oct2014 VALUES LESS THAN (735881) ENGINE = InnoDB,
 PARTITION P11Oct2014 VALUES LESS THAN (735882) ENGINE = InnoDB,
 PARTITION P12Oct2014 VALUES LESS THAN (735883) ENGINE = InnoDB,
 PARTITION P13Oct2014 VALUES LESS THAN (735884) ENGINE = InnoDB,
 PARTITION P14Oct2014 VALUES LESS THAN (735885) ENGINE = InnoDB,
 PARTITION P15Oct2014 VALUES LESS THAN (735886) ENGINE = InnoDB,
 PARTITION P16Oct2014 VALUES LESS THAN (735887) ENGINE = InnoDB,
 PARTITION P17Oct2014 VALUES LESS THAN (735888) ENGINE = InnoDB,
 PARTITION P18Oct2014 VALUES LESS THAN (735889) ENGINE = InnoDB,
 PARTITION P19Oct2014 VALUES LESS THAN (735890) ENGINE = InnoDB,
 PARTITION P20Oct2014 VALUES LESS THAN (735891) ENGINE = InnoDB,
 PARTITION P21Oct2014 VALUES LESS THAN (735892) ENGINE = InnoDB,
 PARTITION P22Oct2014 VALUES LESS THAN (735893) ENGINE = InnoDB,
 PARTITION P23Oct2014 VALUES LESS THAN (735894) ENGINE = InnoDB,
 PARTITION P24Oct2014 VALUES LESS THAN (735895) ENGINE = InnoDB,
 PARTITION P25Oct2014 VALUES LESS THAN (735896) ENGINE = InnoDB,
 PARTITION P26Oct2014 VALUES LESS THAN (735897) ENGINE = InnoDB,
 PARTITION P27Oct2014 VALUES LESS THAN (735898) ENGINE = InnoDB,
 PARTITION P28Oct2014 VALUES LESS THAN (735899) ENGINE = InnoDB,
 PARTITION P29Oct2014 VALUES LESS THAN (735900) ENGINE = InnoDB,
 PARTITION P30Oct2014 VALUES LESS THAN (735901) ENGINE = InnoDB,
 PARTITION P31Oct2014 VALUES LESS THAN (735902) ENGINE = InnoDB,
 PARTITION P01Nov2014 VALUES LESS THAN (735903) ENGINE = InnoDB,
 PARTITION P02Nov2014 VALUES LESS THAN (735904) ENGINE = InnoDB,
 PARTITION P03Nov2014 VALUES LESS THAN (735905) ENGINE = InnoDB,
 PARTITION P04Nov2014 VALUES LESS THAN (735906) ENGINE = InnoDB,
 PARTITION P05Nov2014 VALUES LESS THAN (735907) ENGINE = InnoDB,
 PARTITION P06Nov2014 VALUES LESS THAN (735908) ENGINE = InnoDB,
 PARTITION P07Nov2014 VALUES LESS THAN (735909) ENGINE = InnoDB,
 PARTITION P08Nov2014 VALUES LESS THAN (735910) ENGINE = InnoDB,
 PARTITION P09Nov2014 VALUES LESS THAN (735911) ENGINE = InnoDB,
 PARTITION P10Nov2014 VALUES LESS THAN (735912) ENGINE = InnoDB,
 PARTITION P11Nov2014 VALUES LESS THAN (735913) ENGINE = InnoDB,
 PARTITION P12Nov2014 VALUES LESS THAN (735914) ENGINE = InnoDB,
 PARTITION P13Nov2014 VALUES LESS THAN (735915) ENGINE = InnoDB,
 PARTITION P14Nov2014 VALUES LESS THAN (735916) ENGINE = InnoDB,
 PARTITION P15Nov2014 VALUES LESS THAN (735917) ENGINE = InnoDB,
 PARTITION P16Nov2014 VALUES LESS THAN (735918) ENGINE = InnoDB,
 PARTITION P17Nov2014 VALUES LESS THAN (735919) ENGINE = InnoDB,
 PARTITION P18Nov2014 VALUES LESS THAN (735920) ENGINE = InnoDB,
 PARTITION P19Nov2014 VALUES LESS THAN (735921) ENGINE = InnoDB,
 PARTITION P20Nov2014 VALUES LESS THAN (735922) ENGINE = InnoDB,
 PARTITION P21Nov2014 VALUES LESS THAN (735923) ENGINE = InnoDB,
 PARTITION P22Nov2014 VALUES LESS THAN (735924) ENGINE = InnoDB,
 PARTITION P23Nov2014 VALUES LESS THAN (735925) ENGINE = InnoDB,
 PARTITION P24Nov2014 VALUES LESS THAN (735926) ENGINE = InnoDB,
 PARTITION P25Nov2014 VALUES LESS THAN (735927) ENGINE = InnoDB,
 PARTITION P26Nov2014 VALUES LESS THAN (735928) ENGINE = InnoDB,
 PARTITION P27Nov2014 VALUES LESS THAN (735929) ENGINE = InnoDB,
 PARTITION P28Nov2014 VALUES LESS THAN (735930) ENGINE = InnoDB,
 PARTITION P29Nov2014 VALUES LESS THAN (735931) ENGINE = InnoDB,
 PARTITION P30Nov2014 VALUES LESS THAN (735932) ENGINE = InnoDB,
 PARTITION P01Dec2014 VALUES LESS THAN (735933) ENGINE = InnoDB,
 PARTITION P02Dec2014 VALUES LESS THAN (735934) ENGINE = InnoDB,
 PARTITION P03Dec2014 VALUES LESS THAN (735935) ENGINE = InnoDB,
 PARTITION P04Dec2014 VALUES LESS THAN (735936) ENGINE = InnoDB,
 PARTITION P05Dec2014 VALUES LESS THAN (735937) ENGINE = InnoDB,
 PARTITION P06Dec2014 VALUES LESS THAN (735938) ENGINE = InnoDB,
 PARTITION P07Dec2014 VALUES LESS THAN (735939) ENGINE = InnoDB,
 PARTITION P08Dec2014 VALUES LESS THAN (735940) ENGINE = InnoDB,
 PARTITION P09Dec2014 VALUES LESS THAN (735941) ENGINE = InnoDB,
 PARTITION P10Dec2014 VALUES LESS THAN (735942) ENGINE = InnoDB,
 PARTITION P11Dec2014 VALUES LESS THAN (735943) ENGINE = InnoDB,
 PARTITION P12Dec2014 VALUES LESS THAN (735944) ENGINE = InnoDB,
 PARTITION P13Dec2014 VALUES LESS THAN (735945) ENGINE = InnoDB,
 PARTITION P14Dec2014 VALUES LESS THAN (735946) ENGINE = InnoDB,
 PARTITION P15Dec2014 VALUES LESS THAN (735947) ENGINE = InnoDB,
 PARTITION P16Dec2014 VALUES LESS THAN (735948) ENGINE = InnoDB,
 PARTITION P17Dec2014 VALUES LESS THAN (735949) ENGINE = InnoDB,
 PARTITION P18Dec2014 VALUES LESS THAN (735950) ENGINE = InnoDB,
 PARTITION P19Dec2014 VALUES LESS THAN (735951) ENGINE = InnoDB,
 PARTITION P20Dec2014 VALUES LESS THAN (735952) ENGINE = InnoDB,
 PARTITION P21Dec2014 VALUES LESS THAN (735953) ENGINE = InnoDB,
 PARTITION P22Dec2014 VALUES LESS THAN (735954) ENGINE = InnoDB,
 PARTITION P23Dec2014 VALUES LESS THAN (735955) ENGINE = InnoDB,
 PARTITION P24Dec2014 VALUES LESS THAN (735956) ENGINE = InnoDB,
 PARTITION P25Dec2014 VALUES LESS THAN (735957) ENGINE = InnoDB,
 PARTITION P26Dec2014 VALUES LESS THAN (735958) ENGINE = InnoDB,
 PARTITION P27Dec2014 VALUES LESS THAN (735959) ENGINE = InnoDB,
 PARTITION P28Dec2014 VALUES LESS THAN (735960) ENGINE = InnoDB,
 PARTITION P29Dec2014 VALUES LESS THAN (735961) ENGINE = InnoDB,
 PARTITION P30Dec2014 VALUES LESS THAN (735962) ENGINE = InnoDB,
 PARTITION P31Dec2014 VALUES LESS THAN (735963) ENGINE = InnoDB,
 PARTITION P01Jan2015 VALUES LESS THAN (735964) ENGINE = InnoDB,
 PARTITION P02Jan2015 VALUES LESS THAN (735965) ENGINE = InnoDB,
 PARTITION P03Jan2015 VALUES LESS THAN (735966) ENGINE = InnoDB,
 PARTITION P04Jan2015 VALUES LESS THAN (735967) ENGINE = InnoDB,
 PARTITION P05Jan2015 VALUES LESS THAN (735968) ENGINE = InnoDB,
 PARTITION P06Jan2015 VALUES LESS THAN (735969) ENGINE = InnoDB,
 PARTITION P07Jan2015 VALUES LESS THAN (735970) ENGINE = InnoDB,
 PARTITION P08Jan2015 VALUES LESS THAN (735971) ENGINE = InnoDB,
 PARTITION P09Jan2015 VALUES LESS THAN (735972) ENGINE = InnoDB,
 PARTITION P10Jan2015 VALUES LESS THAN (735973) ENGINE = InnoDB,
 PARTITION P11Jan2015 VALUES LESS THAN (735974) ENGINE = InnoDB,
 PARTITION P12Jan2015 VALUES LESS THAN (735975) ENGINE = InnoDB,
 PARTITION P13Jan2015 VALUES LESS THAN (735976) ENGINE = InnoDB,
 PARTITION P14Jan2015 VALUES LESS THAN (735977) ENGINE = InnoDB,
 PARTITION P15Jan2015 VALUES LESS THAN (735978) ENGINE = InnoDB,
 PARTITION P16Jan2015 VALUES LESS THAN (735979) ENGINE = InnoDB,
 PARTITION P17Jan2015 VALUES LESS THAN (735980) ENGINE = InnoDB,
 PARTITION P18Jan2015 VALUES LESS THAN (735981) ENGINE = InnoDB,
 PARTITION P19Jan2015 VALUES LESS THAN (735982) ENGINE = InnoDB,
 PARTITION P20Jan2015 VALUES LESS THAN (735983) ENGINE = InnoDB,
 PARTITION P21Jan2015 VALUES LESS THAN (735984) ENGINE = InnoDB,
 PARTITION P22Jan2015 VALUES LESS THAN (735985) ENGINE = InnoDB,
 PARTITION P23Jan2015 VALUES LESS THAN (735986) ENGINE = InnoDB,
 PARTITION P24Jan2015 VALUES LESS THAN (735987) ENGINE = InnoDB,
 PARTITION P25Jan2015 VALUES LESS THAN (735988) ENGINE = InnoDB,
 PARTITION P26Jan2015 VALUES LESS THAN (735989) ENGINE = InnoDB,
 PARTITION P27Jan2015 VALUES LESS THAN (735990) ENGINE = InnoDB,
 PARTITION P28Jan2015 VALUES LESS THAN (735991) ENGINE = InnoDB,
 PARTITION P29Jan2015 VALUES LESS THAN (735992) ENGINE = InnoDB,
 PARTITION P30Jan2015 VALUES LESS THAN (735993) ENGINE = InnoDB,
 PARTITION P31Jan2015 VALUES LESS THAN (735994) ENGINE = InnoDB,
 PARTITION P01Feb2015 VALUES LESS THAN (735995) ENGINE = InnoDB,
 PARTITION P02Feb2015 VALUES LESS THAN (735996) ENGINE = InnoDB,
 PARTITION P03Feb2015 VALUES LESS THAN (735997) ENGINE = InnoDB,
 PARTITION P04Feb2015 VALUES LESS THAN (735998) ENGINE = InnoDB,
 PARTITION P05Feb2015 VALUES LESS THAN (735999) ENGINE = InnoDB,
 PARTITION P06Feb2015 VALUES LESS THAN (736000) ENGINE = InnoDB,
 PARTITION P07Feb2015 VALUES LESS THAN (736001) ENGINE = InnoDB,
 PARTITION P08Feb2015 VALUES LESS THAN (736002) ENGINE = InnoDB,
 PARTITION P09Feb2015 VALUES LESS THAN (736003) ENGINE = InnoDB,
 PARTITION P10Feb2015 VALUES LESS THAN (736004) ENGINE = InnoDB,
 PARTITION P11Feb2015 VALUES LESS THAN (736005) ENGINE = InnoDB,
 PARTITION P12Feb2015 VALUES LESS THAN (736006) ENGINE = InnoDB,
 PARTITION P13Feb2015 VALUES LESS THAN (736007) ENGINE = InnoDB,
 PARTITION P14Feb2015 VALUES LESS THAN (736008) ENGINE = InnoDB,
 PARTITION P15Feb2015 VALUES LESS THAN (736009) ENGINE = InnoDB,
 PARTITION P16Feb2015 VALUES LESS THAN (736010) ENGINE = InnoDB,
 PARTITION P17Feb2015 VALUES LESS THAN (736011) ENGINE = InnoDB,
 PARTITION P18Feb2015 VALUES LESS THAN (736012) ENGINE = InnoDB,
 PARTITION P19Feb2015 VALUES LESS THAN (736013) ENGINE = InnoDB,
 PARTITION P20Feb2015 VALUES LESS THAN (736014) ENGINE = InnoDB,
 PARTITION P21Feb2015 VALUES LESS THAN (736015) ENGINE = InnoDB,
 PARTITION P22Feb2015 VALUES LESS THAN (736016) ENGINE = InnoDB,
 PARTITION P23Feb2015 VALUES LESS THAN (736017) ENGINE = InnoDB,
 PARTITION P24Feb2015 VALUES LESS THAN (736018) ENGINE = InnoDB,
 PARTITION P25Feb2015 VALUES LESS THAN (736019) ENGINE = InnoDB,
 PARTITION P26Feb2015 VALUES LESS THAN (736020) ENGINE = InnoDB,
 PARTITION P27Feb2015 VALUES LESS THAN (736021) ENGINE = InnoDB,
 PARTITION P28Feb2015 VALUES LESS THAN (736022) ENGINE = InnoDB,
 PARTITION P01Mar2015 VALUES LESS THAN (736023) ENGINE = InnoDB,
 PARTITION P02Mar2015 VALUES LESS THAN (736024) ENGINE = InnoDB,
 PARTITION P03Mar2015 VALUES LESS THAN (736025) ENGINE = InnoDB,
 PARTITION P04Mar2015 VALUES LESS THAN (736026) ENGINE = InnoDB,
 PARTITION P05Mar2015 VALUES LESS THAN (736027) ENGINE = InnoDB,
 PARTITION P06Mar2015 VALUES LESS THAN (736028) ENGINE = InnoDB,
 PARTITION P07Mar2015 VALUES LESS THAN (736029) ENGINE = InnoDB,
 PARTITION P08Mar2015 VALUES LESS THAN (736030) ENGINE = InnoDB,
 PARTITION P09Mar2015 VALUES LESS THAN (736031) ENGINE = InnoDB,
 PARTITION P10Mar2015 VALUES LESS THAN (736032) ENGINE = InnoDB,
 PARTITION P11Mar2015 VALUES LESS THAN (736033) ENGINE = InnoDB,
 PARTITION P12Mar2015 VALUES LESS THAN (736034) ENGINE = InnoDB,
 PARTITION P13Mar2015 VALUES LESS THAN (736035) ENGINE = InnoDB,
 PARTITION P14Mar2015 VALUES LESS THAN (736036) ENGINE = InnoDB,
 PARTITION P15Mar2015 VALUES LESS THAN (736037) ENGINE = InnoDB,
 PARTITION P16Mar2015 VALUES LESS THAN (736038) ENGINE = InnoDB,
 PARTITION P17Mar2015 VALUES LESS THAN (736039) ENGINE = InnoDB,
 PARTITION P18Mar2015 VALUES LESS THAN (736040) ENGINE = InnoDB,
 PARTITION P19Mar2015 VALUES LESS THAN (736041) ENGINE = InnoDB,
 PARTITION P20Mar2015 VALUES LESS THAN (736042) ENGINE = InnoDB,
 PARTITION P21Mar2015 VALUES LESS THAN (736043) ENGINE = InnoDB,
 PARTITION P22Mar2015 VALUES LESS THAN (736044) ENGINE = InnoDB,
 PARTITION P23Mar2015 VALUES LESS THAN (736045) ENGINE = InnoDB,
 PARTITION P24Mar2015 VALUES LESS THAN (736046) ENGINE = InnoDB,
 PARTITION P25Mar2015 VALUES LESS THAN (736047) ENGINE = InnoDB,
 PARTITION P26Mar2015 VALUES LESS THAN (736048) ENGINE = InnoDB,
 PARTITION P27Mar2015 VALUES LESS THAN (736049) ENGINE = InnoDB,
 PARTITION P28Mar2015 VALUES LESS THAN (736050) ENGINE = InnoDB,
 PARTITION P29Mar2015 VALUES LESS THAN (736051) ENGINE = InnoDB,
 PARTITION P30Mar2015 VALUES LESS THAN (736052) ENGINE = InnoDB,
 PARTITION P31Mar2015 VALUES LESS THAN (736053) ENGINE = InnoDB,
 PARTITION P01Apr2015 VALUES LESS THAN (736054) ENGINE = InnoDB,
 PARTITION PMaxValue VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1 row in set (0.02 sec)

mysql> show create view vwUnits\G
*************************** 1. row ***************************
                View: vwUnits
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vwUnits` AS select `tblUnits`.`UnitID` AS `UnitID`,`tblUnits`.`ESN` AS `ESN`,`tblUnits`.`ICCID` AS `ICCID`,`tblUnits`.`MSISDN` AS `MSISDN`,`tblUnits`.`IMEI` AS `IMEI`,`tblUnits`.`OwnerID` AS `OwnerID`,`tblUnits`.`VehicleID` AS `VehicleID`,`tblUnits`.`DesiredRateLevel` AS `DesiredRateLevel`,`tblUnits`.`RateLevel` AS `RateLevel`,`tblUnits`.`Config` AS `Config`,`tblUnits`.`ConfigLast` AS `ConfigLast`,`tblUnits`.`ConfigLastTime` AS `ConfigLastTime`,`tblUnits`.`Miles` AS `Miles`,`tblUnits`.`LastMiles` AS `LastMiles`,`tblUnits`.`LandmarkID` AS `LandmarkID`,`tblUnits`.`ResellerID` AS `ResellerID`,`tblUnits`.`RA` AS `RA`,`tblUnits`.`RAReason` AS `RAReason`,`tblUnits`.`RAOther` AS `RAOther`,`tblModelPrefixes`.`ModelName` AS `ModelName`,`tblCellularCarriers`.`CarrierName` AS `CarrierName`,`tblCellularCarriers`.`CarrierSub` AS `CarrierSub` from ((`tblUnits` left join `tblModelPrefixes` on(((length(`tblUnits`.`ESN`) = `tblModelPrefixes`.`ESNLength`) and (`tblUnits`.`ESN` like concat(`tblModelPrefixes`.`ESNPrefix`,_latin1'%'))))) left join `tblCellularCarriers` on(((length(`tblUnits`.`ICCID`) = `tblCellularCarriers`.`ICCIDLength`) and (`tblUnits`.`ICCID` like concat(`tblCellularCarriers`.`ICCIDPrefix`,_latin1'%')))))
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)

mysql> show create table tblUnits\G
*************************** 1. row ***************************
       Table: tblUnits
Create Table: CREATE TABLE `tblUnits` (
  `UnitID` char(22) NOT NULL,
  `ESN` char(16) NOT NULL,
  `ICCID` char(32) DEFAULT NULL,
  `MSISDN` char(20) DEFAULT NULL,
  `IMEI` char(16) DEFAULT NULL,
  `OwnerID` char(22) DEFAULT NULL,
  `VehicleID` char(22) DEFAULT NULL,
  `DesiredRateLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `RateLevel` smallint(5) DEFAULT NULL,
  `Config` char(255) DEFAULT NULL,
  `ConfigLast` char(255) DEFAULT NULL,
  `ConfigLastTime` datetime DEFAULT NULL,
  `HardwareVersion` varchar(10) DEFAULT NULL,
  `SoftwareVersion` varchar(10) DEFAULT NULL,
  `Miles` int(11) DEFAULT NULL,
  `LastMiles` int(11) DEFAULT NULL,
  `LandmarkID` char(22) DEFAULT NULL,
  `ResellerID` char(22) DEFAULT NULL,
  `RA` varchar(50) NOT NULL,
  `RAReason` varchar(25) NOT NULL,
  `RAOther` text NOT NULL,
  `DevelopmentUnit` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`UnitID`),
  UNIQUE KEY `ESN` (`ESN`),
  UNIQUE KEY `ICCID` (`ICCID`),
  KEY `OwnerID` (`OwnerID`),
  KEY `ResellerID` (`ResellerID`),
  KEY `VehicleID` (`VehicleID`),
  KEY `MSISDN` (`MSISDN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='GPS Units'
1 row in set (0.00 sec)

mysql> show create table tblModelPrefixes\G
*************************** 1. row ***************************
       Table: tblModelPrefixes
Create Table: CREATE TABLE `tblModelPrefixes` (
  `ModelName` char(16) NOT NULL,
  `ESNPrefix` char(12) NOT NULL,
  `ESNLength` smallint(5) unsigned NOT NULL DEFAULT '0',
  `DefaultModel` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ESNPrefix`),
  KEY `ModelName` (`ModelName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='GPS Model Type ESN Prefixes'
1 row in set (0.00 sec)

mysql> show create table tblCellularCarriers\G
*************************** 1. row ***************************
       Table: tblCellularCarriers
Create Table: CREATE TABLE `tblCellularCarriers` (
  `CarrierName` char(50) NOT NULL,
  `CarrierSub` char(8) NOT NULL,
  `ICCIDPrefix` char(20) DEFAULT NULL,
  `ICCIDLength` smallint(5) unsigned NOT NULL DEFAULT '0',
  `MSISDNPrefix` char(10) DEFAULT NULL,
  `DefaultCarrier` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `CarrierKBRate` decimal(10,2) NOT NULL,
  `CarrierSMSRate` decimal(2,2) NOT NULL,
  `CarrierMonthDeviceRate` decimal(3,2) NOT NULL,
  `CarrierPlanDescr` varchar(200) NOT NULL,
  PRIMARY KEY (`CarrierName`,`CarrierSub`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Cellular Carriers and their ICCID ranges'
1 row in set (0.00 sec)

Those are all the tables used in my original query as requested by @Valerii

Valerii Kravchuk (valerii-kravchuk) on 2014-04-09

Changed in percona-server:
status:	Incomplete → New

Revision history for this message

Muhammad Irfan (muhammad-irfan) wrote on 2014-06-19:

Download full text (15.6 KiB)

I able to reproduce this problem on PS 5.5/5.6 and upstream too with test data. Below are the results.

Percona Server 5.6.17:
=====================

Percona Server 5.5.37:
=====================

Oracle MySQL 5.6.19:
===================

I able to reproduce this problem on PS 5.5/5.6 and upstream too with test data. Below are the results.

Percona Server 5.6.17:
=====================

mysql [localhost] {msandbox} (test) > show global variables like '%version%';
+-------------------------+--------------------------------------------------+
| Variable_name           | Value                                            |
+-------------------------+--------------------------------------------------+
| innodb_version          | 5.6.17-rel66.0                                   |
| protocol_version        | 10                                               |
| slave_type_conversions  |                                                  |
| version                 | 5.6.17-66.0                                      |
| version_comment         | Percona Server (GPL), Release 66.0, Revision 608 |
| version_compile_machine | x86_64                                           |
| version_compile_os      | Linux                                            |
+-------------------------+--------------------------------------------------+

Percona Server 5.5.37:
=====================

mysql [localhost] {msandbox} (test) > EXPLAIN PARTITIONS SELECT COUNT( * ) AS Count
 FROM test.tblDataSentSMS du
 JOIN test.vwUnits un ON ( du.ESN = un.ESN
 AND un.CarrierName = 'Cingular' )
 WHERE
 CASE
 WHEN DATE_FORMAT( NOW( ) , '%e' ) <=8
 THEN du.DateSent
 BETWEEN DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-9' ) , INTERVAL 1
 MONTH )
 AND DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) , INTERVAL 1
 DAY )
 ELSE du.DateSent
 BETWEEN DATE_FORMAT( NOW( ) , '%Y-%m-09' )
 AND DATE_SUB( DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) , INTERVAL 1
 DAY )
 END\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblCellularCarriers
   partitions: NULL
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 50
          ref: const
         rows: 1
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: du
   partitions: P21Nov2012,P22Nov2012,P23Nov2012,P24Nov2012,P25Nov2012,P26Nov2012,P27Nov2012,P28Nov2012,P29Nov2012,P30Nov2012,P01Dec2012,P02Dec2012,P03Dec2012,P04Dec2012,P05Dec2012,P06Dec2012,P07Dec2012,P08Dec2012,P09Dec2012,P10Dec2012,P11Dec2012,P12Dec2012,P13Dec2012,P14Dec2012,P15Dec2012,P16Dec2012,P17Dec2012,P18Dec2012,P19Dec2012,P20Dec2012,P21Dec2012,P22Dec2012,P23Dec2012,P24Dec2012,P25Dec2012,P26Dec2012,P27Dec2012,P28Dec2012,P29Dec2012,P30Dec2012,P31Dec2012,P01Jan2013,P02Jan2013,P03Jan2013,P04Jan2013,P05Jan2013,P06Jan2013,P07Jan2013,P08Jan2013,P09Jan2013,P10Jan2013,P11Jan2013,P12Jan2013,P13Jan2013,P14Jan2013,P15Jan2013,P16Jan2013,P17Jan2013,P18Jan2013,P19Jan2013,P20Jan2013,P21Jan2013,P22Jan2013,P23Jan2013,P24Jan2013,P25Jan2013,P26Jan2013,P27Jan2013,P28Jan2013,P29Jan2013,P30Jan2013,P31Jan2013,P01Feb2013,P02Feb2013,P03Feb2013,P04Feb2013,P05Feb2013,P06Feb2013,P07Feb2013,P08Feb2013,P09Feb2013,P10Feb2013,P11Feb2013,P12Feb2013,P13Feb2013,P14Feb2013,P15Feb2013,P16Feb2013,P17Feb2013,P18Feb2013,P19Feb2013,P20Feb2013,P21Feb2013,P22Feb2013,P23Feb2013,P24Feb2013,P25Feb2013,P26Feb2013,P27Feb2013,P28Feb2013,P01Mar2013,P02Mar2013,P03Mar2013,P04Mar2013,P05Mar2013,P06Mar2013,P07Mar2013,P08Mar2013,P09Mar2013,P10Mar2013,P11Mar2013,P12Mar2013,P13Mar2013,P14Mar2013,P15Mar2013,P16Mar2013,P17Mar2013,P18Mar2013,P19Mar2013,P20Mar2013,P21Mar2013,P22Mar2013,P23Mar2013,P24Mar2013,P25Mar2013,P26Mar2013,P27Mar2013,P28Mar2013,P29Mar2013,P30Mar2013,P31Mar2013,P01Apr2013,P02Apr2013,P03Apr2013,P04Apr2013,P05Apr2013,P06Apr2013,P07Apr2013,P08Apr2013,P09Apr2013,P10Apr2013,P11Apr2013,P12Apr2013,P13Apr2013,P14Apr2013,P15Apr2013,P16Apr2013,P17Apr2013,P18Apr2013,P19Apr2013,P20Apr2013,P21Apr2013,P22Apr2013,P23Apr2013,P24Apr2013,P25Apr2013,P26Apr2013,P27Apr2013,P28Apr2013,P29Apr2013,P30Apr2013,P01May2013,P02May2013,P03May2013,P04May2013,P05May2013,P06May2013,P07May2013,P08May2013,P09May2013,P10May2013,P11May2013,P12May2013,P13May2013,P14May2013,P15May2013,P16May2013,P17May2013,P18May2013,P19May2013,P20May2013,P21May2013,P22May2013,P23May2013,P24May2013,P25May2013,P26May2013,P27May2013,P28May2013,P29May2013,P30May2013,P31May2013,P01Jun2013,P02Jun2013,P03Jun2013,P04Jun2013,P05Jun2013,P06Jun2013,P07Jun2013,P08Jun2013,P09Jun2013,P10Jun2013,P11Jun2013,P12Jun2013,P13Jun2013,P14Jun2013,P15Jun2013,P16Jun2013,P17Jun2013,P18Jun2013,P19Jun2013,P20Jun2013,P21Jun2013,P22Jun2013,P23Jun2013,P24Jun2013,P25Jun2013,P26Jun2013,P27Jun2013,P28Jun2013,P29Jun2013,P30Jun2013,P01Jul2013,P02Jul2013,P03Jul2013,P04Jul2013,P05Jul2013,P06Jul2013,P07Jul2013,P08Jul2013,P09Jul2013,P10Jul2013,P11Jul2013,P12Jul2013,P13Jul2013,P14Jul2013,P15Jul2013,P16Jul2013,P17Jul2013,P18Jul2013,P19Jul2013,P20Jul2013,P21Jul2013,P22Jul2013,P23Jul2013,P24Jul2013,P25Jul2013,P26Jul2013,P27Jul2013,P28Jul2013,P29Jul2013,P30Jul2013,P31Jul2013,P01Aug2013,P02Aug2013,P03Aug2013,P04Aug2013,P05Aug2013,P06Aug2013,P07Aug2013,P08Aug2013,P09Aug2013,P10Aug2013,P11Aug2013,P12Aug2013,P13Aug2013,P14Aug2013,P15Aug2013,P16Aug2013,P17Aug2013,P18Aug2013,P19Aug2013,P20Aug2013,P21Aug2013,P22Aug2013,P23Aug2013,P24Aug2013,P25Aug2013,P26Aug2013,P27Aug2013,P28Aug2013,P29Aug2013,P30Aug2013,P31Aug2013,P01Sep2013,P02Sep2013,P03Sep2013,P04Sep2013,P05Sep2013,P06Sep2013,P07Sep2013,P08Sep2013,P09Sep2013,P10Sep2013,P11Sep2013,P12Sep2013,P13Sep2013,P14Sep2013,P15Sep2013,P16Sep2013,P17Sep2013,P18Sep2013,P19Sep2013,P20Sep2013,P21Sep2013,P22Sep2013,P23Sep2013,P24Sep2013,P25Sep2013,P26Sep2013,P27Sep2013,P28Sep2013,P29Sep2013,P30Sep2013,P01Oct2013,P02Oct2013,P03Oct2013,P04Oct2013,P05Oct2013,P06Oct2013,P07Oct2013,P08Oct2013,P09Oct2013,P10Oct2013,P11Oct2013,P12Oct2013,P13Oct2013,P14Oct2013,P15Oct2013,P16Oct2013,P17Oct2013,P18Oct2013,P19Oct2013,P20Oct2013,P21Oct2013,P22Oct2013,P23Oct2013,P24Oct2013,P25Oct2013,P26Oct2013,P27Oct2013,P28Oct2013,P29Oct2013,P30Oct2013,P31Oct2013,P01Nov2013,P02Nov2013,P03Nov2013,P04Nov2013,P05Nov2013,P06Nov2013,P07Nov2013,P08Nov2013,P09Nov2013,P10Nov2013,P11Nov2013,P12Nov2013,P13Nov2013,P14Nov2013,P15Nov2013,P16Nov2013,P17Nov2013,P18Nov2013,P19Nov2013,P20Nov2013,P21Nov2013,P22Nov2013,P23Nov2013,P24Nov2013,P25Nov2013,P26Nov2013,P27Nov2013,P28Nov2013,P29Nov2013,P30Nov2013,P01Dec2013,P02Dec2013,P03Dec2013,P04Dec2013,P05Dec2013,P06Dec2013,P07Dec2013,P08Dec2013,P09Dec2013,P10Dec2013,P11Dec2013,P12Dec2013,P13Dec2013,P14Dec2013,P15Dec2013,P16Dec2013,P17Dec2013,P18Dec2013,P19Dec2013,P20Dec2013,P21Dec2013,P22Dec2013,P23Dec2013,P24Dec2013,P25Dec2013,P26Dec2013,P27Dec2013,P28Dec2013,P29Dec2013,P30Dec2013,P31Dec2013,P01Jan2014,P02Jan2014,P03Jan2014,P04Jan2014,P05Jan2014,P06Jan2014,P07Jan2014,P08Jan2014,P09Jan2014,P10Jan2014,P11Jan2014,P12Jan2014,P13Jan2014,P14Jan2014,P15Jan2014,P16Jan2014,P17Jan2014,P18Jan2014,P19Jan2014,P20Jan2014,P21Jan2014,P22Jan2014,P23Jan2014,P24Jan2014,P25Jan2014,P26Jan2014,P27Jan2014,P28Jan2014,P29Jan2014,P30Jan2014,P31Jan2014,P01Feb2014,P02Feb2014,P03Feb2014,P04Feb2014,P05Feb2014,P06Feb2014,P07Feb2014,P08Feb2014,P09Feb2014,P10Feb2014,P11Feb2014,P12Feb2014,P13Feb2014,P14Feb2014,P15Feb2014,P16Feb2014,P17Feb2014,P18Feb2014,P19Feb2014,P20Feb2014,P21Feb2014,P22Feb2014,P23Feb2014,P24Feb2014,P25Feb2014,P26Feb2014,P27Feb2014,P28Feb2014,P01Mar2014,P02Mar2014,P03Mar2014,P04Mar2014,P05Mar2014,P06Mar2014,P07Mar2014,P08Mar2014,P09Mar2014,P10Mar2014,P11Mar2014,P12Mar2014,P13Mar2014,P14Mar2014,P15Mar2014,P16Mar2014,P17Mar2014,P18Mar2014,P19Mar2014,P20Mar2014,P21Mar2014,P22Mar2014,P23Mar2014,P24Mar2014,P25Mar2014,P26Mar2014,P27Mar2014,P28Mar2014,P29Mar2014,P30Mar2014,P31Mar2014,P01Apr2014,P02Apr2014,P03Apr2014,P04Apr2014,P05Apr2014,P06Apr2014,P07Apr2014,P08Apr2014,P09Apr2014,P10Apr2014,P11Apr2014,P12Apr2014,P13Apr2014,P14Apr2014,P15Apr2014,P16Apr2014,P17Apr2014,P18Apr2014,P19Apr2014,P20Apr2014,P21Apr2014,P22Apr2014,P23Apr2014,P24Apr2014,P25Apr2014,P26Apr2014,P27Apr2014,P28Apr2014,P29Apr2014,P30Apr2014,P01May2014,P02May2014,P03May2014,P04May2014,P05May2014,P06May2014,P07May2014,P08May2014,P09May2014,P10May2014,P11May2014,P12May2014,P13May2014,P14May2014,P15May2014,P16May2014,P17May2014,P18May2014,P19May2014,P20May2014,P21May2014,P22May2014,P23May2014,P24May2014,P25May2014,P26May2014,P27May2014,P28May2014,P29May2014,P30May2014,P31May2014,P01Jun2014,P02Jun2014,P03Jun2014,P04Jun2014,P05Jun2014,P06Jun2014,P07Jun2014,P08Jun2014,P09Jun2014,P10Jun2014,P11Jun2014,P12Jun2014,P13Jun2014,P14Jun2014,P15Jun2014,P16Jun2014,P17Jun2014,P18Jun2014,P19Jun2014,P20Jun2014,P21Jun2014,P22Jun2014,P23Jun2014,P24Jun2014,P25Jun2014,P26Jun2014,P27Jun2014,P28Jun2014,P29Jun2014,P30Jun2014,P01Jul2014,P02Jul2014,P03Jul2014,P04Jul2014,P05Jul2014,P06Jul2014,P07Jul2014,P08Jul2014,P09Jul2014,P10Jul2014,P11Jul2014,P12Jul2014,P13Jul2014,P14Jul2014,P15Jul2014,P16Jul2014,P17Jul2014,P18Jul2014,P19Jul2014,P20Jul2014,P21Jul2014,P22Jul2014,P23Jul2014,P24Jul2014,P25Jul2014,P26Jul2014,P27Jul2014,P28Jul2014,P29Jul2014,P30Jul2014,P31Jul2014,P01Aug2014,P02Aug2014,P03Aug2014,P04Aug2014,P05Aug2014,P06Aug2014,P07Aug2014,P08Aug2014,P09Aug2014,P10Aug2014,P11Aug2014,P12Aug2014,P13Aug2014,P14Aug2014,P15Aug2014,P16Aug2014,P17Aug2014,P18Aug2014,P19Aug2014,P20Aug2014,P21Aug2014,P22Aug2014,P23Aug2014,P24Aug2014,P25Aug2014,P26Aug2014,P27Aug2014,P28Aug2014,P29Aug2014,P30Aug2014,P31Aug2014,P01Sep2014,P02Sep2014,P03Sep2014,P04Sep2014,P05Sep2014,P06Sep2014,P07Sep2014,P08Sep2014,P09Sep2014,P10Sep2014,P11Sep2014,P12Sep2014,P13Sep2014,P14Sep2014,P15Sep2014,P16Sep2014,P17Sep2014,P18Sep2014,P19Sep2014,P20Sep2014,P21Sep2014,P22Sep2014,P23Sep2014,P24Sep2014,P25Sep2014,P26Sep2014,P27Sep2014,P28Sep2014,P29Sep2014,P30Sep2014,P01Oct2014,P02Oct2014,P03Oct2014,P04Oct2014,P05Oct2014,P06Oct2014,P07Oct2014,P08Oct2014,P09Oct2014,P10Oct2014,P11Oct2014,P12Oct2014,P13Oct2014,P14Oct2014,P15Oct2014,P16Oct2014,P17Oct2014,P18Oct2014,P19Oct2014,P20Oct2014,P21Oct2014,P22Oct2014,P23Oct2014,P24Oct2014,P25Oct2014,P26Oct2014,P27Oct2014,P28Oct2014,P29Oct2014,P30Oct2014,P31Oct2014,P01Nov2014,P02Nov2014,P03Nov2014,P04Nov2014,P05Nov2014,P06Nov2014,P07Nov2014,P08Nov2014,P09Nov2014,P10Nov2014,P11Nov2014,P12Nov2014,P13Nov2014,P14Nov2014,P15Nov2014,P16Nov2014,P17Nov2014,P18Nov2014,P19Nov2014,P20Nov2014,P21Nov2014,P22Nov2014,P23Nov2014,P24Nov2014,P25Nov2014,P26Nov2014,P27Nov2014,P28Nov2014,P29Nov2014,P30Nov2014,P01Dec2014,P02Dec2014,P03Dec2014,P04Dec2014,P05Dec2014,P06Dec2014,P07Dec2014,P08Dec2014,P09Dec2014,P10Dec2014,P11Dec2014,P12Dec2014,P13Dec2014,P14Dec2014,P15Dec2014,P16Dec2014,P17Dec2014,P18Dec2014,P19Dec2014,P20Dec2014,P21Dec2014,P22Dec2014,P23Dec2014,P24Dec2014,P25Dec2014,P26Dec2014,P27Dec2014,P28Dec2014,P29Dec2014,P30Dec2014,P31Dec2014,P01Jan2015,P02Jan2015,P03Jan2015,P04Jan2015,P05Jan2015,P06Jan2015,P07Jan2015,P08Jan2015,P09Jan2015,P10Jan2015,P11Jan2015,P12Jan2015,P13Jan2015,P14Jan2015,P15Jan2015,P16Jan2015,P17Jan2015,P18Jan2015,P19Jan2015,P20Jan2015,P21Jan2015,P22Jan2015,P23Jan2015,P24Jan2015,P25Jan2015,P26Jan2015,P27Jan2015,P28Jan2015,P29Jan2015,P30Jan2015,P31Jan2015,P01Feb2015,P02Feb2015,P03Feb2015,P04Feb2015,P05Feb2015,P06Feb2015,P07Feb2015,P08Feb2015,P09Feb2015,P10Feb2015,P11Feb2015,P12Feb2015,P13Feb2015,P14Feb2015,P15Feb2015,P16Feb2015,P17Feb2015,P18Feb2015,P19Feb2015,P20Feb2015,P21Feb2015,P22Feb2015,P23Feb2015,P24Feb2015,P25Feb2015,P26Feb2015,P27Feb2015,P28Feb2015,P01Mar2015,P02Mar2015,P03Mar2015,P04Mar2015,P05Mar2015,P06Mar2015,P07Mar2015,P08Mar2015,P09Mar2015,P10Mar2015,P11Mar2015,P12Mar2015,P13Mar2015,P14Mar2015,P15Mar2015,P16Mar2015,P17Mar2015,P18Mar2015,P19Mar2015,P20Mar2015,P21Mar2015,P22Mar2015,P23Mar2015,P24Mar2015,P25Mar2015,P26Mar2015,P27Mar2015,P28Mar2015,P29Mar2015,P30Mar2015,P31Mar2015,P01Apr2015,PMaxValue
         type: index
possible_keys: ESN
          key: ESN
      key_len: 21
          ref: NULL
         rows: 1193
        Extra: Using where; Using index; Using join buffer (Block Nested Loop)
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblUnits
   partitions: NULL
         type: ref
possible_keys: ESN
          key: ESN
      key_len: 16
          ref: test.du.ESN
         rows: 1
        Extra: Using index condition; Using where
*************************** 4. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblModelPrefixes
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 6
        Extra: Using where; Using join buffer (Block Nested Loop)
4 rows in set (0.04 sec)
 
mysql [localhost] {msandbox} (test) > EXPLAIN partitions (SELECT count(*) as Count FROM test.tblDataSentSMS du
 JOIN test.vwUnits un on (du.ESN = un.ESN and un.CarrierName = 'Cingular')
 WHERE du.DateSent Between DATE_SUB(date_format(now(), '%Y-%m-9'), interval 1 MONTH) AND DATE_SUB(date_format(now(), '%Y-%m-%d'), interval 1 day))\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblCellularCarriers
   partitions: NULL
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 50
          ref: const
         rows: 1
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: du
   partitions: P21Nov2012,P10May2014,P11May2014,P12May2014,P13May2014,P14May2014,P15May2014,P16May2014,P17May2014,P18May2014,P19May2014,P20May2014,P21May2014,P22May2014,P23May2014,P24May2014,P25May2014,P26May2014,P27May2014,P28May2014,P29May2014,P30May2014,P31May2014,P01Jun2014,P02Jun2014,P03Jun2014,P04Jun2014,P05Jun2014,P06Jun2014,P07Jun2014,P08Jun2014,P09Jun2014,P10Jun2014,P11Jun2014,P12Jun2014,P13Jun2014,P14Jun2014,P15Jun2014,P16Jun2014,P17Jun2014,P18Jun2014,P19Jun2014
         type: index
possible_keys: ESN
          key: ESN
      key_len: 21
          ref: NULL
         rows: 372
        Extra: Using where; Using index; Using join buffer (Block Nested Loop)
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblUnits
   partitions: NULL
         type: ref
possible_keys: ESN
          key: ESN
      key_len: 16
          ref: test.du.ESN
         rows: 1
        Extra: Using index condition; Using where
*************************** 4. row ***************************
           id: 1
  select_type: SIMPLE
        table: tblModelPrefixes
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 6
        Extra: Using where; Using join buffer (Block Nested Loop)
4 rows in set (0.10 sec)

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2014-06-21:

Muhammad -

Can you please check whether it's already reported upstream and report it there if not?

Revision history for this message

Muhammad Irfan (muhammad-irfan) wrote on 2014-06-24:

Laurynas,

Upstream bug reported http://bugs.mysql.com/bug.php?id=73094

Laurynas Biveinis (laurynas-biveinis) on 2014-06-24

tags:

added: upstream

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1492

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

mysql-bugs #73094 Edit

Bug watches keep track of this bug in other bug trackers.