For an online store engine (php), what type of tables is best done: InnoDB or MyISAM?
What are the differences between these types?
What can you justify your choice?
If such a question arises, it is better to take MyIsam: more tolerance for glitches and careless handling. InnoDB allows you to normally lock tables, works a little faster. But in the event of a breakdown of the table without a backup, it is almost impossible to recover.
Score? Only InnoDB, because you probably need a transaction.
Just set up the server correctly so that "tolerance for glitches and careless handling" is not useful to you.
Better, get the same postgres.
Most likely you will not feel the difference.
The article was written a long time ago, but essentially nothing has changed.
InnoDB . Because there are 2 big advantages:
Source: https://ru.stackoverflow.com/questions/196203/