MyISAM and InnoDB

Discussion in 'MySQL' started by cancer10, Jun 22, 2009.

0
  1. #1
    Hi There,


    There are many difference between MyISAM and InnoDB for example, MyISAM is a lot faster as compared to InnoDB but MyISAM does not support transitional tables where as InnoDB does. MyISAM does not have row level locking where as InnoDB does.

    So my question is, which engine does websites like Yahoo, Youtube uses since they would need all of the above features?


    Thanks
     
    cancer10, Jun 22, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    They're most likely using a custom MySQL build and a clustering storage method. Percona and Google have created some really good MySQL builds and patches, and I would imagine that at least google is using their own development. Otherwise, I would imagine that they would use InnoDB. Personally, I think InnoDB is faster than MyISAM on a tuned database. Even if it wasn't the benefits of using it outweigh any performance gain.
     
    jestep, Jun 22, 2009 IP
  3. livedating

    livedating Active Member

    Messages:
    161
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    83
    #3
    Google keep also search engine data in RAM, I think this is something like STL-based data structures (arrays, hashes, etc.)

    Here you can find more info: http://dashes.com/anil/2003/04/googles-advanta.html


    Элитные дома и коттеджи Киев Продать дом под Киевом
     
    livedating, Jun 23, 2009 IP