[CDBI] Use with mod_perl caching question

Perrin Harkins perrin at elem.com
Thu Dec 13 17:20:01 GMT 2007


On Dec 13, 2007 11:50 AM, Berg, Eric <eric.berg at lehman.com> wrote:
> The problem that I'm having is that my cdbi mods in some of the apache
> instances are returning stale data in response to these requests.

If you're using InnoDB, check your isolation level as described here:
http://perl.apache.org/docs/1.0/guide/databases.html#Transactions_Not_Committed_with_MySQL_InnoDB_Tables

If not try turning off the object index:
http://wiki.class-dbi.com/wiki/Common_problems#Old_data_due_to_object_index

- Perrin



More information about the ClassDBI mailing list