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
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
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.
There are many storage engines in MySQL like
* MyISAM
* InnoDB
* MERGE
* MEMORY
The default storage engine is MyISAM.
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
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.
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.