Issue Bug Closed

#22986Slow query in sys_history due to missing key on tstamp / tablename

Christian Kuhn 06/24/10, 14:11 updated 10/02/18, 12:23

Description

  1. Time: 100624 8:35:03
  2. User@Host: foo[bar] @ localhost []
  3. 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.