Commit graph

2 commits

Author SHA1 Message Date
Eric Lippmann
272e791390 License source files as GPL-3.0-or-later
Add SPDX license headers and mark source files as GPL-3.0-or-later to
preserve the option to relicense under later GPL versions.
2026-03-11 14:03:05 +01:00
Eric Lippmann
402131ad72 Allow disabling the MySQL/MariaDB query optimizer for history queries
Some checks are pending
L10n Update / update (push) Waiting to run
CI / PHP (push) Waiting to run
Some versions of these RDBMS perform poorly with history queries, particularly
when the optimizer changes join order or uses block nested loop joins. Ideally,
testing across all RDBMS versions to identify when the optimizer fails and
adjusting queries or using optimizer switches would be preferable, but this
level of effort is not justified at the moment.

Optimizer is disabled via config:

`/etc/icingaweb2/modules/icingadb/config.ini`:

```
[icingadb]
...
disable_optimizer_for_history_queries=1
```
2026-03-11 10:48:05 +01:00