Actions
Bug #33532
closedTYPO3 Backend is too slow if sys_log table is large
Status:
Closed
Priority:
Must have
Assignee:
Category:
Performance
Target version:
Start date:
2012-01-30
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
A query is executed during the login process, which can take minutes during the BE login if the sys_log table is too large. Here is the analysis of the query:
mysql> explain SELECT tstamp FROM sys_log WHERE type=255 AND action=4 AND tstamp>1327922390 ORDER BY tstamp DESC limit 1; +----+-------------+---------+------+---------------+------+---------+------+----------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------+------+---------------+------+---------+------+----------+-----------------------------+ | 1 | SIMPLE | sys_log | ALL | NULL | NULL | NULL | NULL | 13319619 | Using where; Using filesort | +----+-------------+---------+------+---------------+------+---------+------+----------+-----------------------------+ 1 row in set (0.06 sec)
In the process list:
mysql> show processlist; +---------+---------------+-----------+---------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+---------------+-----------+---------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+ | 4794573 | xxx | localhost | xxx | Query | 455 | Sorting result | SELECT tstamp FROM sys_log WHERE type=255 AND action=4 AND tstamp>1327922390 ORDER BY tstamp DESC LI |
A proper index would prevent an issue.
Updated by Gerrit Code Review over 12 years ago
- Status changed from New to Under Review
Patch set 1 for branch master has been pushed to the review server.
It is available at http://review.typo3.org/8771
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/8771
Updated by Dmitry Dulepov over 12 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 561406c6ac0ab20b4b1d094cdc2f926bec1ac1b5.
Updated by Steffen Ritter over 12 years ago
- Target version changed from 1525 to 4.7.0-beta1
Updated by Riccardo De Contardi almost 7 years ago
- Status changed from Resolved to Closed
Actions