Mysql

---

MYISAM:   In Detail

MYISAM supports Table-level Locking
MyISAM designed for need of speed
MyISAM does not support foreign keys hence we call MySQL with MYISAM
                  is DBMS
MyISAM stores its tables, data and indexes in diskspace using separate three
                  different files. (tablename.FRM, tablename.MYD, tablename.MYI)
      .FRM  =>  It has the table structure of your table or table definition
      .MYI  =>   It has the indexes of your table
      .MYD =>   It contains your data
      .FRM
              FRM is a file extension for formatting used with MySQL. 
	      FRM stands for FoRMat. FRM files are used to define the 
	      format of a table used with MySQL. MySQL is a cross-platform 
	      relational database. FRM files will have the same name as the 
	      table they reference, but with a .FRM extension. FRM files 
	      are created by MySQL when the table is created.
       You can use these files when your db crash, or when you upgrade 
             your db to another version and it can also be used while migrating 
             and repairing your indexes without affecting data..
MYISAM not supports transaction. You cannot commit and rollback with MYISAM.
                   Once you issue a command it’s done.
MYISAM supports fulltext search
You can use MyISAM, if the table is more static with lots of select and   
                   less update and delete.

INNODB:   In Detail

InnoDB supports Row-level Locking
InnoDB designed for maximum performance when processing high volume of data
InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
InnoDB stores its tables and indexes in a tablespace
              InnoDB's file-per-table tablespace feature provides a more flexible alternative, 
              where each InnoDB table and its indexes are stored in a separate .ibd data file. 
              Each such .ibd data file represents an individual tablespace. This feature is 
              controlled by the innodb_file_per_table configuration option, which is enabled by 
              default in MySQL 5.6.6 and higher.
InnoDB supports transaction. You can commit and rollback with InnoDB                                    

< Important Mysql Query Mysql difference between two timestamps >

Ask a question

• Question:

  {{questionlistdata.blog_question_description}}

  • Answer:

    {{answer.blog_answer_description  }}

  Replay to Question
  
  

(+91)-9910699802

Become A Member     Become A Teacher