Re: [exim] mysql + stats logging

Pàgina inicial
Delete this message
Reply to this message
Autor: Jan-Piet Mens
Data:  
A: Ronan McGlue
CC: exim-users
Assumpte: 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