Project

General

Profile

Actions

Bug #89846

closed

Missing database indices

Added by Jonas Eberle over 4 years ago. Updated 7 months ago.

Status:
Rejected
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2019-12-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
Tags:
SQL index indices
Complexity:
Is Regression:
Sprint Focus:

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

Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Task #88896: Add index to slug fieldClosed2019-08-02

Actions
Related to TYPO3 Core - Bug #89853: Add index on new l10n_source fieldClosed2019-12-05

Actions
Actions

Also available in: Atom PDF