Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts

    MyIsam -v- InnoDB

    What is the view of the panel on this one? I suspect that there may be trade-offs but, I welcome your experience-based opinions.

    bazz

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    If you are running Full Text indexes you need to use MyISAM tables.

    If you are using proper foreign keys where you would need to enforce the integrity of your data then you need to use INNODB. (i.e. if you use MyISAM type and try to do an ON CASCADE DELETE/UPDATE, the subordinate tables would be ignored).

    Other than that I'm not aware of speed issues or whatever.

  • #3
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    Ok thanks.

    I have read that InnoDb is better when you need to lock records individually rather than complete tables. So, if I have a lot of page requests at around the same time and they amend data in the same table, apparently InnoDb is better as the speciifc record would be locked for the amendment rather than the whole table, which would slow down the whole thing.

    what you guys think?

    bazz

  • #4
    Senior Coder
    Join Date
    Jul 2005
    Location
    New York, NY
    Posts
    1,084
    Thanks
    4
    Thanked 19 Times in 19 Posts
    InnoDB implements a lot more features than MyISAM. Because of that, there is definitely a speed difference, though very specific and often minor. One place it's not minor is inserting and updating records with lots of constraints. MyISAM simply doesn't support certain constraints, so it doesn't have to check them, hence it's faster. If you don't use the features of InnoDB though, you won't see a serious speed difference.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •