Why doesn’t MySQL’s MyISAM engine support Foreign keys?

by

  1. Kindly tell me, In this situation what engine I have to use for improve performance?

    The performance of each storage engine will depend on the queries you perform. However, be aware that different tables within the same database can use different storage engines.

  2. Why MyISAM engine does not support foreign key relationship and InnoDB does?

    As documented under Foreign Key Differences:

    At a later stage, foreign key constraints will be implemented for MyISAM tables as well.

    Therefore, foreign key constraints have simply not yet been implemented in MyISAM.

EDIT: As that comment is removed from docs, it appears that it is no longer planned to implement foreign key constraints in MyISAM engine.

  1. Why MyISAM engine does support full text search and InnoDB does not?

    As documented under What Is New in MySQL 5.6:

    You can create FULLTEXT indexes on InnoDB tables, and query them using the MATCH() ... AGAINST syntax.

    Therefore, full text search has been implemented in InnoDB as of MySQL 5.6.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. What’s the difference between MyISAM and InnoDB? [duplicate]
  3. MySql: MyISAM vs. Inno DB! [closed]
  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. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  12. 1052: Column ‘id’ in field list is ambiguous
  13. How to do a batch insert in MySQL
  14. Count the occurrences of DISTINCT values
  15. Codeigniter – multiple database connections
  16. 1114 (HY000): The table is full
  17. JOIN queries vs multiple queries
  18. Is the primary key automatically indexed in MySQL?
  19. Storing Data in MySQL as JSON
  20. UUID performance in MySQL?
  21. MySQL: Cloning a MySQL database on the same MySql instance
  22. DOs and DONTs for Indexes [closed]
  23. How to change the default port of mysql from 3306 to 3360
  24. How to insert images from database?
  25. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  26. When to use MyISAM and InnoDB? [duplicate]
  27. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  28. MySQL InnoDB: autoincrement non-primary key
  29. How to insert a file in MySQL database?
  30. What is the best way to do incremental backups in MySQL?

Leave a Comment