Re: Object caching in a mod_perl application

[prev] [thread] [next] [Date index for 2005/03/17]

Jim Mozley wrote:

> One other email I've come across also asked if the poster was using 
> InnoDB tables. I am and wondered if there was a particular issue with 
> these?

It could be. By default MySQL with InnoDB has a slighly non-intuitive 
transaction isolation level, 'REPEATABLE-READ'. It means that other 
processes cannot seen data, even committed data, until they themselves 
perform a commit.

I normally use 'READ-COMMITED' which means that as soon as one process 
commits the change, any other can see it. I saw your update() call but 
did not see where you committed, so this may or may not help.

        -- 
        Michael Peters
Developer
Plus Three, LP