Re: [ovirt-users] Request for feedback on your db vacuum status

13 Dec 2016

      --Apple-Mail=_969E9BEB-FCB9-451A-B7D5-B898FA2C1AC4
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Whups, bad reply to, no problem copying the list.

It's a self hosted system, currently with two clusters and 9 active =
hosts.74 VMs, yes. It=E2=80=99s had a few more clusters over time, and a =
few more hosts, including some removed and re-added when upgrading from =
centos 6 to 7. But only 9 at the moment. One cluster of 6 with most of =
the vms, using external Gluster servers not managed by ovirt, and one =
cluster of 3 which are also gluster servers as well as hypervisors. 7 =
vms currently on the smaller cluster.
...
On Dec 13, 2016, at 3:36 AM, Roy Golan <rgolan@redhat.com> wrote:
On 12 December 2016 at 20:31, Darrell Budic <budic@onholyground.com =
<mailto:budic@onholyground.com>> wrote:
Here=E2=80=99s mine: http://paste.fedoraproject.org/505443/14815674/ =
<http://paste.fedoraproject.org/505443/14815674/>
=20
This engine has been around since at 3.3, maybe 3.2, currently on 3.6 =
because I haven=E2=80=99t had time to arrange the OS upgrade from centos =
6 to 7 for the engine host yet.
=20
=20
Thank you very much Darrell! your vacuum seems boring (good!) and the =
db seems healthy.  Can you reply to the list that you sent the feedback =
so everyone will have a chance to look at it? also how big is your =
setup? judging by the output is it 74 vms and 42 hosts? =20
=20
...
On Dec 8, 2016, at 8:18 AM, Roy Golan <rgolan@redhat.com =
<mailto:rgolan@redhat.com>> wrote:
=20
Hi all,
=20
Following the thread about vacuum tool [1] I would like to gather =
some feedback about your deployment's db vacuum status The info is =
completely anonymous and function running it is a read only reporting =
one and should have little or no effect on the db.
=20
The result can be pretty verbose  but again will not disclose =
sensitive info. Anyway review it before pasting it. It should look =
something like that(a snippet of one table):
=20
INFO:  vacuuming "pg_catalog.pg_ts_template"
INFO:  index "pg_ts_template_tmplname_index" now contains 5 row =
versions in 2 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
=20
=20
1. sudo su - postgres  -c "psql engine -c 'vacuum verbose'" &> =
/tmp/vacuum.log
=20
2. review the /tmp/vacuum.log
=20
3. paste it to http://paste.fedoraproject.org/ =
<http://paste.fedoraproject.org/> and reply with the link here
=20
=20
[1] http://lists.ovirt.org/pipermail/devel/2016-December/014484.html =
<http://lists.ovirt.org/pipermail/devel/2016-December/014484.html>
=20
=20
Thanks,
Roy
_______________________________________________
Users mailing list
Users@ovirt.org <mailto:Users@ovirt.org>
http://lists.ovirt.org/mailman/listinfo/users =
<http://lists.ovirt.org/mailman/listinfo/users>
=20
=20
--Apple-Mail=_969E9BEB-FCB9-451A-B7D5-B898FA2C1AC4
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" =
class=3D"">Whups, bad reply to, no problem copying the list.<div =
class=3D""><br class=3D""></div><div class=3D"">It's a self hosted =
system, currently with two clusters and 9 active hosts.74 VMs, yes. =
It=E2=80=99s had a few more clusters over time, and a few more hosts, =
including some removed and re-added when upgrading from centos 6 to 7. =
But only 9 at the moment. One cluster of 6 with most of the vms, using =
external Gluster servers not managed by ovirt, and one cluster of 3 =
which are also gluster servers as well as hypervisors. 7 vms currently =
on the smaller cluster.</div><div class=3D""><br class=3D""></div><div =
class=3D""><br class=3D""></div><div class=3D""><div><blockquote =
type=3D"cite" class=3D""><div class=3D"">On Dec 13, 2016, at 3:36 AM, =
Roy Golan <<a href=3D"mailto:rgolan@redhat.com" =
class=3D"">rgolan@redhat.com</a>> =
wrote:</div></blockquote><blockquote type=3D"cite" class=3D""><div =
class=3D""><div dir=3D"ltr" class=3D""><div class=3D"gmail_extra"><div =
class=3D"gmail_quote">On 12 December 2016 at 20:31, Darrell Budic <span =
dir=3D"ltr" class=3D""><<a href=3D"mailto:budic@onholyground.com" =
target=3D"_blank" class=3D"">budic@onholyground.com</a>></span> =
wrote:<br class=3D""><blockquote class=3D"gmail_quote" style=3D"margin:0 =
0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
style=3D"word-wrap:break-word" class=3D"">Here=E2=80=99s =
mine: <font color=3D"#0066cc" face=3D"Liberation Sans, Lucida =
Grande, Luxi Sans, Bitstream Vera Sans, helvetica, verdana, arial, =
sans-serif" class=3D""><a =
href=3D"http://paste.fedoraproject.org/505443/14815674/" target=3D"_blank"=
 class=3D"">http://paste.<wbr class=3D"">fedoraproject.org/505443/<wbr =
class=3D"">14815674/</a></font><div class=3D""><br class=3D""></div><div =
class=3D"">This engine has been around since at 3.3, maybe 3.2, =
currently on 3.6 because I haven=E2=80=99t had time to arrange the OS =
upgrade from centos 6 to 7 for the engine host yet.</div><div =
class=3D""><br class=3D""></div><div class=3D""><br =
class=3D""></div></div></blockquote><div class=3D"">Thank you very much =
Darrell! your vacuum seems boring (good!) and the db seems =
healthy.  Can you reply to the list that you sent the feedback so =
everyone will have a chance to look at it? also how big is your setup? =
judging by the output is it 74 vms and 42 hosts?  <br class=3D""><br =
class=3D""></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
style=3D"word-wrap:break-word" class=3D""><div class=3D""><div =
class=3D""><blockquote type=3D"cite" class=3D""><div class=3D""><div =
class=3D"h5"><div class=3D"">On Dec 8, 2016, at 8:18 AM, Roy Golan =
<<a href=3D"mailto:rgolan@redhat.com" target=3D"_blank" =
class=3D"">rgolan@redhat.com</a>> wrote:</div><br =
class=3D"m_1887853932700270098Apple-interchange-newline"></div></div><div =
class=3D""><div class=3D""><div class=3D"h5"><div dir=3D"ltr" =
class=3D""><div class=3D""><div class=3D""><div class=3D""><div =
class=3D""><div class=3D""><div class=3D"">Hi all,<br class=3D""><br =
class=3D""></div>Following the thread about vacuum tool [1] I would like =
to gather some feedback about your deployment's db vacuum status The =
info is completely anonymous and function running it is a read only =
reporting one and should have little or no effect on the db.<br =
class=3D""><br class=3D""></div>The result can be pretty verbose  =
but again will not disclose sensitive info. Anyway review it before =
pasting it. It should look something like that(a snippet of one =
table):<br class=3D""><br class=3D""><span =
style=3D"font-family:monospace,monospace" class=3D"">INFO:  =
vacuuming "pg_catalog.pg_ts_template"<br class=3D"">INFO:  index =
"pg_ts_template_tmplname_<wbr class=3D"">index" now contains 5 row =
versions in 2 pages<br class=3D"">DETAIL:  0 index row versions =
were removed.<br class=3D"">0 index pages have been deleted, 0 are =
currently reusable.<br class=3D"">CPU 0.00s/0.00u sec elapsed 0.00 =
sec.<br class=3D""></span><br class=3D""><br class=3D""></div>1. sudo su =
- postgres  -c "psql engine -c 'vacuum verbose'" &> =
/tmp/vacuum.log<br class=3D""><br class=3D""></div>2. review the =
/tmp/vacuum.log<br class=3D""><br class=3D""></div>3. paste it to <a =
href=3D"http://paste.fedoraproject.org/" target=3D"_blank" =
class=3D"">http://paste.fedoraproject.<wbr class=3D"">org/</a> and reply =
with the link here<br class=3D""><br class=3D""><br class=3D"">[1] <a =
href=3D"http://lists.ovirt.org/pipermail/devel/2016-December/014484.html" =
target=3D"_blank" class=3D"">http://lists.ovirt.org/<wbr =
class=3D"">pipermail/devel/2016-December/<wbr =
class=3D"">014484.html</a><br class=3D""><br class=3D""><br =
class=3D""></div><div class=3D"">Thanks,<br class=3D""></div><div =
class=3D"">Roy<br class=3D""></div></div></div></div><span class=3D"">
______________________________<wbr class=3D"">_________________<br =
class=3D"">Users mailing list<br class=3D""><a =
href=3D"mailto:Users@ovirt.org" target=3D"_blank" =
class=3D"">Users@ovirt.org</a><br class=3D""><a =
href=3D"http://lists.ovirt.org/mailman/listinfo/users" target=3D"_blank" =
class=3D"">http://lists.ovirt.org/<wbr =
class=3D"">mailman/listinfo/users</a><br =
class=3D""></span></div></blockquote></div><br =
class=3D""></div></div></blockquote></div><br class=3D""></div></div>
</div></blockquote></div><br class=3D""></div></body></html>=

--Apple-Mail=_969E9BEB-FCB9-451A-B7D5-B898FA2C1AC4--

Darrell Budic

tags

participants (1)