mysql> select version();
+----------------------+
| version() |
+----------------------+
| 5.1.30-community-log |
+----------------------+
1 row in set (0.00 sec)
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
On Sep 1, 2009, at 11:30 AM, Lawrence Sorrillo wrote:
Are you doing the insert and the select in different sessions, ie
different connections to the server(different terminals)?
This might simply be an intended symptom of isolation levels and
InnoDB MVCC(multi versioning concurrency control).
In addition, can you tell us what you get from:
mysql> select version();
mysql> select @@tx_isolation;
Thanks.
Tachu® wrote:
I'm having some weird issues that might be common but im not sure.
I have a very write intensive innodb table that sometimes i do an
insert and then do a select for the row i just inserted and it wont
show up. this is on the same host its not replication lag but on
the same host. on different transaction. Is this a know issue? is
there something i can do to prevent this??
Thanks
T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org