Questions tagged as 'innodb'

InnoDB allows you to make multiple INSERT and also UPDATE without creating LOCKING , while in MyISAM it is not possible to make multiple INSERTs at the same time and to make matters worse MyISAM does not support TRANSACTIO...

I'm trying to make a stored procedure for a simple tanned system, my table is organized like this: Tanned id INT (11) - Auto Increment post INT (11) - foreign key (id - post) user INT (11) - foreign key (id - users) Users...

Currently what I basically have is this: CREATE PROCEDURE 'Teste'( IN '@valorX' INT, IN '@valorY' INT ) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER INSERT INTO tabelaX(colunaX) VALUES (@valorX) INSERT INTO tabelaY(colunaY) VA...

Well, my mysql gave a problem before the daily backup. Would you solve it? 180629 17:14:08 [Note] 'FEDERATED' plugin is disabled. InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on InnoDB: Skipping log redo 180629 17:14:08 InnoDB: Error: space...

I use DB_Designer 4.0.5.6 Beta. I discovered a problem when I was generating an sql code to build my database. The last line that appears in the sql code is the "TYPE = InnoDB;" CREATE TABLE cliente ( idCliente INT NOT NULL AUTO_INCREMENT,...

We developed a project for a client using MySQL 5.1.68 and at the time of publication we identified that the client's hosting was version 5.7.4. Once the project has been published, we begin to see some strange behaviors in the results return...