Anybody know? What is Inno DB (database) ?

Discussion in 'MySQL' started by Smile1971, Mar 29, 2009.

0
  1. #1
    Anybody know? What is Inno DB (database) ? Is it like SQL? Or What? Tq
     
    Smile1971, Mar 29, 2009 IP
  2. kusal

    kusal Peon

    Messages:
    91
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    InnoDB is a mysql database Storage Engine.
    The Mysql default Database Storage Engine is MyISAM
    You don't need to worry about database Storage Engines that much, its how mysql will index your data.

    It is said that MyISAM is better when you have large amount of data.
    You need InnoDB if you want foreign key relationship between tables.

    http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html
     
    kusal, Mar 29, 2009 IP
    pipes likes this.
  3. timarcher52

    timarcher52 Peon

    Messages:
    62
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    timarcher52, Mar 29, 2009 IP
    pipes likes this.