View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|13882||Feature requests||Other||public||2018-07-18 12:02||2021-03-07 20:42|
|Summary||13882: 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.|
|Tags||No tags attached.|
We too have this problem because the mysql MariaDB Galera Cluster replication works only with InnoDB storage engine, see
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';
|Moving to InnoDB will severely limit the size of surveys.|
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
WHERE information_schema.columns.table_name like 'lime_survey_%'
GROUP BY information_schema.columns.table_name
ORDER BY count(*) desc
|Yes, MyISAM DB column içn real survey is more limited to something around 700/800 with single choice + text question|
|InnoDB support is now available in LS4|
|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|
|2021-03-07 20:42||c_schmitz||Assigned To||=> c_schmitz|
|2021-03-07 20:42||c_schmitz||Status||new => closed|
|2021-03-07 20:42||c_schmitz||Resolution||open => fixed|
|2021-03-07 20:42||c_schmitz||Note Added: 62817|