RE: [PHP-WIN] MySQL-max and transaction isolation level ?
| From: | HKG) | Date: | Mon, 15 Apr 2002 09:16:41 +0000 |
| Subject: | RE: [PHP-WIN] MySQL-max and transaction isolation level ? | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-13098@lists.php.net to get a copy of this message | ||
> transaction-isolation= READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ,
> SERIALIZABLE
>
> But what does each of these mean?
A short table for things that are allowed
under different transacation levels:
Level a b c
-----+-+-+-+
UNCOM|Y|Y|Y|
-----+-+-+-+
COMIT|N|Y|Y|
-----+-+-+-+
REPAT|N|N|Y|
-----+-+-+-+
SERIL|N|N|N|
-----+-+-+-+
a = dirty read
b = non-repeatable reads
c = phantoms