MySQL Deadlocks

Forum to discuss Optimizations and Implementation of threads connections for SMTP

MySQL Deadlocks

Postby joshseide » Mon Nov 16, 2015 3:13 pm

We are seeing this constantly from the multithread addon, its slowing down our sending engine, please advise what we can do:

------------------------
LATEST DETECTED DEADLOCK
------------------------
2015-11-16 12:30:26 7f4c8c65a700
*** (1) TRANSACTION:
TRANSACTION 34643967637, ACTIVE 10 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 6
MySQL thread id 5800435, OS thread handle 0x7f4c7d9f9700, query id 74782359 XXX,XXX,XXX,XXX interspire updating
UPDATE email_addon_mta_stats SET value=value+500, extra='' WHERE `mta_uid`=620 AND `time`='1447693200' AND `type`='sent'
joshseide
 
Posts: 1
Joined: Mon Nov 16, 2015 3:09 pm

Re: MySQL Deadlocks

Postby mmm » Wed Nov 18, 2015 4:13 pm

optimize you MySQL settings (see forum posts here)

make sure you have InnoDB tables separate

go MariaDB
mmm
 
Posts: 106
Joined: Sat Apr 11, 2015 4:36 pm


Return to Multithreading

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest