A Wired.com user account lets you create, edit and comment on Webmonkey articles. You will also be able to contribute to the Wired How-To Wiki and comment on news stories at Wired.com.
It's fast and free.
processing...Retrieve Sign In
Please enter your e-mail address or username below. Your username and password will be sent to the e-mail address you provided us.
processing...Welcome to Webmonkey
- edit articles
- add to the code library
- design and write a tutorial
- comment on any Webmonkey article
Sign In Information Sent
Manage Transactions in MySQL
/skill level/
/viewed/
| Line 5: | Line 5: | ||
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. | 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. | ||
| - | Get started: '''[[Manage Transactions in MySQL - Lesson 1|Lesson 1]]''' | + | Get started: '''[[Tutorial:Manage Transactions in MySQL - Lesson 1|Lesson 1]]''' |
<span id="title_name_el" class="wm_hidden_meta_class" title="Manage Transactions in MySQL" style="visibility: hidden"> <span id="page_path_el" class="wm_hidden_meta_class" title="/webmonkey/06/09/" style="visibility: hidden"> <span id="author_el" class="wm_hidden_meta_class" title="aduvander" style="visibility: hidden"> <span id="creation_date_el" class="wm_hidden_meta_class" title="28 Feb 2006" style="visibility: hidden"> </span></span></span></span> | <span id="title_name_el" class="wm_hidden_meta_class" title="Manage Transactions in MySQL" style="visibility: hidden"> <span id="page_path_el" class="wm_hidden_meta_class" title="/webmonkey/06/09/" style="visibility: hidden"> <span id="author_el" class="wm_hidden_meta_class" title="aduvander" style="visibility: hidden"> <span id="creation_date_el" class="wm_hidden_meta_class" title="28 Feb 2006" style="visibility: hidden"> </span></span></span></span> | ||
| - | == Introduction == | ||
| - | |||
| - | == What you'll need == | ||
| - | |||
| - | |||
| - | == Steps == | ||
| - | |||
| - | |||
| - | == Alternate methods == | ||
| - | |||
| - | |||
| - | == Suggested readings == | ||
Current revision
Overview
In this tell-all tutorial, Jay Greenspan, author of MySQL Weekend Crash Course and co-author of MySQL/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.
Get started: Lesson 1
- This page was last modified 14:01, 15 August 2008.
/related_articles/
Special Offer For Webmonkey Users
WIRED magazine:
The first word on how technology is changing our world.
Registration on or use of this site constitutes acceptance of our User Agreement (Revised 4/2/2009) and Privacy Policy (Revised 4/2/2009).
Wired.com © 2009 Condé Nast Digital. All rights reserved.
The material on this site may not be reproduced, distributed, transmitted, cached or otherwise used, except with the prior written permission of Condé Nast Digital.