5:36 p.m.
--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.
<http://lists.ovirt.org/mailman/listinfo/users>
On Dec 13, 2016, at 3:36 AM, Roy Golan <rgolan(a)redhat.com>
wrote:
On 12 December 2016 at 20:31, Darrell Budic <budic(a)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(a)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.
/tmp/vacuum.log
=20
=20
> 1. sudo su - postgres -c "psql engine -c 'vacuum
verbose'" &> = >=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
<http://lists.ovirt.org/pipermail/devel/2016-December/014484.html>
=20
=20
> Thanks,
> Roy
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org <mailto:Users@ovirt.org>
> 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(a)redhat.com</a>&gt; =
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(a)onholyground.com</a>&gt;</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(a)redhat.com</a>&gt; 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.... =
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(a)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--
2901
days inactive
2901
days old
0 comments
1 participants
participants (1)
-
Darrell Budic