1.可以用 show engines;或者show plugins;来查看
mysql> show plugins; +----------------------------+--------+--------------------+----------------------+---------+ | Name | Status | Type | Library | License | +----------------------------+--------+--------------------+----------------------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL | | sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | 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 |2.查看一下，mysql配置是不是支持动态添加插件
mysql> show variables like "have_%"; +------------------------+----------+ | Variable_name | Value | +------------------------+----------+ | have_compress | YES | | have_crypt | YES | | have_dynamic_loading | YES | | have_geometry | YES | | have_openssl | YES | | have_profiling | YES | | have_query_cache | YES | | have_rtree_keys | YES | | have_ssl | YES | | have_statement_timeout | YES | | have_symlink | DISABLED | +------------------------+----------+ 11 rows in set (0.00 sec)| have_dynamic_loading | YES | //在这里是YES表示是支持的
如果是no呢，就不太好办，因为have_dynamic_loading是只读变量，
3.添加插件
mysql> INSTALL PLUGIN INNODB SONAME 'ha_innodb.so';
转载于:https://www.cnblogs.com/comeping/p/9315306.html
