On 07/02/14 04:00, Marco wrote:
> Hello,
>   I have a slow performance on my dspam-mysql conf. The purge nightly  
> script take 7-12 hours to complete. During this time I see a lot of  
> locks

First and most obvious question:  Are your tables InnoDB or MyISAM?
MyISAM should not be used in any production DB unless you absolutely
require MyISAM features not supported by InnoDB.


-- 
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: 603.293.8485

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to