Top "Innodb" questions

InnoDB is an ACID-compliant transactional storage engine for MySQL that uses MultiVersion Concurrency Control (MVCC).

Unknown table engine 'InnoDB'

Recently, I have found out that I can maximize mysql performance when if I have good hardware. Since I've been …

mysql innodb
Setting up table relations what do "Cascade", "Set Null" and "Restrict" do?

I want to start using table relations in a new project. After some googling I got 2 tables set up as …

mysql phpmyadmin innodb relational-database
How can I set default storage engine used by MySQL?

I've been working on writing SQL to create a MySQL database with several default options, including character set and collation. …

mysql database innodb
Fulltext Search with InnoDB

I'm developing a high-volume web application, where part of it is a MySQL database of discussion posts that will need …

sql mysql search full-text-search innodb
How do I know if a mysql table is using myISAM or InnoDB Engine?

In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, …

mysql innodb myisam storage-engines
How to configure MySQL 5.6 LONGBLOB for large binary data

Before I ask my question a little background: I'm doing the Data Export/Import using the MySQL Workbench 6.1 of a …

mysql sql row innodb
What are MySQL database engines?

I looked around and found some of the MySQL engines are innodb and MyISAM. Perhaps there are few more. My …

mysql database storage innodb database-engine
MySQL error: The maximum column size is 767 bytes

When I run a program which does something with MySQL, I got this error message: 2015-06-10 15:41:12,250 ERROR app.wsutils 419 …

mysql database size innodb mysql-workbench
Getting error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" when starting MySQL

I found many similar question on Stackoverflow but didn't get the exact error solution. My issue is when starting MySQL …

mysql ubuntu innodb mariadb-10.3
UUID performance in MySQL?

We're considering using UUID values as primary keys for our MySQL database. The data being inserted is generated from dozens, …

mysql performance innodb sequence uuid