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
