View Issue Details

IDProjectCategoryView StatusLast Update
13882Feature requestsOtherpublic2021-03-07 20:42
Reporterollehar Assigned Toc_schmitz  
Status closedResolutionfixed 
Product Version4.0.0dev 
Target Version4.0.0dev 
Summary13882: Move all engines to InnoDB instead of MyISAM for better performance for LS4
DescriptionMove all engines InnoDB instead of MyISAM for better performance. LS4 dev.
TagsNo tags attached.




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

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';


2018-10-19 16:06

administrator   ~49374

Moving to InnoDB will severely limit the size of surveys.


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 'lime_survey_%'
GROUP BY information_schema.columns.table_name
ORDER BY count(*) desc


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


2021-03-07 20:42

administrator   ~62817

InnoDB support is now available in LS4

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
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