Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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_inno db_plugin.so;innodb_locks=ha_innodb_plugin.so;inno db_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_in nodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.s o;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_ reset=ha_innodb_plugin.soinnodb_file_per_table=1in nodb_file_format=barracudainnodb_strict_mode=1defa ult_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_inno db_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_re set=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?

    Comment


    • #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

      Comment


      • #4
        What does your `SHOW ENGINES; SHOW VARIABLES LIKE 'innodb_%';` look like?
        Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

        Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

        Comment


        • #5
          Look at the following:

          SELECT @@VERSION, @@VERSION_COMMENT;

          You should see clearly whether you're using Percona Server. And XtraDB is built-in and does not need to be enabled as a plugin.

          Comment


          • #6
            mysql> SELECT @@VERSION, @@VERSION_COMMENT;
            +----------------+------------------------------------------ --+
            | @@VERSION | @@VERSION_COMMENT |
            +----------------+------------------------------------------ --+
            | 5.1.47-rel11.1 | (Percona Server (GPL), 11.1 , Revision 51) |
            +----------------+------------------------------------------ --+

            So I guess that everything is installed correctly-- thanks!

            Also the SHOW VARIABLES LIKE 'innodb_%'; command now returns the right info.

            At one point I got the following error:
            "ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined".
            Something to do with the innodb log files; I found the solution here: http://www.xaprb.com/blog/2007/03/08/what-to-do-when-mysql-s ays-skip-innodb-is-defined/

            Cheers!

            Comment

            Working...
            X