domain_traffic table growing huge

[ispcomm]

vlogger is the easy approach (very similar to a solution I wrote back in the '90s, where I had a single log file for all vhosts and a splitter that created the per-vhost files in a cron job run a night).

But I would evaluate better mod_log_sql as there are provisions in it for handling mysql server down times via a temporary local log file (pls. correct me if I'm wrong... the plan of gplhost was this). Also provisions are there for logging mail traffic.

In the above ticket I have summarized what needs to be done to reduce the size of the domain_traffic table. I have a cron job that runs at night and summarizesd data every day for any record older than 1 month. My tables went down to few hundred thousand rows. In case you need more optimization you can summarize anything older than 1 day.

ADDED: Seems thigs are little different since last time I checked the sql options. sorry for being imprecise above with pointers etc. The main idea still applies.

ispcomm.