innodb vs myisam : comparision of mysql database engines

MYISAM:

  1. MYISAM supports Table-level Locking
  2. MyISAM designed for need of speed
  3. MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
  4. MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
  5. MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
  6. MYISAM supports fulltext search
  7. You can use MyISAM, if the table is more static with lots of select and less update and delete.

INNODB:

  1. InnoDB supports Row-level Locking
  2. InnoDB designed for maximum performance when processing high volume of data
  3. InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
  4. InnoDB stores its tables and indexes in a tablespace
  5. InnoDB supports transaction. You can commit and rollback with InnoDB

2 thoughts on “innodb vs myisam : comparision of mysql database engines

  • February 3, 2015 at 10:13 am
    Permalink

    I’ve been explooring for a bit for any high-quality articles or weblog posts
    on this sort of area . Exploring in Yahoo I eventually stumbled
    upon this web site. Reading this information So i am happy to
    show that I have a very just right uncanny feeling
    I found out exactly what I needed.I such a lot undoubtedly will make certain too do not disregard this site and give it
    a look on a relentless basis.

  • February 7, 2015 at 1:26 pm
    Permalink

    Wonnderful beat ! I would like to apprentice whilst you
    amend your web site, how ccan i subscribe for a blog website?
    The acount aided me a acceptable deal. I had been tiny bit familiar
    of this your broadcast offgered bright transparent idea

Leave a Reply