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

[Tal Nisan]

guchen,eberman, any news?

On Thu, Jan 12, 2017 at 3:01 PM, Roy Golan <rgolan at redhat.com> wrote:

> +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?
>>
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170118/0cad23c5/attachment.html>