Manage Transactions in MySQL

By | September 14, 2015
0
0



In this tell-all tutorial, Jay Greenspan, author of MySQL Weekend Crash Course and co-author ofMySQL/PHP Database Applications, starts with a tour of the basics: He answers the age-old Q: “What’s the big deal with Transactions?”; investigates the four properties that a database must have to be considered transaction-capable; takes a closer look at locking mechanisms; and finishes up with a look at MyISAM tables, the lesser cousin of fully transaction-capable tables.

Once you have a taste of the limitations of MyISAM tables, you’ll be hungry for the real deal. In Lesson 2, Jay satiates that hunger with a thorough introduction to MySQL’s different transactional table types: BDB, Gemini, and InnoDB.

Leave a Reply

Your email address will not be published. Required fields are marked *