View Issue Details

IDProjectCategoryView StatusLast Update
13824Feature requests[All Projects] Installationpublic2018-07-24 11:48
Reporteryniquet Assigned To 
PrioritynoneSeverityfeature 
Status newResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary13824: installing with innodb
Description

Is it possible to have a delivery date for having the choice between innodb and myisam during the installation?
I can change to innodb after installation, but when we create a survey with participant the table is create with myisam...
And the synchronization on mariadb cluster don't work with myisam.

Thank's

TagsNo tags attached.

Activities

danigri

danigri

2018-07-12 17:56

reporter   ~48500

+1
I always have to change table engine to InnoDB and "hack" the scripts to create new tables in InnoDB because of the same issue

rbaier

rbaier

2018-07-17 14:00

reporter   ~48520

To change the table engine fom MyISAM to InnoDB you can edit the file <LS-root dir>/application/core/db/MysqlSchema.php
You will have to repeat this step each time after installing a LimeSurvey update.

yniquet

yniquet

2018-07-19 17:38

reporter   ~48536

it does not solve the problem, since limesurvey create tables in myisam when adding participant, surveys etc.
And even with innodb we have problems of integrity. Finally we installed on MySQL on single server.

rbaier

rbaier

2018-07-23 10:00

reporter   ~48547

I cannot confirm this. We have used this method for years and the tables created by LimeSurvey always were of type InnoDB.
In Version 2.05 you had to set the engine type (InnoDB) in application/config/config.php. In LS versions >2.5 the relevant file is application/core/db/MysqlSchema.php.

yniquet

yniquet

2018-07-23 17:45

reporter   ~48550

rbaier please, can you confirm to me that you use mariadb on galera cluster

rbaier

rbaier

2018-07-24 11:48

reporter   ~48563

yniquet, we do not use mariadb on galera cluster, just plain mysql.

Issue History

Date Modified Username Field Change
2018-06-27 15:45 yniquet New Issue
2018-07-12 17:56 danigri Note Added: 48500
2018-07-17 14:00 rbaier Note Added: 48520
2018-07-19 17:38 yniquet Note Added: 48536
2018-07-23 10:00 rbaier Note Added: 48547
2018-07-23 17:45 yniquet Note Added: 48550
2018-07-24 11:48 rbaier Note Added: 48563