Task #79696: Better index on sys_log - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Task #79696

closed

Better index on sys_log

Added by Thomas Hohn about 7 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Thomas Hohn

Category:

Database API (Doctrine DBAL)

Target version:

8 LTS

Start date:

2017-02-08

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

7.0

Tags:

Complexity:

Sprint Focus:

Stabilization Sprint

Description

Looking at the selects performed on sys_log in the core
of TYPO3 reveals that a combination of@ tstamp, type, userid@
should give a better performance for at least 2 SQL
statements. One performing a full-table scan - the other
approximately half a full-table scan.

On installations where a few users have created a lot of entries
in sys_log the existing indexes event and user_auth will return
too many rows compared to the new combined index.

Related issues 1 (0 open — 1 closed)

Actions

Copy link

Updated by Gerrit Code Review about 7 years ago

Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595

Actions

Copy link

Updated by Gerrit Code Review about 7 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595

Actions

Copy link

Updated by Thomas Hohn about 7 years ago

Subject changed from Timestamp better index on sys_log to Better index on sys_log
Description updated (diff)

Actions

Copy link

Updated by Thomas Hohn about 7 years ago

Description updated (diff)

Actions

Copy link

Updated by Gerrit Code Review about 7 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595

Actions

Copy link

Updated by Gerrit Code Review about 7 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595

Actions

Copy link

Updated by Gerrit Code Review about 7 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51595

Actions

Copy link