#22986Slow query in sys_history due to missing key on tstamp / tablename
Description
- Time: 100624 8:35:03
- User@Host: foo[bar] @ localhost []
- Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM sys_history WHERE tstamp1274769300 AND tablename='tt_news';
Create new key on tstamp + tablename, or change existing key combination / code
Initiated by:
t3lib/class.t3lib_tcemain.php
function clearHistory($maxAgeSeconds=604800,$table) {
(issue imported from #M14852)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.