In MySQL 5.7.2 a new include file “–source
include/force_myisam_default.inc“ made its appearance in most of
the .test files in the MTR suite. If you were wondering about
this read on.
I will explain this change in two blogs. The first will describe
why we are doing this and the next will explain how it is being
In order to set the context let me delve a bit into history.
Starting from MySQL 5.5, the default storage engine for new
tables is InnoDB. This change was coupled with a reverse switch
in mysql-test-run, which made MyISAM the default storage engine
for the server started through MTR(mysql-test-run). As a result
default storage engine in the server was innodb, but most tests
were run with the old default MyISAM.
Let me explain why such a switch was required. The usual practice
in MTR test development was to not specify an engine in create
table statement, unless the test is specifically for a …[Read more]