maria-discuss team mailing list archive

[Pavel Ivanov <pivanof@xxxxxxxxxx>]

Yes, having processlist while it's hung might be handy.

On Tue, Aug 22, 2017 at 3:45 PM, Nils Carlson <nils.carlson@xxxxxxxxxxx> wrote:
> On 08/22/2017 10:42 PM, Pavel Ivanov wrote:
>
>> Can you clarify what SHOW SLAVE STATUS blocks on for you?
>
> Not really. Basically, just after performing a failover, I run SHOW SLAVE
> STATUS on the slave and that can take up to 30 seconds sometimes before the
> query returns. Once it does return everything looks like normal. I can try
> to dump the thread status maybe.
>
> /Nils
>
>
>
>> On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson@xxxxxxxxxxx>
>> wrote:
>>>
>>> Hi Pavel and Kristian,
>>>
>>> On 08/10/2017 10:58 PM, Pavel Ivanov wrote:
>>>>
>>>> Note also that you don't want to set rpl_semi_sync_master_enabled='ON'
>>>> on all your slaves, it should be set only on the master. With the
>>>> setting your slaves' SQL threads will hang waiting for semi-sync ack
>>>> as well, and they will hang forever if
>>>> rpl_semi_sync_master_wait_no_slave is set to ON too.
>>>>
>>> Thank you.
>>>
>>>> On Wed, Aug 9, 2017 at 2:30 AM, Kristian Nielsen
>>>> <knielsen@xxxxxxxxxxxxxxx> wrote:
>>>>>
>>>>> Hope this helps,
>>>
>>>
>>> And thank you for all this!
>>>
>>> I have updated the resource-agent based on this and run some light
>>> testing.
>>> I will try to write automated tests soon.
>>>
>>> I was also wondering about one thing, the block SHOW SLAVE STATUS
>>> command.
>>> Is there any way to ensure this doesn't block? Maybe this is something to
>>> suggest to the development mailing list?
>>>
>>> Thanks again.
>>>
>>> Cheers,
>>> Nils
>>>
>>>
>>>>>    - Kristian.
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~maria-discuss
>>>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>