Project

General

Profile

Actions
Copy link

Task #29279

closed

Add some index to sys_log

Added by Robert Heel over 12 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2011-08-26
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.3
Tags:
Complexity:
easy
Sprint Focus:

Description

We had installed some buggy extensions which logged many error messages to sys_log. At a table size with >2GB, login and other actions go really slow, because querys like

SELECT *
FROM sys_log
WHERE TYPE =255
AND ACTION =3
AND error !=0
AND tstamp >1314368011
ORDER BY tstamp

have to search the whole table. Perhaps add a tstamp index
ALTER TABLE sys_log ADD INDEX (tstamp)

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Feature #25386: Index over sys_log event_pid for "order by page" in syslog viewClosed2011-03-24

Actions
Actions
Copy link

Also available in: Atom PDF