mysql innodb 安装,配置

来源：互联网发布：bp算法推导编辑：程序博客网时间：2024/05/22 19:57

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"