#29279Add some index to sys_log
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)