[users at bb.net] slow reconfig with mysqld?

[Dan Kegel]

Reran reconfig just now, and it took less than 2 minutes, as expected.

Why the heck did it take an hour last time?


On Tue, Jul 17, 2018 at 9:07 PM, Dan Kegel <dank at kegel.com> wrote:
> Any guesses how long the reconfig took?
>
> Scroll down to see:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 2018-07-17 18:10:51-0700 [-] reconfig is ongoing for 3180 s
>
> OMG.
>
> On Tue, Jul 17, 2018 at 5:32 PM, Dan Kegel <dank at kegel.com> wrote:
>> Hi all,
>> I finally switched to mysqld instead of sqlite
>> when I made the leap to buildbot 1.x.
>> At first it was much faster.
>>
>> Now, though.... 'buildbot reconfig' has been running for 900 seconds
>> and still isn't done.  ps shows:
>>
>>   PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+
>> COMMAND
>> 26049 mysql     20   0 2404832 220032   6992 S 161.1  2.7 285:11.00
>> mysqld
>> 25662 buildbot  20   0 4636132 3.019g  10932 S  24.9 38.7 202:59.14
>> python3
>>
>> Seems like I've run into a gotcha.  Do I have to reframbulate the
>> primary cryptokey tv tables in mysqld or sommat?