Current time: 12-24-2024, 01:02 PM Hello There, Guest! (LoginRegister)


Post Reply 
domain_traffic table growing huge
Author Message
ispcomm Offline
Junior Member
*

Posts: 93
Joined: Apr 2008
Reputation: 3
Post: #7
RE: domain_traffic table growing huge
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.
(This post was last modified: 05-16-2008 04:14 AM by ispcomm.)
05-16-2008 04:09 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: domain_traffic table growing huge - ispcomm - 05-16-2008 04:09 AM

Forum Jump:


User(s) browsing this thread: 5 Guest(s)