Re: CPU speed in service offering

2019-03-03 Thread Ivan Kudryavtsev
I copied the query from my .mysql_history. Maybe it's RO view, but in MySQL there are updateable views: http://www.mysqltutorial.org/create-sql-updatable-views.aspx вс, 3 мар. 2019 г., 7:55 Thomas Joseph : > A view table is readonly, the table named 'service_offering' would be the > one needs

Re: CPU speed in service offering

2019-03-03 Thread Thomas Joseph
A view table is readonly, the table named 'service_offering' would be the one needs updating. mysql> desc service_offering; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: CPU speed in service offering

2019-03-02 Thread Ivan Kudryavtsev
CPU freq is per-core. The only way is to fix it in the database and next stop/start VMs. Here is the SQL expr like the following: update service_offering_view set limit_cpu_use=0 where name like 'abc%' and domain_path='/cde/'; сб, 2 мар. 2019 г. в 15:11, Fariborz Navidan : > Also, how do I

Re: CPU speed in service offering

2019-03-02 Thread Fariborz Navidan
Also, how do I disable cpu cap for existing vms? On Sat, Mar 2, 2019 at 11:35 PM Fariborz Navidan wrote: > Hi, > > Indeed I didn't realized the answer. The one we set in a service offering > is allocated for each core or in total for whole the VM? > > On Sat, Mar 2, 2019 at 10:35 PM Ivan

Re: CPU speed in service offering

2019-03-02 Thread Fariborz Navidan
Hi, Indeed I didn't realized the answer. The one we set in a service offering is allocated for each core or in total for whole the VM? On Sat, Mar 2, 2019 at 10:35 PM Ivan Kudryavtsev wrote: > Actually, it works like everyone expects. In case of KVM you can just take > a look at running

Re: CPU speed in service offering

2019-03-02 Thread Ivan Kudryavtsev
Actually, it works like everyone expects. In case of KVM you can just take a look at running instance with ps xa. But, I don't recommend setting CPU cap, though... VM will experience CPU steal, and users will not be happy. Better to deploy nodes with low cpu frequency and many cores. Without

CPU speed in service offering

2019-03-02 Thread Fariborz Navidan
Hi, I am wondering how the cpu time usage is calculated for a VM. Is it in per core basis or the total fraction of cpu a vm can use. For example, when we set 2 cores and 2000 MHz, the VM receives total of 2000MHz of 4000MHz processing power? Thanks