-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Horst Scheruga wrote:
If I use the transaction isolation level of READ-COMMITTED,
I have the problems that I do not see changes to the table made
within another connection (and commited) until I call commit in my
connection.
As of my understanding this behaviour is correct for the REPEATABLE-READ
and SERIALIZABLE isolation level, but not for READ-COMMITTED.
Beside the fact that this is not the behaviour I expect,
this results in performance loss, because lots of version have to be
created if multiple users have open connections.
I tried this under Windows 2000 [Version 5.00.2195] SP 3.
(The variables and status are attached to this mail)
Thanks in advance!
Best regards
Horst Scheruga
Show variables:
Variable_name Value
[snip]
version 4.0.4-beta-max-nt
[snip]
The InnoDB storage engine shipped with MySQL-4.0.4 does not support the
READ_COMMITED isolation level, it maps it to REPEATABLE_READ. The InnoDB
storage engine that comes with MySQL-4.0.6 does support READ_COMMITTED.
The particular isolation levels that InnoDB supports, and the details of
their implementation can be found in the InnoDB manual at:
http://www.innodb.com/ibman.html
If you're using READ_COMMITTED for speed purposes, I would re-think
that, as InnoDB tables using REPEATABLE_READ are as fast or faster than
most other databases READ_COMMITTED isolation levels. For example, the
e-week benchmark where MySQL with InnoDB performed as well as Oracle,
and better than SQL Server, Sybase and DB2 was run at REPEATABLE_READ,
while every other database ran at READ_COMMITTED.
-Mark
- --
MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9+LDDtvXNTca6JD8RAu3vAJ9n6ZUWs7TyW0yTmYHGJMNZ84VElgCeIkJj
1a7CjPU/hSG0gdpzMNihTqs=
=Tpi4
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php