On 04/06/16 06:07, Marco wrote:
> Hello,
> 
>   days ago I switched from MySQL5.6 to MySQL5.7, fresh DB, InnoDB,  
> dspam with TOE.
> 
> DSPAM stops to work for a tons of "lock wait timeout". Back to MySQL  
> 5.6 and DSPAM returns to work greatly. No differences on hardware and  
> resources. Only the DBMS engine changed.
> 
> I think that MySQL5.7 introduces something that DSPAM doesn't like.  
> Does anyone experience this problem?


Honestly, if you're seeing lock wait timeouts the first thing to do is
check for a tuning problem.  This includes making sure you aren't using
MyISAM tables.


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

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to