Comments - About XtraDB

13 years ago Robert Heerdink

How do I activate XtraDB to replace InnoDB? I have searched this website and Percona and have not found this question or answer. I have a clean, rpm install on openSuse 11.3 (x86_64) of mariadb-5.1.51-8.1.x86_64. I copied over /etc/my.cnf which works with MySQL 5.1.43sp1. It has several options like innodb_file_per_table under section [mysqld], yet when I try to run "mysql_install_db --user=mysql", I get errors for every InnoDB option like: [ERROR] /usr/sbin/mysqld: unknown option '--innodb_file_per_table'

 
11 years, 7 months ago Michael Widenius

mysql_install_db disables innodb (xtradb) when installing system tables.

The easiest way to get rid of the warnings is to prefix the innodb options with 'loose-'. This will allow mysqld to start even if innodb is not enabled.

The other option is to use mysql_install_db with the --no-defaults option.

 
13 years ago Sergei Golubchik

mysql_install_db disables innodb (xtradb) when installing system tables.

You can simply comment out innodb-specific options, run mysql_install_db and uncomment them back.

Or you can run mysql_install_db with --no-defaults.

Perhaps, if you would've copied over your my.cnf after running mysql_install_db you would've never had this problem at all.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.