Greetings, I'm not sure if I'm doing something particularly stupid, but I'm having difficulty using InnoDB (the XtraDB version) with MariaDB v.10.0.10. The engine shows as disabled in my configuration for reasons I'm unclear on. I'm using a mirror of the apt repository (from http://mariadb.org/mariadb/repositories/) on Ubuntu 14.04 server, running on x86_64. The currently installed version is 10.0.10+maria-1~trusty . My configuration includes changing the default table type: # defaults to innodb default_storage_engine = aria That works as expected. However, when I create a table specifying `ENGINE=InnoDB`, the table is actually created as an Aria table, and a warning is logged:
show warnings; +---------+------+---------------------------------+ | Level | Code | Message | +---------+------+---------------------------------+ | Warning | 1286 | Unknown storage engine 'InnoDB' | +---------+------+---------------------------------+
Sure enough, the InnoDB engine shows as not supported:
show engines; [...] | InnoDB | NO | Percona-XtraDB, Supports transactions.... |
I haven't done anything specifically to disable XtraDB/InnoDB support. Looking through the documentation, knowledge basse, and mailing list archives hasn't turned up anything related. The only thing I found was this, in the documentation for the ignore_builtin_innodb variable: ignore_builtin_innodb Description: In older versions of MariaDB, setting this to 1 resulted in the built in InnoDB storage engine to be ignored. In MariaDB 5.5, InnoDB is the default and is always present, so this variable is ignored and setting it results in a warning. In MariaDB 10.0.x, this variable currently needs to be set. I'm not sure exactly what it means by saying it "needs to be set" with this version of MariaDB (doc bug?). If I add `ignore_builtin_innodb = 1` to my configuration, then the server refuses to start, complaining about unrecognized configuration options in the config, basically anything to do with innodb (innodb_file_per_table, innodb_checksum_algorithm, etc). Am I missing something? Is there a way to use Aria as the default table type while still allowing the use of XtraDB-provided InnoDB tables as well? Any assistance appreciated. Thanks, Charles -- ------------------------------------------------------------------ Charles Cazabon <charlesc-web-register-launchpad.net@pyropus.ca> Software, consulting, and services available at http://pyropus.ca/ ------------------------------------------------------------------