Tweet
Default Storage Engine of MySQL.
MySQL Server features a concept called storage engines, or table types. The server, and in fact the developer, can choose how and where a database table is to be stored based on which storage engine is best suited for a particular situation.
MyISAM is the default storage engine of Mysql and InnoDB supports transactions and foriegn keys
MyISAM is a deafult storage engine in MySQL and is mostly in WEB, datawarehousing and other application environments.
Different applications have different requirements with regard to data storage, and some of these requirements may even conflict. Think of a banking application that requires highly secure transaction processing, versus traffic logging on a website si InnoDB is best suited to this situation.
InnoDB is also a storage engine in MySQL. Even this is included by default in MySQL. But this is used for transaction processing applications and supports a number of features including ACID transaction support and foreign keys.
In source distributions, you can enable or disable either engine by configuring MySQL as you like.
Both are best but it depends on the use. And for general purpose its better to use MyISAM.
MyISAM is the default storage engine of Mysql and InnoDB supports transactions and foriegn keys
MyISAM is a deafult storage engine in MySQL and is mostly in WEB, datawarehousing and other application environments.
Different applications have different requirements with regard to data storage, and some of these requirements may even conflict. Think of a banking application that requires highly secure transaction processing, versus traffic logging on a website si InnoDB is best suited to this situation.
InnoDB is also a storage engine in MySQL. Even this is included by default in MySQL. But this is used for transaction processing applications and supports a number of features including ACID transaction support and foreign keys.
In source distributions, you can enable or disable either engine by configuring MySQL as you like.
Both are best but it depends on the use. And for general purpose its better to use MyISAM.
Comment