Improve syslog output performance

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.