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

[Dan Kegel]

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?