Re: DSPAM Mysql low performances and locks

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

------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-user

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlOzwSwACgkQhmBjz394AnnibwCZAazw8GB/WFz6vUEq2RhiRcVC
mw8An0z0buKObl3LJoiR9vCk5y8K8SXP
=7bvf
-----END PGP SIGNATURE-----