Tuesday, 2019-06-18

*** Sundar has quit IRC01:12
*** takashin has joined #openstack-placement01:19
*** zzzeek has quit IRC05:07
*** zzzeek has joined #openstack-placement05:08
*** e0ne has joined #openstack-placement05:44
*** e0ne has quit IRC06:26
*** e0ne has joined #openstack-placement06:36
*** e0ne has quit IRC07:13
*** helenafm has joined #openstack-placement07:27
*** tssurya has joined #openstack-placement07:55
*** takashin has left #openstack-placement08:00
openstackgerritChris Dent proposed openstack/placement master: WIP: Nested performance testing  https://review.opendev.org/66569508:12
*** tetsuro has joined #openstack-placement08:14
*** ttsiouts has joined #openstack-placement08:16
*** e0ne has joined #openstack-placement08:23
*** ttsiouts has quit IRC08:29
*** ttsiouts has joined #openstack-placement08:29
*** ttsiouts_ has joined #openstack-placement08:30
*** ttsiouts has quit IRC08:30
*** dklyle has quit IRC08:35
*** david-lyle has joined #openstack-placement08:35
*** helenafm has quit IRC08:57
*** cdent has joined #openstack-placement09:23
*** ttsiouts_ has quit IRC10:23
*** ttsiouts has joined #openstack-placement10:24
*** ttsiouts has quit IRC10:28
*** helenafm has joined #openstack-placement10:33
*** tetsuro has quit IRC10:56
openstackgerritChris Dent proposed openstack/placement master: WIP: Nested performance testing  https://review.opendev.org/66569510:59
cdentsigh, the turnaround loop on this is tedious11:00
*** artom has quit IRC12:22
*** artom has joined #openstack-placement12:23
*** artom has quit IRC12:33
*** artom has joined #openstack-placement12:33
*** bauzas has left #openstack-placement13:04
*** bauzas has joined #openstack-placement13:04
*** mriedem has joined #openstack-placement13:06
*** ttsiouts has joined #openstack-placement13:06
bauzasgibi: ++ for the placement graphtool13:31
bauzasthanks13:31
*** ttsiouts has quit IRC13:32
gibibauzas: I needed something to visualize complex trees13:32
*** ttsiouts has joined #openstack-placement13:33
*** ttsiouts_ has joined #openstack-placement13:36
*** ttsiouts has quit IRC13:37
cdentgibi: have you been doing some real work with real world complex trees, or is it still mostly experimentation?13:38
gibicdent: the bandwidht work already introduced enough child RPs that I needed a tool for troubleshooting13:38
cdentgibi: yeah, I just mean are you or people you work with actively using that stuff in the field13:39
gibicdent: no active user other than me yet13:39
efriedo/ folks13:45
efriedcdent, gibi: I plan to update the nested magic spec today to describe root_required.13:46
cdent13:46
gibiack13:47
*** e0ne has quit IRC14:28
openstackgerritEric Fried proposed openstack/placement master: WIP: Microversion 1.35: root_required  https://review.opendev.org/66549214:34
openstackgerritEric Fried proposed openstack/placement master: Miscellaneous doc/comment/log cleanups  https://review.opendev.org/66569114:34
*** ttsiouts_ has quit IRC14:36
*** ttsiouts has joined #openstack-placement14:37
*** ttsiouts has quit IRC14:41
*** ttsiouts has joined #openstack-placement14:48
*** tssurya has quit IRC14:49
*** e0ne has joined #openstack-placement14:52
efriedcdent: got link to the ML discussion about 'traits flow down' at your fingertips?15:06
efriedI found 'aggregates flow down', but not 'traits'.15:06
cdentone sec15:06
cdentin the aggregates flow down thread I point back to the middle of the thread where traits flow down came in: http://lists.openstack.org/pipermail/openstack-discuss/2019-April/005201.html15:07
cdentthe top of which is http://lists.openstack.org/pipermail/openstack-discuss/2019-April/004817.html15:08
efriedthanks15:11
*** e0ne has quit IRC15:28
*** ttsiouts has quit IRC15:33
*** ttsiouts has joined #openstack-placement15:34
*** ttsiouts has quit IRC15:38
*** mgagne has quit IRC15:39
*** mgagne has joined #openstack-placement15:42
*** efried has quit IRC15:44
*** efried has joined #openstack-placement15:49
cdentgibi, efried : I did a bit of profiling on the allocation mappings, nothing shocking, but a few thoughts, see: https://storyboard.openstack.org/#!/story/200588915:52
efriednice cdent15:54
efriedand yeah, no big surprise. _merge_candidates is a dog.15:54
* cdent nods15:55
efriedNot sure how to pare that down, really. Reducing redundant db reads will likely be easier.15:55
*** helenafm has quit IRC15:56
cdentYeah, anything we might do in those would be fairly magical16:01
cdentefried: I think a next possible thing to do is turn on db debugging and inspect the real set of db queries that does one request16:02
cdentzzzeek: If you're about: what's your feeling on using in_() with 1000-10000 literal values. I'm looking at placement queries and we've got a few http api requests that result in a mix of queries with several of those16:32
cdentnote to self: OS_PLACEMENT_DATABASE__CONNECTION_DEBUG=5016:36
*** cdent has quit IRC16:47
*** e0ne has joined #openstack-placement16:51
*** yikun has quit IRC16:56
zzzeekcdent: I'd keep it closer to 1000 and use batches17:00
zzzeekcdent: sqlalchemy also supports a construct called "expanding" bindparam which i recommend it will become the standard in 1.4 or 2.017:00
*** altlogbot_2 has quit IRC17:00
*** altlogbot_3 has joined #openstack-placement17:02
*** irclogbot_1 has quit IRC17:02
*** irclogbot_1 has joined #openstack-placement17:03
efriedzzzeek: cdent may know what you meant by "batches", but can you enlighten me? Does it simply mean splitting the list up in python and running the db query more than once, or is there some actual way in sqla to say "run this in batches where $input_list is split into batches of $size"?17:41
*** e0ne has quit IRC18:13
*** e0ne has joined #openstack-placement18:29
*** e0ne has quit IRC18:33
openstackgerritEric Fried proposed openstack/placement master: Spec for nested magic 1  https://review.opendev.org/66219118:35
*** efried has quit IRC19:21
*** efried has joined #openstack-placement19:35
*** e0ne has joined #openstack-placement19:38
openstackgerritEric Fried proposed openstack/placement master: Microversion 1.35: root_required  https://review.opendev.org/66549220:34
openstackgerritEric Fried proposed openstack/placement master: Miscellaneous doc/comment/log cleanups  https://review.opendev.org/66569120:34
*** e0ne has quit IRC20:36
efriedcdent, gibi, tetsuro: Spec updated, series unWIPed.20:36
*** mriedem is now known as mriedem_away21:47

Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!