Bug #67135 | Embedded server does not start with MyISAM as default storage engine | ||
---|---|---|---|
Submitted: | 8 Oct 2012 17:44 | Modified: | 1 Nov 2012 16:09 |
Reporter: | Carlos Quiros | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Embedded Library ( libmysqld ) | Severity: | S3 (Non-critical) |
Version: | 5.5.27 | OS: | Linux (Slackware 14) |
Assigned to: | CPU Architecture: | Any | |
Tags: | DEFAULT, engine, libmysqld, myisam, storage |
[8 Oct 2012 17:44]
Carlos Quiros
[10 Oct 2012 18:19]
Carlos Quiros
I tested the following server_options in 5.1.66 and 5.5.27: static char *server_options[] = \ { (char *)"mysql_test", (char *)"--datadir=./db", (char *)"--basedir=./db", (char *)"--default-storage-engine=MyISAM", (char *)"--loose-innodb=0", (char *)"--skip-grant-tables=1", (char *)"--myisam-recover=FORCE", (char *)"--key_buffer_size=16777216", (char *)"--character-set-server=utf8", (char *)"--collation-server=utf8_bin", NULL }; libmysqld 5.1.66 is able to start however 5.5.27 is not. What else is needed in 5.5.x to start the embedded server an override InnoDB?
[12 Oct 2012 17:55]
Sveta Smirnova
Thank you for the report. Looks like your program reads default file somewhere. Please try to add option --no-defaults to option list (note, this option must be first) or explicitly specify which server groups it should read, using solution from http://dev.mysql.com/doc/refman/5.5/en/mysql-library-init.html (search for static char *server_groups[] = {) Let us know if it works.
[13 Oct 2012 12:30]
Carlos Quiros
Hi, I tried your recommendation (--no-defaults as the first option) but I got the same result, however I tried something else.... It turns out that this happens because of changes in the share folder directory. My application supply the share folder from Mysql 5.1.x however its contents have changed substantially from 5.1.66 to 5.5.27. If I replace the contents of share with the newest version the embedded server 5.5.27 starts properly. Without the share folder 5.1.66 nor 5.5.27 will start. Is this an expected behavior? Thanks Carlos.
[1 Nov 2012 16:09]
Sveta Smirnova
Thank you for the feedback. Yes, this is expected behavior: share folder contains files necessary for MySQL Server to run.