Skip to main content

Posts

Showing posts from November, 2013

MySQL Database Storage Engines

Storage Engine: A storage engine is a software that is used by a database management system to create, read, and update data from a database. Most DBMS use APIs (Application Programming Interface) to enable interactions of users with the storage engines. There are two types of storage engines; Transactional and Non-transactional storage engines. Transactional Databases Transactional databases mean that the write operations on these databases are able to be rolled back if they do not complete. These operations are known as transactions. Most of the modern databases are transactional databases.  Non-Transactional Databases The impact of no Rollback/Commit is felt. In order to perform rollback operation the user will need to do it manually with codes. By default, MySQL runs with autocommit mode enabled. This means that as soon as you execute a statement that updates (modifies) a table, MySQL stores the update on disk. If you are using a transaction-safe...