Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to test the performance with it.

In my.ini I put under [mysqld] the following:

ignore_builtin_innodb
plugin-load=innodb=ha_innodb.dll

The plugin is located in BASEDIR/lib/plugin.

But when I start the service I get the following in the error log:

140315 18:03:04 [Note] Plugin 'FEEDBACK' is disabled.
140315 18:03:04 [ERROR] Plugin 'InnoDB' init function returned error.
140315 18:03:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140315 18:03:04 [ERROR] Unknown/unsupported storage engine: InnoDB
140315 18:03:04 [ERROR] Aborting

If I comment both lines out then everything runs fine.

Even when I try to run a plain MariaDB data dir (without the log files ...) the error occurs.

Is there someone who have a hint for me?

share|improve this question

1 Answer 1

The method of using 'innodb_plugin' instead of default InnoDB is a MySQL 5.1 feature. The InnoDB plugin of 5.1 is the default of MySQL 5.5, and thus, in MySQL 5.5 we see this information for the 'ignore_builtin_innodb':

In MySQL 5.1, this option caused the server to behave as if the built-in InnoDB were not present, which enabled InnoDB Plugin to be used instead. In MySQL 5.5, InnoDB is the default storage engine and InnoDB Plugin is not used, so this option has no effect. As of MySQL 5.5.22, it is deprecated and its use results in a warning.

This would be true for MariaDB 5.5 as well.

share|improve this answer
    
Thank you for your answer. –  user212901 Mar 16 at 6:25
    
But what do i have to do in order to activate the innodb plugin ha_innodb.dll ? –  user212901 Mar 16 at 6:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.