MyISAM & InnoDB
2 posts by 2 authors in: Forums > CMS Builder
Last Post: April 6, 2012 (RSS)
By gversion - April 4, 2012
Hello,
Is it possible to configure the MySQL tables to use InnoDB rather than MyISAM, which is what appears to be the default setup of cmsBuilder?
I want to do this because InnoDB provides row level locking, as opposed to table-locking.
Thank you,
Greg
Is it possible to configure the MySQL tables to use InnoDB rather than MyISAM, which is what appears to be the default setup of cmsBuilder?
I want to do this because InnoDB provides row level locking, as opposed to table-locking.
Thank you,
Greg
Re: [gversion] MyISAM & InnoDB
By Dave - April 6, 2012
Hi Greg,
There's no automatic way to do that, and we've never tested it, but I suppose you could just change the tables and replace references in the code to 'MyISAM' with 'InnoDB'.
Another option if you anticipate more writes than reads to the database would be to look into "INSERT DELAYED ..." and "UPDATE LOW_PRIORITY ...".
Curious, what are you trying to accomplish where row-level locking would benefit?
Hope that helps!
There's no automatic way to do that, and we've never tested it, but I suppose you could just change the tables and replace references in the code to 'MyISAM' with 'InnoDB'.
Another option if you anticipate more writes than reads to the database would be to look into "INSERT DELAYED ..." and "UPDATE LOW_PRIORITY ...".
Curious, what are you trying to accomplish where row-level locking would benefit?
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com