Why there are multiple storage motors in MySQL

Why there are multiple storage motors in MySQL? If Make c开发者_StackOverflow中文版ompare between MySQL and MSSQL with storage motor property. Which DBMS have advantage?

---

I'm assuming you meant 'Storage Engines' instead of 'Storage Motors'

basically different engine is meant for different purpose, some are meant to handle transactions, some are meant for fast reads. I shall refer you to Storage Engines on MySQL Manual

---

In my opinion MySQL and MsSQL are two different levels of databasesystems. And which one you pick depends on the situation (linux, windows) and what your requirements are. MsSQL is more grown up in my opinion and MySQL is very easy to use with webapplications.

There is a lot to find on the internet.