Details
-
Improvement
-
Resolution: Fixed
-
Minor
-
None
-
Professional Edition
-
None
Description
Output of syslog entries is very slow due to the fact that query
SELECT DISTINCT `priority` FROM `syslog` WHERE 1 AND `device_id` = '762';
can not use a index
alter table syslog add key device_id_priority (device_id,priority);
makes that a lot better.