>>>>> "Jocelyn" == Jocelyn Fournier <joc@stripped> writes:
Jocelyn> I want to sum up here the problems I encounter with insert delayed thread.
>> From time to time (quite rare, but I reproduced the problem on several
Jocelyn> servers), the insert delayed thread seems to "lock" the table. (all process
Jocelyn> are in "waiting for the table" state)
>> DESTRUCTOR CALLED ; delayed_insert_threads : 42
>> dest Mutex addr : 141851908
>> pthread_handler_decl (end:), destructor called mutex addr 147339436;
>> delayed_insert_threads : 0
>> DESTRUCTOR CALLED ; delayed_insert_threads : 0
Jocelyn> It seems something reinitialize delayed_insert_threads between the 141851908
Jocelyn> mutex and the 147339436.
This is very strange; As you said it's only in the
constructor/destructor delayed_insert_threads are changed.
ok, finally found and tracked down this long time bug...
It was wrongly reset on 'FLUSH STATUS'
Will push the fix into 3.23 and 4.0 today.
(This will not fix the waiting for tables problems, for this we need
another test case)
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <monty@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland