1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 不同版本似乎应用了不同的优化方法。行ID过滤是MariaDB 10.4.3+提供的优化方法,因此请禁用“rowid_filter”优化器开关,并重新发出查询。执行命令SET SESSION optimizer_switch='rowid_filter=off';
,然后再发出查询。详细信息请参见以下链接:https://mariadb.com/kb/en/rowid-filtering-optimization/以及https://mariadb.com/kb/en/server-system-variables/#optimizer_switch。
Relevant content
- asked a year ago
- asked a year ago
- Accepted Answerasked 10 months ago
- How do I resolve the storage full issue on my RDS for MySQL instance or my RDS for MariaDB instance?AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago