What Are The Advantages Of Myisam Over Innodb?

1.	What Are The Advantages Of Myisam Over Innodb?
Answer» 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. 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.

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What Is Sqlyog?
How Do You Backup A Database In Mysql?
What Are The Differences Between Mysql_fetch_array(), Mysql_fetch_object(), Mysql_fetch_row()?
What Are The Advantages Of Myisam Over Innodb?
What Is The Usage Of Enums In Mysql?
How Is Myisam Table Stored?
What Is The Use Of Mysql_close()?
What Is Mysql Data Directory?
How Do You Determine The Location Of Mysql Data Directory?
What Is The Usage Of Regular Expressions In Mysql?