View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
13882Feature requestsOtherpublic2021-03-07 20:42
Reporterollehar Assigned Toc_schmitz  
PrioritynoneSeverity@60@ 
Status closedResolutionfixed 
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.
Bug heat8
Story point estimate
Users affected %

Users monitoring this issue

ptramonti

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

c_schmitz

c_schmitz

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
2018-10-18 17:20 ptramonti Note Added: 49361
2018-10-18 17:21 ptramonti Issue Monitored: ptramonti
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
2021-08-02 16:34 guest Bug heat 6 => 8