* David F. Skoll <d...@roaringpenguin.com>: > On Fri, 29 Jul 2011 22:41:18 +0200 > Patrick Ben Koetter <p...@state-of-mind.de> wrote: > > That's ~230 msg/sec. Ever took it to 500 msg/sec? > > No, we lack the hardware to do that. The 230 msgs/sec rate was > reached by a customer with a lot more money for hardware than we have. :)
Isn't that the way it always is? ;) > (I don't think Bayes will be the limiting factor even at 500 msgs/sec, > but I don't know for sure.) I talked to someone the other day who uses reasonably powerful hardware and the said in their cluster storing Bayes tokens live topped out at about 200 msg/sec when they were using MySQL. I didn't investigate any further, so I can't tell if they started tuning and which optimizations they tried. Writing transaction log seems to be a slowing candidate to me, but I am no DB specialist either to tell if that is true. p@rick -- state of mind () http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563