Which storage engine is used in the database depends on the business. Myisam, which reads more and does not need to perform frequent operations on the table, is enough!
I often write, such as orders, that require data related to multiple tables, and transaction processing is used. This can only be done with Innodb!
Only storage engines like Innodb support transactions:

To boil down why InnoDB is more popular than MyIsam:
1. After a long period of development and optimization, InnoDB's performance has been very good, and most scenarios can have better performance. The main reason is that InnoDB is 行锁 and Myisam is 表锁. Only fully inserted or read tables will be slightly faster with Myisam.
2. Transactions are a very important feature in relational databases. Many practical scenarios require the use of transaction features. InnoDB supports it but MyIsam does not.

There are not many usage scenarios for other storage engines. Memory is occasionally used to make hot tables.

• InnoDB is a row lock, Myisam is a table lock
• InnoDB supports transactions
• InnoDB is constantly being upgraded and optimized

To this day, there is no need to think about it. Myisam has no advantage over innodb.