<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Whups, bad reply to, no problem copying the list.<div class=""><br class=""></div><div class="">It's a self hosted system, currently with two clusters and 9 active hosts.74 VMs, yes. It’s 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=""><br class=""></div><div class=""><br class=""></div><div class=""><div><blockquote type="cite" class=""><div class="">On Dec 13, 2016, at 3:36 AM, Roy Golan <<a href="mailto:rgolan@redhat.com" class="">rgolan@redhat.com</a>> wrote:</div></blockquote><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class="gmail_extra"><div class="gmail_quote">On 12 December 2016 at 20:31, Darrell Budic <span dir="ltr" class=""><<a href="mailto:budic@onholyground.com" target="_blank" class="">budic@onholyground.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Here’s mine: <font color="#0066cc" face="Liberation Sans, Lucida Grande, Luxi Sans, Bitstream Vera Sans, helvetica, verdana, arial, sans-serif" class=""><a href="http://paste.fedoraproject.org/505443/14815674/" target="_blank" class="">http://paste.<wbr class="">fedoraproject.org/505443/<wbr class="">14815674/</a></font><div class=""><br class=""></div><div class="">This engine has been around since at 3.3, maybe 3.2, currently on 3.6 because I haven’t had time to arrange the OS upgrade from centos 6 to 7 for the engine host yet.</div><div class=""><br class=""></div><div class=""><br class=""></div></div></blockquote><div class="">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=""><br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div class=""><div class=""><blockquote type="cite" class=""><div class=""><div class="h5"><div class="">On Dec 8, 2016, at 8:18 AM, Roy Golan <<a href="mailto:rgolan@redhat.com" target="_blank" class="">rgolan@redhat.com</a>> wrote:</div><br class="m_1887853932700270098Apple-interchange-newline"></div></div><div class=""><div class=""><div class="h5"><div dir="ltr" class=""><div class=""><div class=""><div class=""><div class=""><div class=""><div class="">Hi all,<br class=""><br class=""></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=""><br class=""></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=""><br class=""><span style="font-family:monospace,monospace" class="">INFO: vacuuming "pg_catalog.pg_ts_template"<br class="">INFO: index "pg_ts_template_tmplname_<wbr class="">index" now contains 5 row versions in 2 pages<br class="">DETAIL: 0 index row versions were removed.<br class="">0 index pages have been deleted, 0 are currently reusable.<br class="">CPU 0.00s/0.00u sec elapsed 0.00 sec.<br class=""></span><br class=""><br class=""></div>1. sudo su - postgres -c "psql engine -c 'vacuum verbose'" &> /tmp/vacuum.log<br class=""><br class=""></div>2. review the /tmp/vacuum.log<br class=""><br class=""></div>3. paste it to <a href="http://paste.fedoraproject.org/" target="_blank" class="">http://paste.fedoraproject.<wbr class="">org/</a> and reply with the link here<br class=""><br class=""><br class="">[1] <a href="http://lists.ovirt.org/pipermail/devel/2016-December/014484.html" target="_blank" class="">http://lists.ovirt.org/<wbr class="">pipermail/devel/2016-December/<wbr class="">014484.html</a><br class=""><br class=""><br class=""></div><div class="">Thanks,<br class=""></div><div class="">Roy<br class=""></div></div></div></div><span class="">
______________________________<wbr class="">_________________<br class="">Users mailing list<br class=""><a href="mailto:Users@ovirt.org" target="_blank" class="">Users@ovirt.org</a><br class=""><a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank" class="">http://lists.ovirt.org/<wbr class="">mailman/listinfo/users</a><br class=""></span></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""></div></div>
</div></blockquote></div><br class=""></div></body></html>