   ;
 
   drop temporary table if exists _split_candidate_keys_recommended;
-  create temporary table _split_candidate_keys_recommended
+  create temporary table _split_candidate_keys_recommended engine=MyISAM
     SELECT
       *
     FROM 

  ;
  
  drop temporary table if exists _split_candidate_keys;
  create temporary table _split_candidate_keys
   SELECT
      TABLE_SCHEMA,
      TABLE_NAME,

          WHEN 'double' THEN 8
          WHEN 'decimal' THEN CEILING(NUMERIC_PRECISION/2)
          WHEN 'bit' THEN CEILING(NUMERIC_PRECISION/8)
          WHEN 'set' THEN 8
          WHEN 'enum' THEN 8
          WHEN 'year' THEN 2
          WHEN 'char' THEN CHARACTER_OCTET_LENGTH
