MySql - InnoDb

Card Puncher Data Processing

MySql - InnoDb


InnoDB is the default storage engine (From MySQL 5.6)

It is:

  • a transaction-safe (ACID compliant)
  • that has commit, rollback, and crash-recovery capabilities

It supports:

  • FOREIGN KEY referential-integrity constraints.

It has

  • row-level locking (without escalation to coarser granularity locks)
  • and Oracle-style consistent nonlocking reads increase multi-user concurrency and performance.

InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys.

Documentation / Reference

Discover More
Card Puncher Data Processing
MySQL - Character Set

character sets configuration in mysql You can specify character sets at the server, database, table, and column level. conf file options of the daemon, use the: --character-set-server...
Card Puncher Data Processing
MySql - Index

innodb index - Doc - Accessing a row through the clustered index is fast because the index search leads directly to the page with all the...
Card Puncher Data Processing
MySql - Primary Key (clustered index or cluster index)

in MySql From primary_key glossary - When choosing primary key values, consider: a synthetic key (using arbitrary values)...

Share this page:
Follow us:
Task Runner