<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Transaction Isolation Level Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-is.html" title="INFORMATION_SCHEMA Index"><link rel="next" href="dynindex-jointype.html" title="JOIN Types Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Transaction Isolation Level Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-is.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-jointype.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-isolevel"></a>Transaction Isolation Level Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">READ COMMITTED</code></h3><dl><dt><a href="storage-engines.html#innodb-record-level-locks" title="13.6.8.4. InnoDB Record, Gap, and Next-Key Locks">Section 13.6.8.4, “<code class="literal">InnoDB</code> Record, Gap, and Next-Key Locks”</a></dt><dt><a href="storage-engines.html#innodb-parameters" title="13.6.3. InnoDB Startup Options and System Variables">Section 13.6.3, “<code class="literal">InnoDB</code> Startup Options and System Variables”</a></dt><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-consistent-read" title="13.6.8.2. Consistent Nonlocking Reads">Section 13.6.8.2, “Consistent Nonlocking Reads”</a></dt><dt><a href="storage-engines.html#innodb-deadlocks" title="13.6.8.9. How to Cope with Deadlocks">Section 13.6.8.9, “How to Cope with Deadlocks”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-transactions" title="17.1.5.3. Limits Relating to Transaction Handling in MySQL Cluster">Section 17.1.5.3, “Limits Relating to Transaction Handling in MySQL Cluster”</a></dt><dt><a href="storage-engines.html#innodb-locks-set" title="13.6.8.6. Locks Set by Different SQL Statements in InnoDB">Section 13.6.8.6, “Locks Set by Different SQL Statements in <code class="literal">InnoDB</code>”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/4.1/en/mysql-cluster-faq.html#mysql-cluster-faq" target="_top">MySQL 4.1 FAQ — MySQL Cluster</a></dt><dt><a href="storage-engines.html#innodb-transaction-model" title="13.6.8. The InnoDB Transaction Model and Locking">Section 13.6.8, “The <code class="literal">InnoDB</code> Transaction Model and Locking”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">READ UNCOMMITTED</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-transactions" title="17.1.5.3. Limits Relating to Transaction Handling in MySQL Cluster">Section 17.1.5.3, “Limits Relating to Transaction Handling in MySQL Cluster”</a></dt><dt><a href="storage-engines.html#innodb-transaction-model" title="13.6.8. The InnoDB Transaction Model and Locking">Section 13.6.8, “The <code class="literal">InnoDB</code> Transaction Model and Locking”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">READ-COMMITTED</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">READ-UNCOMMITTED</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPEATABLE READ</code></h3><dl><dt><a href="storage-engines.html#innodb-record-level-locks" title="13.6.8.4. InnoDB Record, Gap, and Next-Key Locks">Section 13.6.8.4, “<code class="literal">InnoDB</code> Record, Gap, and Next-Key Locks”</a></dt><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#commit" title="12.4.1. START TRANSACTION,
COMMIT, and
ROLLBACK Syntax">Section 12.4.1, “<code class="literal">START TRANSACTION</code>,
<code class="literal">COMMIT</code>, and
<code class="literal">ROLLBACK</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-consistent-read" title="13.6.8.2. Consistent Nonlocking Reads">Section 13.6.8.2, “Consistent Nonlocking Reads”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-transactions" title="17.1.5.3. Limits Relating to Transaction Handling in MySQL Cluster">Section 17.1.5.3, “Limits Relating to Transaction Handling in MySQL Cluster”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="storage-engines.html#innodb-transaction-model" title="13.6.8. The InnoDB Transaction Model and Locking">Section 13.6.8, “The <code class="literal">InnoDB</code> Transaction Model and Locking”</a></dt><dt><a href="sql-syntax.html#xa" title="12.4.7. XA Transactions">Section 12.4.7, “XA Transactions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPEATABLE-READ</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SERIALIZABLE</code></h3><dl><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#commit" title="12.4.1. START TRANSACTION,
COMMIT, and
ROLLBACK Syntax">Section 12.4.1, “<code class="literal">START TRANSACTION</code>,
<code class="literal">COMMIT</code>, and
<code class="literal">ROLLBACK</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-consistent-read" title="13.6.8.2. Consistent Nonlocking Reads">Section 13.6.8.2, “Consistent Nonlocking Reads”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-limitations-transactions" title="17.1.5.3. Limits Relating to Transaction Handling in MySQL Cluster">Section 17.1.5.3, “Limits Relating to Transaction Handling in MySQL Cluster”</a></dt><dt><a href="storage-engines.html#innodb-locks-set" title="13.6.8.6. Locks Set by Different SQL Statements in InnoDB">Section 13.6.8.6, “Locks Set by Different SQL Statements in <code class="literal">InnoDB</code>”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="storage-engines.html#innodb-transaction-model" title="13.6.8. The InnoDB Transaction Model and Locking">Section 13.6.8, “The <code class="literal">InnoDB</code> Transaction Model and Locking”</a></dt><dt><a href="sql-syntax.html#xa" title="12.4.7. XA Transactions">Section 12.4.7, “XA Transactions”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-is.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-jointype.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top"><code class="literal">INFORMATION_SCHEMA</code> Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> <code class="literal">JOIN</code> Types Index</td></tr></table></div></body></html>
