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