Paul Stevens wrote:
Being unable to move back to postgres I had to sweat it out. Not so much it seemed: adding a sloth of indexes to the main tables solved all performance issues I had. Using innodb I decided to add foreign key contraints, and dbmail now feels very snappy indeed. Load now hovers below 0.1 :-)
Hi Paul, I've been suffering with innodb performance with dbmail, and I'm mostly clueless on how to tweak innodb to get some decent performance. If you could post what you did, it would be greatly appreciated. References to what docs you leaned this high magic from would also be appreciated. -- Lost in Tokyo, Keith