Re: [exim] mysql + stats logging

On Wed Feb 15 2006 at 13:06:24 CET, Ronan McGlue wrote:

> I am toying with the idea of adding a router for all accepted messages
> to our system which will initally simply increment a counter in a mysql
> DB. ie to get hourly stats of all messages through system. we recieve
> 100k mails a day. Is this the prefered way to get real time stats,
> will it have much of a performance hit? Does anyone currently do this ,
> or something siliar.

I have this at the top of the data ACL:

   warn condition = ${lookup \
                mysql {insert into accounting SET \
                   msgid='${message_id}', \
                   size=${message_size}, \
                   nrecpt=${recipients_count}, \
                }{0}{0}}

You'd need to change the SQL to suit your needs.

Regards,
    -JP