Question: Which is better MyISAM or InnoDB?, what is innodb?, what is MyISAM?
in myisam vs innodb, The frequently & default used storage engine in MySQL are MyISAM (default storage engine) and InnoDB (storage engine for MySQL).With these storage engine there are some benefit and drawback according to projects or webapps requires.As you all know, the default storage engine selected by MySQL database is MyISAM.
The main differences between myisam vs innodb (“with respect to designing or create a table or database” you asked about) are allow for “referential integrity” as well as “transactions”.
InnoDB vs MyISAM
Here are a little of the important differences between InnoDB and MyISAM:
InnoDB has row-level locking system. MyISAM storage engine only has full table-level locking system.
InnoDB has what is called referential integrity which requires Help to foreign keys (RDBMS) as well as relationship constraints, MyISAM does not (DMBS).
InnoDB allows transactions, which means you can commit statement as well as roll back statement. MyISAM does not.
InnoDB is additional dependable as it uses transactional logs for auto recovery. MyISAM does not.
Convert MyISAM to InnoDB with phpMyAdmin
You can change MyISAM to InnoDB rightly simple. This great example is below is using the wp_posts table. step by step run wordpress the MySQL ALTER command to change or update it to InnoDB storage engine. important Note: I always recommend first of all check disk space you can all the backing up your MySQL database table double copy save your local computer system before running or execute any operations on it.
ALTER TABLE wp_posts ENGINE=InnoDB;
myisam vs innodb
Here is a great infromation of which Database storage engine you should use in which your application needed: