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 |
Reporter | ollehar | Assigned To | c_schmitz | ||
Priority | none | Severity | @60@ | ||
Status | closed | Resolution | fixed | ||
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. | ||||
Bug heat | 8 | ||||
Story point estimate | |||||
Users affected % | |||||
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! PS: If someone else wants to verify, to show the number of column of the tables of your surveys, you could execute this query: |
|
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 |
|
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 |