O'Reilly logo

MariaDB Crash Course by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

26. Managing Transaction Processing

In this chapter you learn what transactions are and how to use COMMIT and ROLLBACK statements to manage transaction processing.

Understanding Transaction Processing

Note: Not All Engines Support Transactions

As explained in Chapter 21, “Creating and Manipulating Tables,” MariaDB supports the use of several underlying database engines. Not all engines support explicit management of transaction processing, as explained in this chapter. One of the most commonly used engines is MyISAM, which does not support explicit transaction management, while InnoDB and ARIA do. This is why the sample tables used in this book were created to use ARIA. If you need transaction processing functionality in your applications, be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required