Re: DSPAM Mysql low performances and locks
Phil Stracchino <[email protected]>
| Newsgroups | gmane.mail.spam.dspam.user |
|---|---|
| Organization | Babylon Communications |
| Message-ID | <[email protected]> |
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 [email protected] [email protected] 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