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