Juju Charms Collection
limesurvey package

limesurvey should use InnoDB by default

Bug #900172 reported by Clint Byrum
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
limesurvey (Juju Charms Collection)
Triaged
Medium
Unassigned

Bug Description

./config-defaults.php:$databasetabletype = 'myISAM'; // Storage engine mysql should use when creating survey results tables and token tables (if mysql is used). Default is myISAM.

MyISAM is *horrible* for concurrency, as it uses a table lock whenever a table changes. InnoDB is plenty fast and far more suited to modern scale-out use cases.

Revision history for this message
Nick Barcet (nijaba) wrote :

Just added an option for it to be settable in the config (and a few other things too). It's in merge proposal.

Nick Barcet (nijaba)
Changed in limesurvey (juju Charms Collection):
status: New → Fix Committed
Revision history for this message
Clint Byrum (clint-fewbar) wrote :

This unfortunately has regressed with the latest upstream release of limesurvey, we'll have to alter the tables manually.

Changed in limesurvey (Juju Charms Collection):
status: Fix Committed → Triaged
importance: Undecided → Medium
Revision history for this message
Tom Misilo (tmisilo) wrote :

I am using Version 2.05+ Build 150413

However I cannot find the option $databasetabletype in config-defaults.php. Would it be in another file?

Thanks!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.