Default storage engine in MySQL

[Jenniferlinn]

Can anybody tell me how many storage engines are there in MySQL and which engine is the default engine in MySQL?

Kindly post answer if know it

[DiGSGRL]

http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
Thats a link to the MySQL site explaining the storage engines and how to set the engine you want to use for your tables.

[Monalisaparker]

There are many storage engines in MySQL like
* MyISAM
* InnoDB
* MERGE
* MEMORY

The default storage engine is MyISAM.

[mwasif]

The default storage engine is MyISAM.

You can set the default storage of your own choice by changing the following parameter in my.ini/my.cnf

default-storage-engine=MyISAM

[bhanu1225]

The default Storage engine is

Go for mysql prompt.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| images |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| ENGINES |
| EVENTS |
| FILES |
| GLOBAL_STATUS |
| GLOBAL_VARIABLES |
| KEY_COLUMN_USAGE |
| PARTITIONS |
| PLUGINS |
| PROCESSLIST |
| PROFILING |
| REFERENTIAL_CONSTRAINTS |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| SESSION_STATUS |
| SESSION_VARIABLES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
28 rows in set (0.00 sec)

mysql> select * from ENGINES;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| ENGINE | SUPPORT | COMMENT | TRANSACTIONS | XA | SAVEPOINTS |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)

mysql>

this is how we can search.

[mrcullers]

The default storage engine is based on the parameters chosen when the MySQL was installed. There are 3 methods in installation. 2 methods use InnoDB as the default, and 1 uses MyISAM as the default. It can be either one. To find out, make a database in phpMyAdmin, then click to add a table and at the bottom the default will always be chosen/displayed where which you can then select the engine of your preference.