Categories: My SQL

How many storage engines in MySQL?

1.  MyISAM :  MyISAM is a default storage engine and that one using in web, data warehousing and other application environments.

2. InnoDB : Using this engines our transaction is safe and we can use this for row level blocking.

3. Memory : Store data in RAM for fast access of data formally known as HEAP.

4. NDBClusters : This clustered database engine is particularly suited for applications that require the highest possible degree of up-time and availability.

Developer Diary

Share
Published by
Developer Diary

Recent Posts

Laravel vs Node Js: Which One Is Good For What?

Introduction In the world of web development, selecting the correct framework is critical. Laravel and…

3 months ago

Docker Cheatsheet: Essential Commands and Explanations

Introduction By enabling containerization, Docker has transformed the way software is built, deployed, and managed.…

8 months ago

Difference between Memcached and REDIS – Secrets of Caching

Introduction Speed and efficiency are critical in the ever-changing world of web development. Effective caching…

8 months ago

How to Revert a Git Commit: A Simple Example

Introduction Git, a popular version control system in software development, enables developers to track changes,…

8 months ago

What is Git Stash and Why Do You Need It

Introduction Are you tired of grappling with tangled changes and unfinished work while using Git?…

8 months ago

Difference between git stash pop and git stash apply

Introduction Version control is essential in software development because it ensures that changes to a…

8 months ago