You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cloudstack.apache.org by Likitha Shetty <li...@citrix.com> on 2012/12/31 13:50:20 UTC

db table name prefixed with op_

Hi,

In cloud database what is the significance of the tables prefixed with op_ ?

Thank you,
Likitha

RE: db table name prefixed with op_

Posted by Alex Huang <Al...@citrix.com>.

Op stands for operations.  It means entries in these tables are transitional and are used for keeping track of the status of an operation.

--Alex

> -----Original Message-----
> From: Likitha Shetty [mailto:likitha.shetty@citrix.com]
> Sent: Monday, December 31, 2012 4:50 AM
> To: cloudstack-users@incubator.apache.org
> Subject: db table name prefixed with op_
> 
> Hi,
> 
> In cloud database what is the significance of the tables prefixed with op_ ?
> 
> Thank you,
> Likitha

RE: db table name prefixed with op_

Posted by Likitha Shetty <li...@citrix.com>.

Thanks Sowmya. It's helpful. 
Yes, even in my setup I do notice some tables contain entries for all resources and not just the transient ones. 

-----Original Message-----
From: Sowmya Krishnan [mailto:sowmya.krishnan@citrix.com] 
Sent: Monday, December 31, 2012 6:37 PM
To: cloudstack-users@incubator.apache.org
Subject: RE: db table name prefixed with op_

I find the following in https://cwiki.apache.org/CLOUDSTACK/coding-conventions.html 
"Tables intended for operational purposes, usually transient data should be prefixed with op_ (e.g., op_lock)"

For ex: During rebalancing of hosts between the management servers, I've found intermediate data in op_host_transfer table until the rebalance completes. 
But I am not sure if this convention holds good for all the op_* tables. For ex: I find all my networks in op_networks table and all ip addresses allocated in op_dc_ip_address_alloc..
Can someone throw more light into this?

Thanks,
Sowmya

-----Original Message-----
From: Likitha Shetty [mailto:likitha.shetty@citrix.com] 
Sent: Monday, December 31, 2012 6:20 PM
To: cloudstack-users@incubator.apache.org
Subject: db table name prefixed with op_

Hi,

In cloud database what is the significance of the tables prefixed with op_ ?

Thank you,
Likitha

RE: db table name prefixed with op_

Posted by Sowmya Krishnan <so...@citrix.com>.

I find the following in https://cwiki.apache.org/CLOUDSTACK/coding-conventions.html 
"Tables intended for operational purposes, usually transient data should be prefixed with op_ (e.g., op_lock)"

For ex: During rebalancing of hosts between the management servers, I've found intermediate data in op_host_transfer table until the rebalance completes. 
But I am not sure if this convention holds good for all the op_* tables. For ex: I find all my networks in op_networks table and all ip addresses allocated in op_dc_ip_address_alloc..
Can someone throw more light into this?

Thanks,
Sowmya

-----Original Message-----
From: Likitha Shetty [mailto:likitha.shetty@citrix.com] 
Sent: Monday, December 31, 2012 6:20 PM
To: cloudstack-users@incubator.apache.org
Subject: db table name prefixed with op_

Hi,

In cloud database what is the significance of the tables prefixed with op_ ?

Thank you,
Likitha