Issue Feature Closed

#25386Index over sys_log event_pid for "order by page" in syslog view

René 03/24/11, 15:00 updated 03/03/17, 14:22

Description

Hi.

we’ve noticed some real time expensive querys on the syslog table under some circumstances.

If we show many entrys from sysprotocol and activate “order by page” the folowing index would speed up the query extremly.

the syslog index “event” has the userid appended and will not match.

ALTER TABLE `sys_log` ADD INDEX `sortedPages` (`event_pid`);

(issue imported from #M18027)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.