disable 2nd level cache, enable foreign key indexing