2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
2
Hi! Thanks for the question and posting the details of you research. Seems this indeed is a defect in the configuration system. We are researching it with the goal of having it fixed in the next RDS for MariaDB 10.4 series release.
Meanwhile, we tested that the following workarounds can successfully turn off the rowid_filter, which you can use before a fix is available:
Either ONE of the following would work. Note: 1st approach only needs to be done once, while the 2nd approach affects only the current session and needs to repeat for every time a session starts.
1. Set the ‘init_connect’ in parameter group to SET optimizer_switch="rowid_filter=off"
mysql> show variables like 'init_connect';
+---------------+-----------------------------------------+
| Variable_name | Value |
+---------------+-----------------------------------------+
| init_connect | SET optimizer_switch="rowid_filter=off" |
+---------------+-----------------------------------------+
2. Alternatively, after logging into a session, set the session optimizer_switch parameter with rowid_filter=off.
mysql> set @@session.optimizer_switch="rowid_filter=off";
답변함 2년 전
0
Any further update if it had been fixed? I understand "workaround", but it only changes the setting for the current session, which i can not control through the application.
답변함 2년 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전