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

[Darrell Budic]

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’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.


> On Dec 13, 2016, at 3:36 AM, Roy Golan <rgolan at redhat.com> wrote:
> On 12 December 2016 at 20:31, Darrell Budic <budic at onholyground.com <mailto:budic at onholyground.com>> wrote:
> Here’s mine: http://paste.fedoraproject.org/505443/14815674/ <http://paste.fedoraproject.org/505443/14815674/>
> 
> 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.
> 
> 
> 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?  
> 
>> On Dec 8, 2016, at 8:18 AM, Roy Golan <rgolan at redhat.com <mailto:rgolan at redhat.com>> wrote:
>> 
>> Hi all,
>> 
>> 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.
>> 
>> 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):
>> 
>> 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.
>> 
>> 
>> 1. sudo su - postgres  -c "psql engine -c 'vacuum verbose'" &> /tmp/vacuum.log
>> 
>> 2. review the /tmp/vacuum.log
>> 
>> 3. paste it to http://paste.fedoraproject.org/ <http://paste.fedoraproject.org/> and reply with the link here
>> 
>> 
>> [1] http://lists.ovirt.org/pipermail/devel/2016-December/014484.html <http://lists.ovirt.org/pipermail/devel/2016-December/014484.html>
>> 
>> 
>> Thanks,
>> Roy
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org <mailto:Users at ovirt.org>
>> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20161213/0af81fe1/attachment-0001.html>