On 15.02.2012 09:19, Robert Schetterer wrote:
as workaround it should be possible to calculate filllevel
by domain with some bash script and cron sending an info mail to you
might be not exact, but enough to see whats going on ( depends on your
real domain/mailbox setup...maildir etc)
[cut]
I'm affraid that this is not a viable option. It should be done quite
often to achieve "live data" feel and the amount of I/O to do so on
storage/filesystem level is staggering.
Good enough solution will be to have an additional column in db table
with domain for each quota record. This will allow us to do something
like this:
SELECT domain, sum(bytes) as sum_bytes, sum(messages) as sum_messages
FROM used_quota GROUP BY domain
The missing domain info can be updated regularly via some cron script.
This could be a workable solution.
--
Adam Szpakowski
