View Issue Details

IDProjectCategoryView StatusLast Update
13882Feature requests[All Projects] Otherpublic2018-10-22 12:05
ReporterolleharAssigned To 
PrioritynoneSeverity@60@ 
Status newResolutionopen 
Product Version4.0.0dev 
Target Version4.0.0devFixed in Version 
Summary13882: Move all engines to InnoDB instead of MyISAM for better performance for LS4
Description

Move all engines InnoDB instead of MyISAM for better performance. LS4 dev.

TagsNo tags attached.

Activities

ptramonti

ptramonti

2018-10-18 17:20

reporter   ~49361

We too have this problem because the mysql MariaDB Galera Cluster replication works only with InnoDB storage engine, see
https://mariadb.com/kb/en/library/mariadb-galera-cluster-known-limitations/

For now we have manually modified the \application\core\db\MysqlSchema.php file and set the engine option on row 18:

$options = 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';

c_schmitz

c_schmitz

2018-10-19 16:06

administrator   ~49374

Moving to InnoDB will severely limit the size of surveys.

ptramonti

ptramonti

2018-10-22 09:27

reporter   ~49398

The limit of InnoDB to which you refer, I think it's the maximum number of columns, which if I'm not mistaken is 1017 (vs 4096 of MyISAM). In our case, with about 500 questionnaires (someone very very complex), we never exceeded 400 columns.

In our case with MariaDB Galera cluster we are forced to choose InnoDB, MyIsam is not supported!
IMHO I think that at least it should be given the opportunity to choose the engine when installing LimeSurvey!

PS: If someone else wants to verify, to show the number of column of the tables of your surveys, you could execute this query:
SELECT information_schema.columns.table_name, count() AS Columns
FROM information_schema.columns
WHERE information_schema.columns.table_name like 'limesurvey%'
GROUP BY information_schema.columns.table_name
ORDER BY count(
) desc

DenisChenu

DenisChenu

2018-10-22 12:05

developer   ~49403

Yes, MyISAM DB column içn real survey is more limited to something around 700/800 with single choice + text question

Issue History

Date Modified Username Field Change
2018-07-18 12:02 ollehar New Issue
2018-07-18 12:03 ollehar Summary Move all engines InnoDB instead of MyISAM for better performance => Move all engines to InnoDB instead of MyISAM for better performance for LS4
2018-07-18 12:03 ollehar Description Updated View Revisions
2018-10-18 17:20 ptramonti Note Added: 49361
2018-10-19 16:06 c_schmitz Note Added: 49374
2018-10-19 16:06 c_schmitz Project Bug reports => Feature requests
2018-10-22 09:27 ptramonti Note Added: 49398
2018-10-22 12:05 DenisChenu Note Added: 49403