What are transaction storage engines in mysql

Storage engines are MySQL components that handle the SQL operations for different table types. To use transactions, you must use a transaction-safe storage engine. InnoDB is the default and most general-purpose storage engine.
The below command display the status information of the server's storage engines.
SHOW ENGINES;

For more details check the links.
https://www.w3resource.com/mysql/mysql-storage-engines.php
https://zetcode.com/mysql/storageengines/
https://www.geeksforgeeks.org/what-are-the-different-mysql-database-engines/
https://www.sisense.com/blog/beginners-guide-to-mysql-storage-engines/

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago
Storage engines are MySQL components that handle the SQL operations for different table types. To use transactions, you must use a transaction-safe storage engine. InnoDB is the default and most general-purpose storage engine.
The below command display the status information of the server's storage engines.
SHOW ENGINES;

For more details check the links.
https://www.w3resource.com/mysql/mysql-storage-engines.php
https://zetcode.com/mysql/storageengines/
https://www.geeksforgeeks.org/what-are-the-different-mysql-database-engines/
https://www.sisense.com/blog/beginners-guide-to-mysql-storage-engines/