Am 02.07.2014 10:00, schrieb Marco:
> 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
>
> [07/02/2014 09:28:35] 32082: Lock wait timeout exceeded; try
> restarting transaction: UPDATE dspam_token_data SET
> last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=715
> AND token IN
> ('5719708924817070673','15748594722301702351','12523852096982625759','15747193994780569807','7072984635321818198','8566666067201058025','3214617105374076928','667817407838676578','2746530540300936818','7855920995652397412','5465147151345906752','5252602293815960809','12797608577848435519','7966374547679573945','12661687167322745101','1476367451104814719','15905813578389094591','7592741750694013197','15748943523967104959',
>
> Could you help me to improve db performances?http://mysqltuner.com/ would be a good start in case of innodb you should have a lot of RAM and in the best case your whole dataset fit into innodb_buffer_pool_size
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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
