MySQL storage engine MyISAM and InnoDB's pros and cons

Using MySQL will of course have access to the MySQL storage engine, which you will see when creating a new database and creating a new data table.
MySQL default storage engine is MyISAM, other commonly used is innodb.
What kind of storage engine is better? This question is inconclusive and needs to be measured in terms of your needs and circumstances. Therefore, the concept of the two engines, principles, similarities and differences and their respective advantages and disadvantages have a detailed understanding, and then according to their own circumstances to choose a lot easier.

In general, MyISAM and InnoDB each have their own merits and demerits, each have their own use of the environment.
But InnoDB's design goal is to deal with a large-capacity database system whose CPU utilization is not comparable to other disk-based relational database engines.
I think the use of InnoDB can handle more complex situations, especially if concurrency is more efficient than MyISAM. Combined with memcache, you can also cache select to reduce select queries, which improves overall performance.

MySQL storage engine MyISAM and InnoDB's pros and cons