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

**URL:** <https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442>\
**Category:** Other MySQL® Questions\
**Created:** [June 28, 2010, 5:11am UTC](https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442 "2010-06-28T05:11:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![massoo](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/massoo/32/769_2.png) [@massoo](https://forums.percona.com/u/massoo)\
**Post date:** [June 28, 2010, 5:11am UTC](https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442/1 "2010-06-28T05:11:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![massoo](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/massoo/32/769_2.png) [@massoo](https://forums.percona.com/u/massoo)\
**Post date:** [June 29, 2010, 2:41am UTC](https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442/2 "2010-06-29T02:41:13Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![creax](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@creax](https://forums.percona.com/u/creax)\
**Post date:** [July 1, 2010, 6:49am UTC](https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442/3 "2010-07-01T06:49:43Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [July 3, 2010, 2:15am UTC](https://forums.percona.com/t/how-to-use-percona-xtradb-1-0-6-10-5-1-45-10/1442/4 "2010-07-03T02:15:04Z")

</div>

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