Top "Innodb" questions

Changing Table Engine in MySQL

I am using mysql and mysql workbench. I created 5 tables with innodb engine. I checked their engine and it was …

mysql database innodb myisam

mysql Fatal error: cannot allocate memory for the buffer pool

I have this error log from MySQL, any idea? Website works for some time and then I get MySQL shutdown …

mysql innodb

How to solve InnoDB: Unable to lock ./ibdata1 mysql error?

2016-03-14 02:30:29 58150 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 35 2016-03-14 02:30:29 58150 [Note] InnoDB: Check that you do not already have …

mysql linux command-line-interface innodb

How to disable index in innodb

I'm trying to speed up bulk insert in an InnoDB table by temporary disabling its indexes: ALTER TABLE mytable DISABLE …

mysql indexing innodb

InnoDB takes over an hour to import 600MB file, MyISAM in a few minutes

I'm currently working on creating an environment to test performance of an app; I'm testing with MySQL and InnoDB to …

mysql performance innodb

Quickest way to delete enormous MySQL table

I have an enormous MySQL (InnoDB) database with millions of rows in the sessions table that were created by an …

mysql innodb

Why to use foreign keys with no action on delete or update

I have a question of interest: I have 2 tables in mysql with InnoDb. table tbl_a has a primary key, …

mysql foreign-keys innodb myisam

How do I re-create a MySQL InnoDB table from an .ibd file?

Assume that the following MySQL files have been restored from a backup tape: tablename.frm tablename.ibd Furthermore, assume that …

mysql innodb disaster-recovery

Hibernate: Create Mysql InnoDB tables instead of MyISAM

How can I get Hibernate (using JPA) to create MySQL InnoDB tables (instead of MyISAM)? I have found solutions that …

java mysql hibernate jpa innodb

MySQL: Creating table with FK error (errno 150)

I've created a model with MySQL Workbench and am now attempting to install it to a mysql server. Using File &…

mysql foreign-keys innodb mysql-error-1005