• What is InnoDB and MyISAM. ... to discuss all of them, however, in the industry, you will mainly hear about two major storage engines InnoDB and MyISAM.
  • MyISAM is optimized for environments with heavy read operations, and few writes, or none at all.
  • Rumor has it that the next major version will eliminate the need for MyISAM by making truly temporary InnoDB tables and by moving the system tables into InnoDB.
  • The MERGE storage engine allows a collection of identical MyISAM tables to be handled as a single table.
  • Bununla birlikte, bir tabloda aynı anda okuma ve yazma yapılırsa , MYISAM ın performansı çarpıcı bir şekilde düşer.
  • Eğer programımızda çok fazla okuma ve listeleme işlemleri var ise Myisam seçmeliyiz.
  • Under some circumstances, MyISAM allows INSERTs and SELECTs to be executed concurrently.
  • To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option
  • The MyISAM key buffer is only meant for indexes, and a full-text search is supported in MyISAM.
  • Use the MyISAM storage engine for read-heavy workloads and applications that require full-text search capabilities.