Re: Weird SQL Results

2009-09-01 Thread Tachu®
(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

Weird SQL Results

2009-09-01 Thread Tachu®
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 differe