What are the advantages of MyISAM over InnoDB?

  • MyISAM follows a conservative approach to disk space management and stores each MyISAM table in a separate file, which can be further compresses, if required. On the other hand, InnoDB stores the tables in tablespace. Its further optimization is difficult.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What is the difference between mysql_fetch_array and mysql_fetch_object?

How is MyISAM table stored?

Is Mysql query is case sensitive?

Write a query to select all teams that won either 1, 3, 5 or 7 games.

What is the basic MySQL architecture?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What are the advantages of MyISAM over InnoDB?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges