Re: [PERFORM] autovacuum disk IO

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

2016-03-02 16:25 GMT+01:00 Artem Tomyuk <admin@xxxxxxxxxxxxxx>:
Hi. 

I've noticed that autovac. process worked more than 10 minutes, during this zabbix logged more than 90% IO disk utilization on db volume....

===========>29237   2016-03-02 15:17:23 EET 00000 [24-1]LOG:  automatic vacuum of table "lb_upr.public._reference32": index scans: 1
	pages: 0 removed, 263307 remain
	tuples: 298 removed, 1944753 remain, 0 are dead but not yet removable
	buffer usage: 67814 hits, 265465 misses, 15647 dirtied
	avg read rate: 3.183 MB/s, avg write rate: 0.188 MB/s
	system usage: CPU 5.34s/6.27u sec elapsed 651.57 sec
Is it possible to log autovac. io impact during it execution?
Is there any way to limit or "nice" autovac. process?

Thanks to all for any help. 


maybe offtopic - there is known problem of Zabbix. Any limits for vacuum are usually way to hell.

Regards

Pavel

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux