00590f0f1b1b91a318f0d76308bc513a83dc2ad7
chmalee
  Tue May 12 11:26:52 2026 -0700
Move myVariants tables from myisam to innodb, refs #33808

diff --git src/hg/lib/myVariants.c src/hg/lib/myVariants.c
index 7a3e0865d2a..aa6ee4fe96e 100644
--- src/hg/lib/myVariants.c
+++ src/hg/lib/myVariants.c
@@ -535,31 +535,31 @@
             "    strand char(1) not null,\n"
             "    thickStart int unsigned not null,\n"
             "    thickEnd int unsigned not null,\n"
             "    itemRgb int unsigned not null,\n"
             "    description longblob not null,\n"
             "    db varchar(255) not null,\n"
             "    ref varchar(255) not null,\n"
             "    alt varchar(255) not null,\n"
             "    project varchar(255) not null,\n"
             "    mouseover varchar(255) not null,\n"
             "    id int auto_increment,\n"
             "    PRIMARY KEY(id),\n"
             "    INDEX(chrom(16),bin),\n"
             "    INDEX(db),\n"
             "    INDEX(project)\n"
-            ");", db, tableName);
+            ") ENGINE=InnoDB;", db, tableName);
     sqlUpdate(conn, dyStringCannibalize(&createTable));
     return myVariantsGetDbTable(userName);
     }
 } 
 
 
 char *myVariantsWriteCtFile(char *userName, char *targetDb, struct cart *cart)
 /* Write a Custom Track file to trash for user's myVariants in targetDb and any shared
  * tracks found in cart. Return filename or NULL if nothing to write. */
 {
 if (isEmpty(targetDb))
     return NULL;
 
 /* Identifier-safe form of userName for the CT track name and trash filename.
  * The raw userName may contain non-ASCII or characters unsafe in trackDb