Most voted "innodb" questions
Innodb is a storage module or strategy for Mysql. It is currently included as standard in all binaries distributed by Mysql AB.
Learn more…15 questions
Sort by count of
-
37
votes2
answers20576
viewsWhat are the differences between Myisam and Innodb?
What are the main differences between Engines MyISAM and InnoDB and what is the most appropriate situation for the use of each? I know that MyISAM can’t stand it FOREIGN KEY but supports FULLTEXT,…
-
7
votes2
answers1761
viewsExchange impact - Myisam for Innodb
In a medium database (~2GB) Mysql that is all with the Myisam engine. Performing the conversion to Innodb, what will be the impact on my system? I can simply convert by phpMyAdmin, for example?…
-
5
votes4
answers4278
viewsMysql performance with Innodb in large data mass table
I currently have a table with about 6 million records that in turn perform a large amount of I/O operations, so in the design of the project I chose to use the Innodb instead of Myisam in Mysql,…
-
5
votes3
answers2269
viewsWhat is the most efficient way to select items from a table?
Having the following table: | id | name | email | coutry | +----+------+-------+--------+ What shape more efficient (faster) to select ALL the rows of the table knowing that the table may have 1 row…
-
4
votes2
answers1688
views1005 - Can’t create table '' Rrno: 150
I’m starting my programming journey and came across a mistake in the creation of the Mysql database: 1005 - Can’t create table 'mydb.supplier' (Rrno: 150) What could it be? I’ve entered several…
-
4
votes2
answers174
viewsHow to send queries simultaneously to test Transactions efficiency in Mysql?
I have a table Innodb in Mysql where I store a user’s account balance. To give a UPDATE on the balance I use Transactions to prevent two or more queries from trying to give UPDATE simultaneously and…
-
3
votes2
answers385
viewsInnodb and Myisam generating Table already exists error
I am reformulating some screens of my system that, entirely, uses Myisam as Mysql Engine. In this case, these screens will use Innodb after reformulation. Excludes, by Phpmyadmin, all tables Myisam…
-
3
votes1
answer3038
viewsForeign key creation error in Mariadb
When trying to create the toy table, the following error appears: ERROR 1005 (HY000): Can’t create table brinquedos.brinquedo (Rrno: 150 "Foreign key Constraint is incorrectly Formed") Follows the…
-
2
votes2
answers224
viewsCondition for INSERT INTO
I need SQL to check that in the '@variable' sent there is a value equal to 1, 2 or 3; If true enter the value 1, otherwise enter the value 0. Note: the table and column can be given as examples as…
-
2
votes0
answers182
viewsEngine with lower RAM consumption than Innodb/Xtradb in Mariadb?
Innodb allows you to make several INSERT and also UPDATE without creating LOCKING, while in Myisam it is not possible to make several INSERT at the same time and to make matters worse Myisam does…
-
2
votes1
answer107
viewsRollback method does not work in mysqli extended class
Hello, Because of the PHP version on the server, the fetch all and begin_transaction methods of mysqli do not work. To solve this, I created another connection class extending the Mysqli class and…
-
2
votes1
answer80
viewsHow to replace COUNT(*) in innoDB
I migrated data from a bank Myisam for Innodb and some VIEW were extremely slow (on average 15x slower), after much research found that answer from @Maniero and in it he makes a comparison between…
-
0
votes1
answer108
viewsDouble INSERT no stored
Currently what I have is basically this: CREATE PROCEDURE `Teste`( IN `@valorX` INT, IN `@valorY` INT ) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER INSERT INTO tabelaX(colunaX) VALUES…
-
0
votes0
answers183
viewsDifferent results for Mysql 5.1 and 5.7 query
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 had version 5.7.4. After publishing the project, we started to check…
-
0
votes1
answer29
viewsTanning system with Stored Procedure
I’m trying to make a stored Precedent for a simple likes system, my table is organized like this: Likes id INT(11) - Auto Increment post INT(11) - foreign key (id - post) user INT(11) - foreign key…