Conclusion

 

In conclusion, we can say that optimization seeks to improve the performance of a computer system through changes in software or hardware. It may include reducing execution time, memory usage, or power consumption. It is applied in applications, devices and networks.

We also emphasize that in general InnoDB is an open source data storage mechanism for the MySQL database, included as a standard table format in all MySQL AB distributions starting with versions 4.0. Its main feature is that it supports ACID type transactions and record locking and referential integrity. InnoDB offers much greater reliability and consistency than MyISAM, the previous MySQL table technology, although the best performance of one format or another will depend on the specific application.

The InnoDB storage engine is not always the best substitute for its predecessor, MyISAM. As projects or databases grow in complexity, InnoDB becomes the appropriate solution for MySQL. For smaller databases or applications, MyISAM is much more powerful. If used correctly, there is no question which storage engine should be used. If necessary, both modules can be used side by side in the same database.