Issue Bug Rejected

#89846Missing database indices

Jonas Eberle 12/04/19, 14:52 updated 10/23/23, 12:19

Description

While checking https://review.typo3.org/c/Packages/TYPO3.CMS/+/62532 I found some more missing indices.

I’ll happily take care of this and keep this open until the release of 10 LTS.

Minimal test setup:

  # use introduction package as test base
  composer req typo3/cms-introduction
  ddev exec -s db sh <<< "mysql -e 'SET GLOBAL log_queries_not_using_indexes=ON;'"
  ddev logs -s db -f
  # crawl frontend
  wget \
                                -nv -e robots=off -R.css,.js,.jpg,.png,.pdf -nd -r \
                                --delete-after --level=5
  # run backend acceptance tests (mariadb)
  /Build/Scripts/runTests.sh -s acceptance
  # run functional tests with different DB systems  # ignores mssql|postgres|sqlite
  /Build/Scripts/runTests.sh -s functional mariadb
  /Build/Scripts/runTests.sh -s functional mysql55

Reviews 1