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