How To Use Percona-XtraDB-1.0.6-10-5.1.45-10 ?

MySQL & MariaDB Other MySQL® Questions
1

Hi,

I have installed

Percona-Server-shared-compat-5.1.43-3.x86_64.rpm
Percona-XtraDB-1.0.6-10-5.1.45-10.rhel5.x86_64.rpm
Percona-XtraDB-51-5.1.45-10.rhel5.src.rpm
Percona-XtraDB-client-51-5.1.45-10.rhel5.x86_64.rpm
Percona-XtraDB-devel-51-5.1.45-10.rhel5.x86_64.rpm
Percona-XtraDB-server-51-5.1.45-10.rhel5.x86_64.rpm
Percona-XtraDB-shared-51-5.1.45-10.rhel5.x86_64.rpm
Percona-XtraDB-test-51-5.1.45-10.rhel5.x86_64.rpm

on my CentOS 5.5 64bit server. Do I need to make any changes in /etc/my.cnf to avail the benefits of XtraDB Plugin?

For instance, the FAQ mentions that the install process is the same as that for innodb plugin. So by referring to the innodb plugin installation manual, I need to enter the following in my.cnf

ignore_builtin_innodbplugin-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;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.soinnodb_file_per_table=1innodb_file_format=barracudainnodb_strict_mode=1default_storage_engine=MyISAM

Am I right ?

Regards
Shann

2

these 2 options do not work
ignore_builtin_innodbplugin-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;innodb_cmp_reset=ha_innodb_plugin.so; innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so

and the listing of
ls -alh /usr/lib64/mysql/plugin/total 6.5Mdrwxr-xr-x 2 root root 4.0K Jun 17 17:17 .drwxr-xr-x 3 root root 4.0K Jun 29 11:44 …lrwxrwxrwx 1 root root 18 Jun 17 17:17 ha_innodb.so → ha_innodb.so.0.0.0lrwxrwxrwx 1 root root 18 Jun 17 17:17 ha_innodb.so.0 → ha_innodb.so.0.0.0-rw-r–r-- 1 root root 6.5M May 23 18:35 ha_innodb.so.0.0.0-rw-r–r-- 1 root root 966 May 23 18:20 install_innodb_plugins.sql

and the results of running
mysql> source /usr/lib64/mysql/plugin/install_innodb_plugins.sql;ERROR 1125 (HY000): Function ‘innodb’ already existsERROR 1125 (HY000): Function ‘innodb_trx’ already existsERROR 1125 (HY000): Function ‘innodb_locks’ already existsERROR 1125 (HY000): Function ‘innodb_lock_waits’ already existsERROR 1125 (HY000): Function ‘innodb_cmp’ already existsERROR 1125 (HY000): Function ‘innodb_cmp_reset’ already existsERROR 1125 (HY000): Function ‘innodb_cmpmem’ already existsERROR 1125 (HY000): Function ‘innodb_cmpmem_reset’ already existsERROR 1125 (HY000): Function ‘XTRADB_ENHANCEMENTS’ already existsERROR 1125 (HY000): Function ‘INNODB_BUFFER_POOL_PAGES’ already existsERROR 1125 (HY000): Function ‘INNODB_BUFFER_POOL_PAGES_BLOB’ already existsERROR 1125 (HY000): Function ‘INNODB_BUFFER_POOL_PAGES_INDEX’ already existsERROR 1125 (HY000): Function ‘innodb_rseg’ already existsERROR 1125 (HY000): Function ‘innodb_table_stats’ already existsERROR 1125 (HY000): Function ‘innodb_index_stats’ already existsERROR 1125 (HY000): Function ‘xtradb_admin_command’ already exists

How do I know that the XtraDB is active or not? Can someone help me please?

3

Did you get any further on this?
I have the same doubt whether or not XtraDB is installed.
Any help would be deeply appreciated

4

What does your SHOW ENGINES; SHOW VARIABLES LIKE 'innodb_%'; look like?