Hello Andreas,
Thursday, February 01, 2001, 7:42:31 PM, you wrote:
I must confirm the problem with table locks. Mysql realy may deadlock
sometimes, and the funny thing is the solution to this case is to kill
the oldest locked thread waiting this condition - afterwards
everything resolves. So this may mean something like broadcast is lost
sometimes (?)
AS> On 01-Feb-2001 Sinisa Milivojevic wrote:
>>
>> HI!
>>
>> Most probably processes are waiting for the slave to get updated.
>>
>> To circumvent the problem, you should :
>>
>> - use our binary (if possible)
>>
>> - avoid LOCK TABLES, which truly is necessary only in some rare cases
>>
>>
>>
>> Regards,
>>
>> Sinisa
>>
>> ____ __ _____ _____ ___ == MySQL AB
>> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
>> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
>> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
>> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
>> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
>> /*/ \*\ Developers Team
>>
AS> Actually I did avoid using lock tables but got hit by this problem. Thus I
AS> tried with lock tables.
AS> Using supplied binaries is no choice as for certain reasons all systems
AS> involved are completely built from source.
AS> I can't really see a reason why a slave being updated should lock the master
AS> for good. Nevertheless there's just one programmable switch between the master
AS> and the slaves involved and the network speed is 200MBits/s (channel bonding) so
AS> this can't really be the reason for the problem.
AS> If I can do anything to help to sort this out I'll happily do so.
AS> Andreas Steinmetz
AS> D.O.M. Datenverarbeitung GmbH
AS> ---------------------------------------------------------------------
AS> Before posting, please check:
AS> http://www.mysql.com/manual.php (the manual)
AS> http://lists.mysql.com/ (the list archive)
AS> To request this thread, e-mail <[EMAIL PROTECTED]>
AS> To unsubscribe, e-mail <[EMAIL PROTECTED]>
AS> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
