These are chat archives for ManageIQ/manageiq/performance

27th
Jan 2016
Keenan Brock
@kbrock
Jan 27 2016 21:02
Alex, was looking at 1226429
Are you only seeing this for "realtime" or for "hourly" too?
It is fixed for "realtime", but the underlying problem has not been fixed for "hourly" - but maybe it doesn't need to be...
@akrzos ^^
Alex Krzos
@akrzos
Jan 27 2016 21:05
@kbrock I never tested or found an issue with purging hourly
Keenan Brock
@kbrock
Jan 27 2016 21:06
cool. then I won't fix until you do
lord knows there are enough issues out there without me finding more :)
@akrzos someone might have deleted a little data from one of your VMs
not sure who...
might have been 10.12.23.136
might have been hourly data
I don't know... just sayin' :(
(aka sorry)
Alex Krzos
@akrzos
Jan 27 2016 21:08
lol
is that why I found all those bits on the floor of the lab
Keenan Brock
@kbrock
Jan 27 2016 21:08
oh noes
to be fair, you did say you would snapshot the appliance
and I was running in a transaction
Alex Krzos
@akrzos
Jan 27 2016 21:09
it's cool, no worries
Keenan Brock
@kbrock
Jan 27 2016 21:09
but the control-c killed the transaction and it committed...
@akrzos I heard you say that line 14 was too slow. is that right?
any others? [ref]
Alex Krzos
@akrzos
Jan 27 2016 21:19
that was the only one I ran into
Keenan Brock
@kbrock
Jan 27 2016 21:20
cool. Is it possible to run against a nightly appliance to see if it has been cleared up? or will too many other things change as well?
Alex Krzos
@akrzos
Jan 27 2016 21:20
it was very difficult to get the appliance to a purge spiral state
well difficult after 5.3
I wish i had saved that database
but it was huge
it inflated like a balloon
because it had a few days before I caught it
ircc
Keenan Brock
@kbrock
Jan 27 2016 21:22
are we able to time how long the timers take now
and how long they take with new software?
so maybe not hit the spiral, but show there is less time spent doing it?
I want to close the ticket, but want to make sure it is fixed before I do
Alex Krzos
@akrzos
Jan 27 2016 21:25
understood
The best we can really do is
create a giant database
and time the function
unfortunatley it will still be affected by a number of other things
Keenan Brock
@kbrock
Jan 27 2016 21:26
yea
Keenan Brock
@kbrock
Jan 27 2016 21:32
ok, I'm moving onto perf_capture_timer - thanks again for all the help
Keenan Brock
@kbrock
Jan 27 2016 22:42
@Fryguy :) re: will sql work in virtual columns with joins? asked here.
virtual_column :v_pct_free_disk_space, :type => :float, :uses => :hardware,
                :sql  => "..."
it works :)
speedy :red_car: :+1: