[ovirt-users] WG: High Database Load after updating to oVirt 4.0.4

[Roy Golan]

+guchen,eberman

Guy, Eyal, can you run this on the 4.0.x setup with many disks
explain analyze select * from getdisksvmguid(uuid_generate_v1(), false,
uuid_generate_v1(), false);

On 12 January 2017 at 14:53, Grundmann, Christian <
Christian.Grundmann at fabasoft.com> wrote:

> Hi,
>
> ok will write a bug
>
>
>
> Setup:
>
> 8 Nodes
>
> Around 100 VMs running all the time
>
> 100-200 VMs dynamically created and destroyed from template using vagrant
>
> Around 2 disks per VM
>
> 7 Storage Domains around 1TB each
>
>
>
> Christian
>
>
>
>
>
>
>
>
>
>
>
> *Von:* Roy Golan [mailto:rgolan at redhat.com]
> *Gesendet:* Donnerstag, 12. Jänner 2017 13:41
> *An:* Grundmann, Christian <Christian.Grundmann at fabasoft.com>
> *Cc:* users at ovirt.org
> *Betreff:* Re: [ovirt-users] WG: High Database Load after updating to
> oVirt 4.0.4
>
>
>
>
>
> On 11 January 2017 at 17:16, Grundmann, Christian <
> Christian.Grundmann at fabasoft.com> wrote:
>
> | select * from  getdisksvmguid($1, $2, $3, $4)
>
>
>
>
>
> At the moment its best that you open a bug and put all the info there.
> I can tell that other setups, even big setup, didn't experience that
>
> so I guess some env factor is hiding here. How big is your setup,
> hosts/vm/disks/domains?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170112/277e4fed/attachment.html>