mysql innodb 安装,配置

1、查看一下，mysql配置是不是支持动态添加插件

show variables like "have_%";

2、 添加插件

1.mysql> INSTALL PLUGIN INNODB SONAME 'ha_innodb.so';    //提示打不开文件，没有权限   
2.ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_innodb.so' (errno: 13 cannot restore segment prot after reloc: Permission denied)

上面报没有权限错误，解决办法如下：

1.root@ubuntu:/usr/local/mysql# find . -type d -print |grep -i plugin   //查看一下插件目录对不对   
2../lib/mysql/plugin   
3.root@ubuntu:/usr/local/mysql# chcon -t texrel_shlib_t /usr/local/mysql/lib/mysql/plugin/ha_innodb.so   
4.chcon: 部分关联无法应用于文件“/usr/local/mysql/lib/mysql/plugin/ha_innodb.so” 

mysql> install plugin INNODB soname "ha_innodb.so";
mysql> install plugin INNODB_TRX soname "ha_innodb.so";
mysql> install plugin INNODB_LOCKS soname "ha_innodb.so";
mysql> install plugin INNODB_LOCK_WAITS soname "ha_innodb.so";
mysql> install plugin INNODB_CMP soname "ha_innodb.so";
mysql> install plugin INNODB_CMP_RESET soname "ha_innodb.so";
mysql> install plugin INNODB_CMPMEM soname "ha_innodb.so";
mysql> install plugin INNODB_CMPMEM_RESET soname "ha_innodb.so"