- Posts: 409
- Thank you received: 34
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Forcing InnoDB over MyISAM
- blocka
- Topic Author
- Offline
- Platinum Member
Less
More
6 years 9 months ago - 6 years 9 months ago #156072
by blocka
Forcing InnoDB over MyISAM was created by blocka
I'm implementing data encryption at rest with mariaDB, and thus I require that all tables be created as InnoDB, instead of myISAM.
When I activate a survey, the response table is created as myISAM. I can see in MysqlSchema.php that the option for myISAM is hard coded into the createTable function.
While I can hack this of course, it won't persist across a future ComfortUpdate. While I could chattr the file to protect it from updates, it would be preferable if there was a config option to determine which database engine should be used.
The function looks like it could accept options:
But I don't see where I could set this.
Any ideas?
When I activate a survey, the response table is created as myISAM. I can see in MysqlSchema.php that the option for myISAM is hard coded into the createTable function.
While I can hack this of course, it won't persist across a future ComfortUpdate. While I could chattr the file to protect it from updates, it would be preferable if there was a config option to determine which database engine should be used.
The function looks like it could accept options:
Code:
public function createTable($table, $columns, $options = null) { if(empty($options)) { $options='ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'; }
But I don't see where I could set this.
Any ideas?
Last edit: 6 years 9 months ago by blocka.
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
6 years 9 months ago #156320
by ollehar
Replied by ollehar on topic Forcing InnoDB over MyISAM
Feel free to construct a pull request with this feature.
The topic has been locked.
- TonisOrmisson
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 22
- Thank you received: 4
5 years 11 months ago #167649
by TonisOrmisson
Replied by TonisOrmisson on topic Forcing InnoDB over MyISAM
The topic has been locked.
- dday01
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
5 years 22 hours ago #182405
by dday01
Replied by dday01 on topic Forcing InnoDB over MyISAM
Hi,
the is solved?
there are versions that don't have this problem?
the is solved?
there are versions that don't have this problem?
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
5 years 19 hours ago #182414
by jelo
The feature offered by Tonis is not merged into the codebase of LimeSurvey.
You can follow the discussion via the link already posted by Tonis.
github.com/LimeSurvey/LimeSurvey/pull/1043
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Forcing InnoDB over MyISAM
dday01 wrote: Hi,
the is solved?
there are versions that don't have this problem?
The feature offered by Tonis is not merged into the codebase of LimeSurvey.
You can follow the discussion via the link already posted by Tonis.
github.com/LimeSurvey/LimeSurvey/pull/1043
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.