mysql分区支持的版本有:mysql 5.7,5.6之前版本
使用show plugins查看mysql当前使用的plugin
binlog ACTIVE STORAGE ENGINE GPL mysql_native_password ACTIVE AUTHENTICATION GPL sha256_password ACTIVE AUTHENTICATION GPL CSV ACTIVE STORAGE ENGINE GPL MEMORY ACTIVE STORAGE ENGINE GPL InnoDB ACTIVE STORAGE ENGINE GPL INNODB_TRX ACTIVE INFORMATION SCHEMA GPL INNODB_LOCKS ACTIVE INFORMATION SCHEMA GPL INNODB_LOCK_WAITS ACTIVE INFORMATION SCHEMA GPL INNODB_CMP ACTIVE INFORMATION SCHEMA GPL INNODB_CMP_RESET ACTIVE INFORMATION SCHEMA GPL INNODB_CMPMEM ACTIVE INFORMATION SCHEMA GPL INNODB_CMPMEM_RESET ACTIVE INFORMATION SCHEMA GPL INNODB_CMP_PER_INDEX ACTIVE INFORMATION SCHEMA GPL INNODB_CMP_PER_INDEX_RESET ACTIVE INFORMATION SCHEMA GPL INNODB_BUFFER_PAGE ACTIVE INFORMATION SCHEMA GPL INNODB_BUFFER_PAGE_LRU ACTIVE INFORMATION SCHEMA GPL INNODB_BUFFER_POOL_STATS ACTIVE INFORMATION SCHEMA GPL INNODB_TEMP_TABLE_INFO ACTIVE INFORMATION SCHEMA GPL INNODB_METRICS ACTIVE INFORMATION SCHEMA GPL INNODB_FT_DEFAULT_STOPWORD ACTIVE INFORMATION SCHEMA GPL INNODB_FT_DELETED ACTIVE INFORMATION SCHEMA GPL INNODB_FT_BEING_DELETED ACTIVE INFORMATION SCHEMA GPL INNODB_FT_CONFIG ACTIVE INFORMATION SCHEMA GPL INNODB_FT_INDEX_CACHE ACTIVE INFORMATION SCHEMA GPL INNODB_FT_INDEX_TABLE ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_TABLES ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_TABLESTATS ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_INDEXES ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_COLUMNS ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_FIELDS ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_FOREIGN ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_FOREIGN_COLS ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_TABLESPACES ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_DATAFILES ACTIVE INFORMATION SCHEMA GPL INNODB_SYS_VIRTUAL ACTIVE INFORMATION SCHEMA GPL MyISAM ACTIVE STORAGE ENGINE GPL MRG_MYISAM ACTIVE STORAGE ENGINE GPL PERFORMANCE_SCHEMA ACTIVE STORAGE ENGINE GPL ARCHIVE ACTIVE STORAGE ENGINE GPL BLACKHOLE ACTIVE STORAGE ENGINE GPL FEDERATED DISABLED STORAGE ENGINE GPL partition ACTIVE STORAGE ENGINE GPL ngram ACTIVE FTPARSER GPL
经过查看 发下存在partition,说明当前库支持分区操作