Task #29279
closed
Add some index to sys_log
100%
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)
Updated by Andreas Wolf over 12 years ago
- Complexity set to easy
Could you try if adding the proposed index would help in your situation? I.e. if it really improves speed with having that many entries in sys_log? And it would be great if you could provide a patch then.
Updated by Oliver Hader over 12 years ago
- Status changed from New to Accepted
- Target version set to 4.7.0
- PHP Version set to 5.3
Updated by Mr. Jenkins over 12 years ago
- Status changed from Accepted to Under Review
Patch set 1 of change I1b8d27b6ce1352c03e70d67c3df54ec827e9e21a has been pushed to the review server.
It is available at http://review.typo3.org/6864
Updated by Gerrit Code Review over 12 years ago
Patch set 2 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/6864
Updated by Steffen Ritter about 12 years ago
- Tracker changed from Bug to Task
database changes won't happen after Feature Freeze. Therefore postponed to the next major version.
Updated by Mario Rimann almost 12 years ago
The proposed change was just abandoned during the review process, see https://review.typo3.org/#/c/6864/
Can please one of the core-devs with the needed permissions and insight mark this issue accordingly? (close it IMHO)
Updated by Chris topher almost 12 years ago
- Status changed from Under Review to Closed
- % Done changed from 0 to 100
This query is no longer executed with the new log module.