[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: database transactions in smsd

From: Jan Derfinak
Subject: Re: database transactions in smsd
Date: Wed, 18 Jul 2012 08:41:30 +0200 (CEST)
User-agent: Alpine 2.00 (LNX 1167 2008-08-23)

On Tue, 17 Jul 2012, alonso wrote:

Hi Alonso.

> On 07/17/2012 03:55 AM, Daniele Forsi wrote:
> > 2012/7/17 alonso acuña:
> >
> >> Hello. I am having some issues with tables getting locked for a long time,
> >> like 30 seconds while smsd is running alongside another program that also
> >> uses transactions on the outbox table. The other program is getting stuck
> > which version of smsd?
> > it should be fixed in smsd 1.5.1
> >
> >
> >
> What I was able to figure out is that the transaction and lock is held
> on the outbox table while sending the sms. In MySQL 4.1 and earlier this
> causes the entire table by locked  while in MySQL 5.0 only the
> corresponding record is lock.  So I upgraded MySQL and all is ok. 
> I think it would be worthwhile to mention somewhere in the documention
> that running the old MySQL with 2 or more smsd running and sending
> messages at the same time will not give good performance as only one
> message will be sent at a time while the others wait for the lock to be
> released.

Thanks for your research. Such things are the reason why I prefer PostgreSQL
over MySQL.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]