Re: how to make MyISAM as default engine for MySQL 5.6.4?

2011-12-24 Thread Suresh Kuna
Hi,

Try the 3 options available in the below URL option, i.e ignore built in
innodb and set the default storage engine to another storage engine.
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb

Thanks
Suresh Kuna
MySQL DBA

2011/12/24 Sharl.Jimh.Tsin amoiz.sh...@gmail.com

 hello,all:
 today,i download the latest source tarball of MySQL 5.6.x branch,and
 build it from source for myself.
 first,i configure it with WITH_INNOBASE_STORAGE_ENGINE:BOOL=OFF
 flag,after that,i start mysqld failed,it returns [ERROR]
 Unknown/unsupported storage engine: InnoDB error message.

 and i rebuild it with INNODB engine enabled,it works.but when i add
 |ignore-builtin-innodb| option to my.cnf file,and also make myisam as
 the default engine with default-storage-engine=MyISAM in my.cnf.the
 server start failed again,error is [ERROR] Unknown/unsupported storage
 engine: InnoDB.

 so,i just want to know that how to disable INNODB fully in 5.6.4,and
 make myisam default?

 any reply is wanted!! thanks~

 --
 Best regards,
 Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)

 Using Gmail? Please read this important notice:
 http://www.fsf.org/campaigns/jstrap/gmail?10073.




-- 
Thanks
Suresh Kuna
MySQL DBA


Re: how to make MyISAM as default engine for MySQL 5.6.4?

2011-12-24 Thread Sharl.Jimh.Tsin

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

? 2011?12?25? 01:04, Suresh Kuna ??:
 Hi,

 Try the 3 options available in the below URL option, i.e ignore built in
 innodb and set the default storage engine to another storage engine.
 http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb

 Thanks
 Suresh Kuna
 MySQL DBA

 2011/12/24 Sharl.Jimh.Tsin amoiz.sh...@gmail.com

 hello,all:
 today,i download the latest source tarball of MySQL 5.6.x branch,and
 build it from source for myself.
 first,i configure it with WITH_INNOBASE_STORAGE_ENGINE:BOOL=OFF
 flag,after that,i start mysqld failed,it returns [ERROR]
 Unknown/unsupported storage engine: InnoDB error message.

 and i rebuild it with INNODB engine enabled,it works.but when i add
 |ignore-builtin-innodb| option to my.cnf file,and also make myisam as
 the default engine with default-storage-engine=MyISAM in my.cnf.the
 server start failed again,error is [ERROR] Unknown/unsupported storage
 engine: InnoDB.

 so,i just want to know that how to disable INNODB fully in 5.6.4,and
 make myisam default?

 any reply is wanted!! thanks~

 --
 Best regards,
 Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)

 Using Gmail? Please read this important notice:
 http://www.fsf.org/campaigns/jstrap/gmail?10073.




yes,as the doc said:
As of MySQL 5.6.3, this option sets the storage engine for permanent
tables only. To set the storage engine for TEMPORARY tables, set the
default_tmp_storage_engine system variable.

i also need to set default engine for TEMP tables by
default_tmp_storage_engine option,then it works,thanks a lot.

- -- 
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)

Using Gmail? Please read this important notice:
http://www.fsf.org/campaigns/jstrap/gmail?10073.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJO9gkWAAoJEEYmNy4jisTjOVcH/jOwnMlQ/Q7TYMVMyZn0yzzG
8UPrBbWXnwr5Rm3NfP6hEyLpkDHzyf0WxxHPjwkQMcN3xq/KBSdiZ54vy4jVrnml
gJ2yJ0Uf76u2Xwhqzcno1mKjON7ByGBoIteeAW0hh7ikEfnwGUhPbh63YZzIsAnp
FGXvmUTWmdDNI6SChp56HiiH+EavUJ7El/4dvyu/AwqInsSf4hYmsQQRAM9Zr5aw
w4QHLLXPyLphEhMb71DYwt63Meo4xXvaUGMVYQsE8JKfsAZgMn4PDVyWmUCaA/CO
teUILOrDgmfM0m/n2uywu+uQW8DYVDoEwNdxduEpiyFoHRbebha74LV7XUWdW1M=
=aOuj
-END PGP SIGNATURE-