spark写mysql性能_使用Apache Spark 对 mysql 调优 查询速度提升10倍以上

CHARSET=latin1

/*!50100 PARTITION BY RANGE (YearD)

(PARTITION p1987 VALUES LESS THAN (1988) ENGINE = InnoDB,

PARTITION p1988 VALUES LESS THAN (1989) ENGINE = InnoDB,

PARTITION p1989 VALUES LESS THAN (1990) ENGINE = InnoDB,

PARTITION p1990 VALUES LESS THAN (1991) ENGINE = InnoDB,

PARTITION p1991 VALUES LESS THAN (1992) ENGINE = InnoDB,

PARTITION p1992 VALUES LESS THAN (1993) ENGINE = InnoDB,

PARTITION p1993 VALUES LESS THAN (1994) ENGINE = InnoDB,

PARTITION p1994 VALUES LESS THAN (1995) ENGINE = InnoDB,

PARTITION p1995 VALUES LESS THAN (1996) ENGINE = InnoDB,

PARTITION p1996 VALUES LESS THAN (1997) ENGINE = InnoDB,

PARTITION p1997 VALUES LESS THAN (1998) ENGINE = InnoDB,

PARTITION p1998 VALUES LESS THAN (1999) ENGINE = InnoDB,

PARTITION p1999 VALUES LESS THAN (2000) ENGINE = InnoDB,

PARTITION p2000 VALUES LESS THAN (2001) ENGINE = InnoDB,

PARTITION p2001 VALUES LESS THAN (2002) ENGINE = InnoDB,

PARTITION p2002 VALUES LESS THAN (2003) ENGINE = InnoDB,

PARTITION p2003 VALUES LESS THAN (2004) ENGINE = InnoDB,

PARTITION p2004 VALUES LESS THAN (2005) ENGINE = InnoDB,

PARTITION p2005 VALUES LESS THAN (2006) ENGINE = InnoDB,

PARTITION p2006 VALUES LESS THAN (2007) ENGINE = InnoDB,

PARTITION p2007 VALUES LESS THAN (2008) ENGINE = InnoDB,

PARTITION p2008 VALUES LESS THAN (2009) ENGINE = InnoDB,

PARTITION p2009 VALUES LESS THAN (2010) ENGINE = InnoDB,

PARTITION p2010 VALUES LESS THAN (2011) ENGINE = InnoDB,

PARTITION p2011 VALUES LESS THAN (2012) ENGINE = InnoDB,

PARTITION p2012 VALUES LESS THAN (2013) ENGINE = InnoDB,

PARTITION p2013 VALUES LESS THAN (2014) ENGINE = InnoDB,

PARTITION p2014 VALUES LESS THAN (2015) ENGINE = InnoDB,

PARTITION p2015 VALUES LESS THAN (2016) ENGINE = InnoDB,

PARTITION p_new VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */