From: Lawrence Sorrillo (sorrillojlab.org)
Date: Tue Sep 01 2009 - 13:30:58 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]