Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.2
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:linux - mariadb binary file downloaded from mariadb website
Description
hi guys, this option at mariadb 10.0.1 in my.cnf file:
"ignore_builtin_innodb"
result in no database startup...
maybe innodb is mandatory (why?)
check the log file:
# cat local.error.log 130307 02:45:20 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data/local/ 130307 2:45:20 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 130307 2:45:20 [Warning] An old style --language or -lc-message-dir value with language specific part detected: /usr/share/mysql/portuguese/ 130307 2:45:20 [Warning] Use --lc-messages-dir without language specific part instead. 130307 2:45:20 [Note] Plugin 'FEEDBACK' is disabled. 130307 2:45:20 [ERROR] Unknown/unsupported storage engine: InnoDB 130307 2:45:20 [ERROR] Aborting 130307 2:45:20 [Note] /usr/local/mysql/bin/mysqld: 'Shutdown' completo 130307 02:45:20 mysqld_safe mysqld from pid file /home/mysql/pid/local.pid ended
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
could it be automatic?
if skip is enabled, default table = myisam?
it's a bit more complex. what if a user has explicitly specified --default-storage-engine=innodb ? in this case we should not automatically change it to myisam. So we'd need to track whether the value is default or it was specified by the user.
Currently it's automatic in a sense that if innodb is compiled in - then innodb is a default. If innodb is not compiled in - then myisam is a default.
InnoDB is not mandatory (mandatory engines are impossible to disable, for example, there is no --skip-myisam option). But starting from MySQL-5.6 and MariaDB-10.0 InnoDB is the default storage engine. That's why the server refuses to start, it cannot resolve the name of the default storage engine.
If you want to disable InnoDB, you need to change the default storage engine too, use the --option default-storage-engine=MyISAM