Issue Task Closed

#29279Add some index to sys_log

Robert Heel 08/26/11, 17:45 updated 07/02/12, 16:42

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)

Reviews 1