On Wed, Nov 11, 2009 at 12:58 AM, Nigel Kukard <[email protected]> wrote:
> > Hey, > > > > Is it possible to change the Storage engine of tables namely > > "quotas_tracking" & "session_tracking" > > & Would the change hamper the performance of Cluebringer ? I think it > > would. > > > > Reason I'm asking is both tables are using FOREIGN KEYS which aren't > > supported by MEMORY Engine in MySQL. > > > > Also is there any workaround ( apart from keeping the storage engine > > to InnoDB ) ? > > Try removing the foreign keys from the schema and trying with the memory > engine. > Yes It worked, as I said converting it wasn't a problem, also noticed 1 more thing with "session_tracking" table which has a cloumn "RecipientData" which has data type "text" which isn't supported by MEMORY engine. I might as well use varchar similar to other columns. I would like to know will there be any performance issues with cluebringers because of missing FOREIGN KEY ? Please suggest. - Manish
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
