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 up
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 |
+-
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 disa
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 Kudryav
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 instanc
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 cappi
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