• Magne Mahre's avatar
    WL#5349 Change default storage engine to InnoDB · 6884c955
    Magne Mahre authored
    The default storage engine is changed from MyISAM to
    InnoDB, in all builds except for the embedded server.
    
    In addition, the following system variables are 
    changed:
    
      * innodb_file_per_table is enabled
      * innodb_strict_mode is enabled
      * innodb_file_format_name_update is changed
        to 'Barracuda'
    
    The test suite is changed so that tests that do not
    explicitly include the have_innodb.inc are run with
    --default-storage-engine=MyISAM.  This is to ease the
    transition, so that most regression tests are run
    with the same engine as before.
    
    Some tests are disabled for the embedded server
    regression test, as the output of certain statements
    will be different that for the regular server
    (i.e SELECT @@default_storage_engine).  This is to
    ease transition.
    
    
    
    mysql-test/mysql-test-run.pl:
      The regression test suite now adds a
      --default-storage-engine=MyISAM for all non-innodb 
      tests.  This behaviour can be controlled by the
      default-myisam switch in mysql-test-run
    mysql-test/t/bootstrap-master.opt:
      The bootstrap test can only be run without InnoDB
      as it starts several mysqld instances on the same
      datadir. This is possible with MyISAM, but not
      with InnoDB.
    storage/innobase/CMakeLists.txt:
      Build InnoDB per default
    storage/innobase/handler/ha_innodb.cc:
      Change default values for system variables
      
        Enable file_per_table
        Enable strict_mode
        Upgrade default file format to Barracuda
    6884c955
bug46760.test 970 Bytes