sample about setting default storage engine

Default storage engine is InnoDB since 5.5.5, this can be reverted by
setting in config:

default-storage-engine=MyISAM

diff --git a/mysqld.conf b/mysqld.conf
index b83fd3f3c0f330acbec174da441b83aad9b79181..73fd012c506950072cdb1fd34d95729102471335 100644 (file)
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -32,6 +32,10 @@ skip-external-locking
 # Disabling symbolic-links is recommended to prevent assorted security risks
 symbolic-links=0
 
+# Default storage engine is InnoDB since 5.5.5
+# You may revert to previous behaviour by specifiying MyISAM here
+#default-storage-engine=InnoDB
+
 # Don't listen on a TCP/IP port at all. This is a security enhancement,
 # if all processes that need to connect to mysqld run on the same host.
 # All interaction with mysqld must be made via Unix sockets.