with InnoDB, need an explicit commit() after the command has run