-----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]
[snip]version 4.0.4-beta-max-nt
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
