Percona是MySQL Performance Blog的几位作者联手在MySQL基础上打造的一个MySQL版本,其中xtradb是基于innodb plugin,其中主要的更新就是对于SSD方面进行了一些优化,使得在SSD上比MySQL效率会更高一些。
因为Percona从代码底层进行了改动,所以整体而言不同于MySQL5.1.50+Innodb plugin,本来以为都是基于这两个做的,结果就按照MySQL5.1.50+Innodb plugin的配置文件来配置Percona,结果遇到了很多”乱七八糟”的问题。最终的结论就是去掉MySQL5.1.50+Innodb plugin专门添加的选项就ok了。
遇到的问题以及解决方法公布出来(Percona选项的差异性在做进一步调查):
Percona 5.1.50安装方法
warning: Percona-Server-client-51-5.1.50-rel11.4.111.rhel5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID cd2efd2a
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by Percona-Server-client-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by Percona-Server-client-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient_r.so.16()(64bit) is needed by Percona-Server-client-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by Percona-Server-client-51-5.1.50-rel11.4.111.rhel5.x86_64
warning: Percona-Server-server-51-5.1.50-rel11.4.111.rhel5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID cd2efd2a
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by Percona-Server-server-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by Percona-Server-server-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient_r.so.16()(64bit) is needed by Percona-Server-server-51-5.1.50-rel11.4.111.rhel5.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by Percona-Server-server-51-5.1.50-rel11.4.111.rhel5.x86_64
上面这个通过安装Percona-Server-shared-51-5.1.50-rel11.4.111.rhel5.x86_64.rpm得到解决
但是依旧没有启动,查看error
100928 11:50:16 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/ha_innodb_plugin.so' (errno: 0 cannot open shared object file: No such file or directory)
100928 11:50:16 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
删除选项:
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;inno
db_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
100928 11:50:16 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_file_format=Barracuda'
删除选项innodb_file_format=Barracuda
100928 11:55:36 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_strict_mode=1'
删除选项innodb_strict_mode=1
100929 10:45:52 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_data_home_dir=/data/ibdata'
删除选项ignore_builtin_innodb