MySql: MyISAM vs. Inno DB! [closed]

by

The main difference is that InnoDB supports transactions while MyISAM does not.

There are numerous other differences, however the common one’s i am aware of are:

  • MyISAM has typically been considered faster at searching, but recent InnoDB improvements are removing this difference and improving high concurrency workload performance
  • InnoDB support transactions whilst MyISAM does not
  • InnoDB supports referential integrity whilst MyISAM does not
  • InnoDB handles indexes a bit differently, storing the primary key as part of every index (making indexes take up more room on the disk, but also making a covering index more likely)
  • MyISAM does table level locking while InnoDB can do row level locking
  • Different memory/buffer/index settings are used in the MySQL configuration files
  • InnoDB is typically said to have better crash recovery
  • As mentioned in another answer, the data is store on disk differently. I believe InnoDB is configurable in this area and can have one file per table etc. if required

I’m sure a google search or the MySQL site will bring up numerous other differences in more detail.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. What’s the difference between MyISAM and InnoDB? [duplicate]
  3. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. Is there a REAL performance difference between INT and VARCHAR primary keys?
  6. How to shrink/purge ibdata1 file in MySQL
  7. MySQL InnoDB foreign key between different databases
  8. How can I check MySQL engine type for a specific table?
  9. How do I rename a MySQL database (change schema name)?
  10. Should I always prefer MySQL InnoDB over MyISAM?
  11. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. How to properly create composite primary keys – MYSQL
  14. Is there a MySQL option/feature to track history of changes to records?
  15. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  16. View’s SELECT contains a subquery in the FROM clause
  17. MySQL : Multiple row as comma separated single row
  18. Bogus foreign key constraint fail
  19. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  20. Case statement in MySQL
  21. Export a MySQL Database to SQLite Database
  22. How to optimize COUNT(*) performance on InnoDB by using index
  23. How to find out the MySQL root password
  24. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  25. How to display open transactions in MySQL
  26. Easiest way to copy a table from one database to another?
  27. Database corruption with MariaDB : Table doesn’t exist in engine
  28. Mysql service won’t start, InnoDB init function error
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment