Mark Mackay - Orcon wrote:
Biggest problem for me at the moment is MySQL tuning. We keep 'running out
of thread memory' and I can't seem to find the right mysql config settings
to solve it. I'm certain MySQL will handle more connections; but I suspect
I'm going to have to pay for the mysql.com to 'optimize' my database so it
hums along.
Ever think about trying postgresql? It is my understanding that it
scales up better with lots of concurrent access. Anyone have any good
experience comparing the two for dbmail?
We recently had a problem with quota calculations taking too long to
calculate; although we are running an older version so this may be fixed. I
simply disabled the quota calc (added 2 lines in the code) and substantially
reduced the database CPU.
I think a config option should be added to dbmail to disable quota
calcs. It does considerably add to the load unnecessarily if not being
used, and adds an update statement to the user table ever message insert.
