How many types of database engines???

Discussion in 'Databases' started by andrewhoward123, Dec 15, 2013.

0
  1. #1
    Share that how many types of database engine in MySQL..also explain them..
     
    andrewhoward123, Dec 15, 2013 IP
  2. Andrei_RO

    Andrei_RO Well-Known Member

    Messages:
    86
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    130
    #2
    according to this:
    http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html

    there are 10 :
    1. The MyISAM Storage Engine
    2. The InnoDB Storage Engine
    3. The MERGE Storage Engine
    4. The MEMORY (HEAP) Storage Engine
    5. The BDB (BerkeleyDB) Storage Engine
    6. The EXAMPLE Storage Engine
    7. The FEDERATED Storage Engine
    8. The ARCHIVE Storage Engine
    9. The CSV Storage Engine
    10. The BLACKHOLE Storage Engine

    I used only MyIsam and InnoDB - first difference that you notice is - Myisam stores tables in sepparate files, InnoDb uses one file for all tables

    also MyIsam is a much more simpler DB engine. It lacks: foreign keys and cascading deletes/updates, transactional integrity (ACID compliance), rollback abilities
    has a Row limit of 4,284,867,296 rows and a maximum of 64 indexes per row

    InnoDb has no full text indexing, can be a tiny bit slower.

    Also , MyISAM is stagnant, it is not further developed; all future enhancements will be in InnoDB
     
    Andrei_RO, Dec 18, 2013 IP
  3. andrewhoward123

    andrewhoward123 Active Member

    Messages:
    149
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    50
    #3

    Thank you for your answer..
     
    andrewhoward123, Dec 19, 2013 IP