At 02:48 PM 7/1/2005, you wrote:
YMMD, but 'fopen()', a fast, hash-driven, seek (the way 'cdb' works)
and a quick 'read' for a few bytes should be less overhead than a
complete SQL query, including parsing the result. Even if your MySQL
would run locally and accessed through UNIX-socket I'd expect it to be
not only more overhead, but also taking more time than this quick
local, read-only, precise access in a small file.
But it's your system, whatever makes you happy and serves your needs
can be your solution.
N.B.: Number of authentication should not play a role in accessing
your cdb-file, if you're configured vpopmail to only use MySQL the cdb
will be as static as your kernel: unless *you* change it, it won't
change.
Well, earlier this morning i 'turned off' my
rcpthosts/morercpthosts files, leaving it to mysql to handle the
relay status for the three MXes and the proxy server (as i mentioned,
i simply added a record for each server's IP, with a timestamp ten
years in the future, so they won't get 'aged' out).
I've seen no discernable in my mysql query rate since then - at least
nothing obvious in my graphs i suspect (though being an utter mysql
newbie) that the large query cache i've created (48 megs) is allowing
those queries to be handled out of cache.
my query rate generally runs at an average of 23 qps, with peaks
occasionally to 100 qps or more. but that presents less of a load
than the webmail and imap clients.
Paul Theodoropoulos
http://www.anastrophe.com
http://www.smileglobal.com
