Ceilometr:3, Liberty version of the Ceilometer table structure introduction __ceilometer

Liberty version of Ceilometer table structure analysis 1 Overview

Database: MongoDB

Included tables:

Alarm: Alarm Table

Alarm_history: Alarm History table

Dummydata:.

Event: Events Table

Meter: Table of measurement items

Project: Item table

Resource: Resource table

statistics21600:21600 seconds (6 hours) of aggregate results table

statistics300:300 seconds (5 minutes) of aggregate results table

statistics3600:3600 seconds (1 hours) of aggregate results table

Aggregate results table for statistics60:60 seconds

statistics7200:7200 seconds (2 hours) of aggregate results table

statistics86400:86400 seconds (1 days) aggregate result table

statistics900:900 seconds (15 minutes) of aggregate results table

Statsinfo: Statistical Information table

User: Table 2 Resource Table

Metadata mappings for

Table name	Resource
Field name	Type	Describe
_id	String	Resource ID?
Resource_name	String	Resource Name
user_id	String	User ID
Source	String	Source?
Last_sample_timestamp	Isodate	Timestamp of last sample
First_sample_timestamp	Isodate	Time stamp for last sample
project_id	String	Object ID Number
Metadata	Mappings (possibly elements of an inline array type)	Resource. Status: The number of resource states Cpu_number:cpu ramdisk_id:? Display_name: Name of the display Name: Instance name DISK_GB: Disk space size KERNEL_ID: Kernel ID Image: Mirror mappings, containing: ID: Mirrored id,links[{href,rel}],name: Mirror name EPHEMERAL_GB: Temporary size State: status. INSTANCE_ID: Instance ID Instance_type: Instance type Vcpus:cpu number MEMORY_MB: Memory size, MB Image_ref:. ROOT_GB: root directory size, GB? Host: Hosts name Flavor: Hardware template mappings, including: Name: template name Links: arrays, each element is a map, contains Href,rel RAM: Memory size, per MB Ephemeral: Temporary size Number of VCPUS:CPU Disk: Disc size, GB ID: Template ID Os-ext-az:availability_zone:? region within the scope of the range Image_ref_url: Mirror-pointing URL
Meter	Array (each element is mapped)	A list of measures that correspond to this resource Each element is a map containing: Counter_name: The name of the measurement item Counter_unit: Units of measurement items Counter_type: Types of measurement items

Specific examples:

>db.resource.findone ({"metadata.instance_id": "972e1432-4919-416b-9106-3d59a091e5f1"});

{

"_id": "972e1432-4919-416b-9106-3d59a091e5f1",

"Resource_name": "Test3",

"user_id": "8ceca41e49d94ea69790a1250698d6f1",

"Source": "OpenStack",

"Last_sample_timestamp": Isodate ("2017-04-14t07:50:10.982z"),

"First_sample_timestamp": Isodate ("2017-04-13t14:12:13.919z"),

"project_id": "242B86B0D1BB4F078596364CBC4560CF",

"Metadata": {

"Status": "Active",

"Cpu_number": 1,

"ramdisk_id": null,

"Display_name": "Test3",

"Name": "Instance-00000003",

"DISK_GB": 5,

"kernel_id": null,

' Image ': {

"id": "6c67c333-b658-47c8-9637-8a7ac36234ae",

"Links": [

{

"href": "Http://192.168.10.2:8774/183cde3dd1cd4fffa2ceb58a18b69adc/images/6c67c333-b658-47c8-9637-8a7ac36234ae" ,

"rel": "Bookmark"

}

],

' Name ': ' TESTVM '

},

"EPHEMERAL_GB": 0,

"State": "Active",

"instance_id": "972e1432-4919-416b-9106-3d59a091e5f1",

"Instance_type": "Min",

"Vcpus": 1,

"MEMORY_MB": 512,

"Image_ref": "6c67c333-b658-47c8-9637-8a7ac36234ae",

"ROOT_GB": 5,

"Host": "124cbcae25b1665fc52bb9f4b1f91fdc78b088563882b2c160f3e5ec",

"Flavor": {

"Name": "Min",

"Links": [

{

"href": "http://192.168.10.2:8774/183cde3dd1cd4fffa2ceb58a18b69adc/flavors/d368e1c9-674f-4b67-899e-c86696b73fbb ",

"rel": "Bookmark"

}

],

"Ram": 512,

"Ephemeral": 0,

"Vcpus": 1,

"Disk": 5,

"id": "D368E1C9-674F-4B67-899E-C86696B73FBB"

},

"Os-ext-az:availability_zone": "Nova",

"Image_ref_url": "Http://192.168.10.2:8774/183cde3dd1cd4fffa2ceb58a18b69adc/images/6c67c333-b658-47c8-9637-8a7ac36234ae"

},

"Meter": [

{

"Counter_name": "Compute.instance.create.start",

"Counter_unit": "Event",

"Counter_type": "Gauge"

},

{

"Counter_name": "Compute.instance.create.end",

"Counter_unit": "Event",

"Counter_type": "Gauge"

},

{

"Counter_name": "Memory.usage",

"Counter_unit": "MB",

"Counter_type": "Gauge"

},

{

"Counter_name": "Disk.read.requests.rate",

"Counter_unit": "request/s",

"Counter_type": "Gauge"

},

{

"Counter_name": "Disk.read.bytes.rate",

"Counter_unit": "B/S",

"Counter_type": "Gauge"

},

{

"Counter_name": "Disk.write.requests.rate",

"Counter_unit": "request/s",

"Counter_type": "Gauge"

},

{

"Counter_name": "Disk.write.bytes.rate",

"Counter_unit": "B/S",

"Counter_type": "Gauge"

},

{

"Counter_name": "Cpu_util",

"Counter_unit": "%",

"Counter_type": "Gauge"

},

{

"Counter_name": "Cpu.delta",

"Counter_unit": "NS",

"Counter_type": "Delta"

},

{

"Counter_name": "Instance",

"Counter_unit": "Instance",

"Counter_type": "Gauge"

}

]

}

2 meter Table 3 Event Table

Table name	Event
Field	Property	Describe
_id	String	Event ID?
Raw	Mapping	Optional, audit purposes, all notification messages can be stored for future validation.
Timestamp