Containers count mismatch

Moderator: NorbertKrupa

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Containers count mismatch

Post by id10t » Wed Mar 26, 2014 5:05 pm

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:53 pm, edited 1 time in total.

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Containers count mismatch

Post by nnani » Thu Mar 27, 2014 9:52 am

Hello Sharon and Skwa,

Thanks for a detailed information on this topic.
Further I jotted down my understanding on this ppt.
The ppt only has a flow and storage pattern in Vertica.

Coming to calculation:
If I want to know number of total ROS container for a particular projection
number of partitions * local_segments * nodes

Is there any way we can see how many local segments are actually present for a particular partition ?

Please go through it and let me know, if my understanding matches your explanation.

Thanks for your time.
Attachments
Vertica Storage Pattern.pptx
Vertica Storage Pattern
(85.84 KiB) Downloaded 126 times
nnani........
Long way to go

You can check out my blogs at vertica-howto

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Containers count mismatch

Post by id10t » Thu Mar 27, 2014 10:45 am

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:51 pm, edited 1 time in total.

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Containers count mismatch

Post by nnani » Thu Mar 27, 2014 10:53 am

Further....

I took one table and tried to find the partitions it has

Code: Select all

select count(distinct(date_trunc('week', cast(cast(period_key as varchar)as date)))) from xxxxx
I get 108 partitions

Code: Select all

select count(ros_id) from partitions where table_schema = 'xxxx' and projection_name like 'xxxx'
The above value was 387

So I assume it has 108 partition having 387 ROS Containers

Now I check the storage_containers tables

Code: Select all

select node_name,count(storage_oid) from v_monitor.storage_containers where storage_type='ROS' and
schema_name='xxxx' and projection_name like 'xxxx' group by node_name order by node_name
This also shows me proper distribution of ROS containers on all nodes and the total comes to be 387

Till this point my calculations are correct according to understanding.

The I try to do this calculation number of partition * local_segments *number of nodes
In my case
108*4*10 = 4320
This is a Odd Number which I was not expecting.
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Database Development”