cyrus imap + mysql as backend db ?
rjs3 at andrew.cmu.edu
Tue Nov 4 14:09:25 EST 2003
On Tue, 4 Nov 2003, [ks_c_5601-1987] 원태환 wrote:
> I am considering to add mysql support as a backend of mboxlist DB.
> I have used skiplist and Berkeley DB so far.
> All of them have a serious contention problem.
> But, I want to know if it is a valuable work .
I'm not sure what you mean by "a serious contention problem." Many sites
use skiplist quite successfully.
The access paterns against a cyrusdb don't map well to SQL -- in many
cases we enumerate the entire database (or a large portion of it), and
pull results at a higher level. I suspect you'll see more performance
problems with a SQL backend (due to I/O) than you will with the memory
mapped skiplist database (or a properly tuned Berkeley DB)
Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456
Research Systems Programmer * /usr/contributed Gatekeeper
More information about the Info-cyrus