Nov 1, 2018

How to check whether your MySQL Server supports partitioning

SELECT 
    PLUGIN_NAME as Name,
    PLUGIN_VERSION as Version,
    PLUGIN_STATUS as Status
FROM
    INFORMATION_SCHEMA.PLUGINS
WHERE
    PLUGIN_TYPE = 'STORAGE ENGINE';

Output:

NameVersionStatus
binlog1.0ACTIVE
MRG_MYISAM1.0ACTIVE
CSV1.0ACTIVE
MEMORY1.0ACTIVE
MyISAM1.0ACTIVE
BLACKHOLE1.0ACTIVE
ARCHIVE3.0ACTIVE
InnoDB5.6ACTIVE
FEDERATED1.0DISABLED
PERFORMANCE_SCHEMA0.1ACTIVE
partition1.0ACTIVE

Or
mysql> SHOW PLUGINS;

Name Status Type Library License
binlog ACTIVE STORAGE ENGINE NULL GPL
mysql_native_password ACTIVE AUTHENTICATION NULL GPL
mysql_old_password ACTIVE AUTHENTICATION NULL GPL
sha256_password ACTIVE AUTHENTICATION NULL GPL
MRG_MYISAM ACTIVE STORAGE ENGINE NULL GPL
CSV ACTIVE STORAGE ENGINE NULL GPL
MEMORY ACTIVE STORAGE ENGINE NULL GPL
MyISAM ACTIVE STORAGE ENGINE NULL GPL
BLACKHOLE ACTIVE STORAGE ENGINE NULL GPL
ARCHIVE ACTIVE STORAGE ENGINE NULL GPL
InnoDB ACTIVE STORAGE ENGINE NULL GPL
INNODB_TRX ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_LOCKS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_LOCK_WAITS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMP ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMP_RESET ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMPMEM ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMPMEM_RESET ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMP_PER_INDEX ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_CMP_PER_INDEX_RESET ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_BUFFER_PAGE ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_BUFFER_PAGE_LRU ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_BUFFER_POOL_STATS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_METRICS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_DEFAULT_STOPWORD ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_DELETED ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_BEING_DELETED ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_CONFIG ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_INDEX_CACHE ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_FT_INDEX_TABLE ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_TABLES ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_TABLESTATS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_INDEXES ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_COLUMNS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_FIELDS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_FOREIGN ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_FOREIGN_COLS ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_TABLESPACES ACTIVE INFORMATION SCHEMA NULL GPL
INNODB_SYS_DATAFILES ACTIVE INFORMATION SCHEMA NULL GPL
FEDERATED DISABLED STORAGE ENGINE NULL GPL
PERFORMANCE_SCHEMA ACTIVE STORAGE ENGINE NULL GPL
partition ACTIVE STORAGE ENGINE NULL GPL