Review main Abandoned

63353[WIP][BUGFIX] Add missing database indices

Jonas Eberle CR 0 V 0 Normal +70 −14 updated 10/23/23, 12:18

Commit message

Identify and remedy queries on non-indexed constraints.

When ready, this patch would contain some changes to .sql files and the
DefaultTcaSchema auto-index-generation.

Currently used commands:

Build/Scripts/runTests.sh -s functional -e "--stop-on-failure"
Build/Scripts/runTests.sh -s acceptance -e "--stop-on-failure"

After finishing these will output the file where logs were written.

Run this to see log while running tests:
  docker-compose exec mariadb10 sh -c 'tail --follow=name --retry \
    --lines=+0 /var/log/mysql/mariadb-slow.log' \
    | grep -Ei '^select.*(where|order|group by|join.*on)' \
    | grep -Ev 'tx_(expressionbuildertest|styleguide|irretutorial)|
information_schema|sys_(log|history)'

Statistics:
lines matching the filter above in slow query log:
      master: 14608
  patchset 4: 6723 (problems with postgres)
  patchset 5: 8137

Review

  • Code review CR 0

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V 0

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 4