MySQL Storage Engine

1
What is MySQL Storage Engine?
If you are not aware with MySQL, or are familiar
with other relational database systems, the
concept of a storage space motor can take some
time to understand
2
storage space motor features and capabilities

• Transactional and non-transactional
• Chronic and non-persistent
• Table and row level locking
• Different index methods such as B-tree, Btree,
  Hash, and R-tree

3

• Clustered indices versus non-clustered indexes
• Primary versus secondary indexe
• Data compression
• Full text index capabilities

4
Three primary storage space google that are
included automatically with MySQL

• MyISAM A non-transactional storage space motor
  that was the standard for all MySQL versions
  prior to 5.5
• InnoDB The most popular transactional storage
  space motor and the standard motor starting with
  version 5.5
• Memory As the name suggests, a memory based,
  non-transactional, and non-persistent storage
  space engine

5
MySQL 5.5 Reinforced Storage space Engines

• InnoDB
• The standard storage motor as of MySQL 5.5.5.
  InnoDB is a transaction-safe (ACID compliant)
  storage motor for MySQL that has make, rollback,
  and crash-recovery abilities to secure customer
  details

6

• MyISAM
• The MySQL storage motor that is used the most in
  Web, data warehousing, and other application
  surroundings

7

• Thank You