Comments - MariaDB 10.0.7 Release Notes

10 years, 2 months ago George L

Having strange issues with trying to enable XtraDB engine in 10.0.7 on CentOS if i install it and set ignore_builtin_innodb in my.cnf will result in MariaDB server not starting up as it complains that alot of innodb_* variables are unknown. i.e.

140205 19:53:49 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.localdomain.pid ended
140205 19:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140205 19:54:37 [Note] Plugin 'FEEDBACK' is disabled.
140205 19:54:37 [ERROR] Unknown/unsupported storage engine: InnoDB
140205 19:54:37 [ERROR] Aborting

From docs it says it shouldn't be set anymore https://mariadb.com/kb/en/xtradbinnodb-server-system-variables/#ignore_builtin_innodb ? But if I do not set ignore_builtin_innodb, then even with XtraDB plugins installed, I don't see any different variables pertaining to XtraDB specifically, it's same as before XtraDB was installed.

mysql -e "SELECT * FROM mysql.plugin;"
+-----------------------------+------------------------+
| name                        | dl                     |
+-----------------------------+------------------------+
| METADATA_LOCK_INFO          | metadata_lock_info.so  |
| QUERY_CACHE_INFO            | query_cache_info.so    |
| QUERY_RESPONSE_TIME         | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT   | query_response_time.so |
| XTRADB_READ_VIEW            | ha_xtradb.so           |
| XTRADB_INTERNAL_HASH_TABLES | ha_xtradb.so           |
| XTRADB_RSEG                 | ha_xtradb.so           |
| INNODB_CHANGED_PAGES        | ha_xtradb.so           |
+-----------------------------+------------------------+

with XtraDB installed and blank my.cnf - variables outputted

pastebin output at http://pastebin.com/q4v4Mz7p

 
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.