osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[placement] db query analysis


On Mon, 24 Jun 2019, Jay Pipes wrote: >> Related to that, I've started working on a nested-perfload at >> https://review.opendev.org/665695 > > Please note that there used to be fewer queries performed in the allocation 
> candidate and get resource provider functions. We replaced the giant SQL 
> statements with multiple smaller SQL statements to assist in debuggability 
> and tracing.

Yeah, I recall that and think it was the right thing to do, but now
we've reached a point where we've got limited choices for how to eke
out some more performance, which we're going to need to do to be
reasonable in > 10,000 node environments.

Being me I'm inclined towards things like infinite resource classes,
vector math, and "PUT IT ALL IN RAM !!!!!" but luckily its not up to
just me.

-- 
Chris Dent                       Ù©â??̯â??Û¶           https://anticdent.org/
freenode: cdent