Questions tagged as 'innodb'

Tagged questions
2
answers

What 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 each? I know that MyISAM does not support FOREIGN KEY but supports FULLTEXT , while InnoDB...
asked by 24.11.2014 / 20:15
2
answers

Impact of exchange - MyISAM by InnoDB

In a medium database (~ 2GB) MySQL that is all with the MyISAM engine. Realizing the conversion to InnoDB, what will be the impact on my system? Can I simply convert by phpMyAdmin, for example? Has anyone ever had this experience?     
asked by 17.02.2014 / 18:44
4
answers

Perfomance in MySQL with InnoDB in large data table

I currently have a table with about 6 million records that in turn perform a lot of I / O operations, so in designing the project I chose to use InnoDB instead of MyISAM in MySQL, after all, lock would be per page, not per table. But I ha...
asked by 29.01.2014 / 23:31
2
answers

1005 - Can not create table '' errno: 150

I'm starting my journey in programming and I came across a mistake in creating the MySQL database:    1005 - Can not create table 'mydb.provider' (errno: 150) What will it be? I have already logged into several forums but this same error...
asked by 04.02.2014 / 20:59
2
answers

How to send queries simultaneously to test the efficiency of Transactions in MySQL?

I have an InnoDB table in MySQL where I store a user's account balance. To give a% of the balance I use Transactions to prevent two or more queries from attempting to give UPDATE simultaneously and end up corrupting the balance amount...
asked by 06.07.2015 / 10:07
2
answers

InnoDB and MyISAM generating Table already exists error

I'm reshaping some screens of my system that entirely uses MyISAM as the MySQL Engine. In this case, these screens will use InnoDB post reformulation. Exclude, by PHPMyAdmin, all the MyISAM tables in question and hitherto perfect, there were...
asked by 06.05.2014 / 13:18
1
answer

Error creating foreign key in MariaDB

When trying to create the toy table, the following error appears:    ERROR 1005 (HY000): Can not create table brinquedos . brinquedo   (errno: 150 "Foreign key constraint is incorrectly formed") Follow the code: CREATE TABL...
asked by 30.12.2016 / 16:33
2
answers

Condition for INSERT INTO

I need SQL to check if there is any value equal to 1, 2 or 3 in the '@variavel' sent; If it is green enter the value 1, otherwise enter the value 0. Note: the table and column can be given as example as fictitious.     
asked by 24.10.2018 / 14:16
1
answer

Rollback method does not work in mysqli extended class

Hello, Because of the PHP version on the server, the fetch all and mysqli begin_transaction methods do not work. To solve this, I created another connection class by extending the MySQLi class and instantiating it. <?php namespace App\DB;...
asked by 17.01.2017 / 19:05
1
answer

How to replace COUNT (*) in innoDB

I migrated data from a MyISAM database to InnoDB and some VIEW were extremely slow (on average 15x slower), after much research I found this answer from @maniero and it compares the two engines. In his response I noticed that InnoD...
asked by 23.08.2018 / 19:48