mysql innodb插件_mysql 安装 innodb 插件

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';