This might be because of the engine I use in mysql - InnoDB.