Skip to main content

Posts

Showing posts with the label what are the storage engine used in mysql

Storage Engines

           When creating a table in MySQL, the storage engine that will be used has to be chosen.  If one is not chosen, MySQL uses the default storage engine chosen in the configuration of the server.  MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables. There are numerous storage engines that MySQL supports; however the most common storage types that are used with PHP are listed below:  •  MyISAM -                     This storage engine is  supported in all MySQL configurations and is the default storage engine for all new tables created  (when a specific storage engine is not assigned) in the majority of default installations.  This  storage engine manages non-transactional tables.  It provides high-speed storage and retrieval, as  well as fulltext searching capabilities.  MyISAM is a disk based storage engin