axibase time series database€¦ · axibase time series database 2 prepared by axibase axibase...
TRANSCRIPT
![Page 1: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/1.jpg)
Axibase Time Series Database
![Page 2: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/2.jpg)
Axibase Time Series Database
2 Prepared by Axibase
Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage of
various information coming out of the IT infrastructure. ATSD is specifically designed to store and
analyze large amounts of statistical data collected at high frequency.
![Page 3: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/3.jpg)
Database History
3 Prepared by Axibase
• 1970 – IBM introduced relational algebra for data processing.
• Cambrian explosion of relational database management systems:
• 2000 – first large-scale applications emerge, such as Google Search.
• 2004 – Google Big Table – first non-relational database using distributed file system.
• Currently we are experiencing Cambrian explosion of non-relational (a.k.a. NoSQL) databases:
![Page 4: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/4.jpg)
Key Differences Between SQL and NoSQL
4 Prepared by Axibase
SQL NoSQL
High-level Programming Language SQL
Transactions
Query Optimizer
Non-key indexes
![Page 5: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/5.jpg)
Key Differences Between SQL and NoSQL
5 Prepared by Axibase
SQL NoSQL
Scalability TB PB
Maximum Cluster Size 48 (Oracle RAC) 1000+
Distributed
Read TimeDepends on table size and
indexesLinear
Write TimeDepends on table size and
indexesLinear
Table Schema (column names, data types)
PredeterminedRaw bytes. Schema
determined by application
![Page 6: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/6.jpg)
How Proven Is NoSQL Technology
6 Prepared by Axibase
NoSQL is the leading technology behind big data applications.
• Google – search, gmail, AppEngine
• Yahoo/Microsoft – search
• Amazon – e-commerce, search, cloud computing (AWS DynamoDB)
• IBM Big Insights, Microsoft Azure HD Insight
![Page 7: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/7.jpg)
Big Data Adoption
7 Prepared by Axibase
HBase behind Facebook Messages:
• 6+ billion messages per day
• 75+ billion R/W operations per day
• Peak throughput: 1.5 million R/W operations per second
• 2+ petabytes of data (6+ PB including replicas) with data growth of over 8 TB per day
![Page 8: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/8.jpg)
Big Data Adoption
8 Prepared by Axibase
IBM BigInsights behind Vestas:
• A wind energy company in Denmark is reducing the time to analyze petabytes of data from
several weeks to 15 minutes to improve the accuracy of wind turbine placement.
• Stores 2.8 PB of company historical data together with over 178 external parameters:
temperature, barometric pressure, humidity, precipitation, wind direction, wind velocity etc.
• Stores precise data on weather over the past 11 years.
• Collects data from over 35,000 meteorological stations.
![Page 9: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/9.jpg)
Big Data Adoption
9 Prepared by Axibase
HBase behind Explorys:
• Explorys uses HBase to enable search and analysis of patient populations, treatment protocols,
and clinical outcomes.
• Stores over 275 billion clinical, financial and operational data elements.
• 48 million unique patient files.
• Collecting data from over 340 hospitals and 300,000 healthcare providers.
• Pull data from 22 integrated major healthcare systems.
![Page 10: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/10.jpg)
Axibase Time Series Database
10 Prepared by Axibase
Scalability & Speed• Collects billions of samples per day. Retains detailed data forever.
Features• Combines database, rule engine, and visualization in one product.
Analytical Rule Engine• Applies aggregate functions and filters on streaming data.
Integration• Accepts data from any source based on industry-standard protocols.
Visualization• Built-in portals with smart widgets.
![Page 11: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/11.jpg)
11 Prepared by Axibase
![Page 12: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/12.jpg)
Big Data for IT Monitoring
12 Prepared by Axibase
• Retain detailed data forever.
• Collect statistics at high-frequency, for example every 15 seconds.
• Consolidate performance statistics from all systems into one database: facilities, network,
storage, servers, applications, databases, transactions, service providers, user activity etc.
• Monitor infrastructure based on abnormal deviations instead of manual thresholds.
• Apply statistical formulas to predict outages.
• Take advantage of schema-less database to collect data from any source.
![Page 13: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/13.jpg)
Big Data for Developers
13 Prepared by Axibase
• Support for annotation-style instrumentation.
• Alternative to byte-code instrumentation and
file logging.
• Collect detailed performance and usage
statistics for reporting and analytics, without
writing custom monitors.
![Page 14: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/14.jpg)
Big Data for Operations
14 Prepared by Axibase
• Gather and analyze statistical data generated by the various systems and sensors.
• Analytics that can support decision control systems.
• Allows for better real‐time operations decision‐support.
• Generate accurate forecasts of upcoming issues:
• Delays
• Scheduled maintenance based on product usage and sensor data instead of warranty
periods
• Improved customer service times and standards.
![Page 15: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/15.jpg)
ATSD Architecture
15 Prepared by Axibase
• ATSD architecture combines database,
analytics and reporting tools into one
complete product.
• Data locality makes analytics run faster.
• Application server layer is simplified to
provide core shared services
![Page 16: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/16.jpg)
ATSD Components
16 Prepared by Axibase
• Pluggable driver provides support for
different storage engines
• Compute, persistence and data
collection layers scaled independently
![Page 17: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/17.jpg)
Fault Tolerance
17 Prepared by Axibase
• ATSD is a distributed system,
with high fault tolerance.
• Each data sample is
automatically replicated 3
times for recovery.
![Page 18: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/18.jpg)
ATSD Scalability
18 Prepared by Axibase
• ATSD is a distributed, non-relational database with high throughput, fault tolerance and reading
speed.
• ATSD can collect billions of metrics per day and store petabytes of data.
• ATSD supports millisecond resolution and sampling intervals of up to several measurements per
second. The data is stored without losing accuracy.
• Additional nodes can be added at runtime to handle increasing volumes. ATSD automatically
distributes the table across active nodes.
• New nodes can be added in remote data centers to minimize network traffic.
![Page 19: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/19.jpg)
Supported Data Types
19 Prepared by Axibase
• Two types of data ingestion: push and pull.
• ATSD supports numeric values, log messages and properties (collection of key-values).
• ATSD uses collectors for retrieving structured and unstructured data from remote sources.
• Support for standard protocols: Telnet, ICMP, CSV/TSV, FILE, JMX, HTTP, and JSON.
![Page 20: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/20.jpg)
Data Collection
20 Prepared by Axibase
• Collection is agentless; data is pushed by external systems into ATSD.
• New metrics are auto-registered. No need to update schema or restart any server components.
• Existing monitoring tools can be instrumented to stream data into ATSD.
• Each data sample can be tagged (key = value) at source for subsequent querying, aggregations,
and roll-ups.
![Page 21: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/21.jpg)
Data Storage
21 Prepared by Axibase
• Built-in data compression provides 70%-80% disk space savings over raw data.
• No data needs to be deleted. Seek time is almost linear regardless of the dataset size.
• Data storage is sparse and efficient. ATSD stores only what is collected instead of long rows with
NULLs or zeros, as is the case in relational model.
• VMware VMFS-attached disks are sufficient for small to medium clusters.
• Direct attached disks with JBOD are recommended for larger clusters.
• JBOD alternatives to minimize node recovery time are available from leading storage vendors,
such as NetApp E-Series.
![Page 22: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/22.jpg)
Built-in Instruments
22 Prepared by Axibase
Unlike conventional data warehouses, ATSD comes with a set of built-in tools for data analysis:
• Analytical Rule Engine
• Forecasting
• Visualization
![Page 23: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/23.jpg)
Analytical Rule Engine
23 Prepared by Axibase
• Evaluates incoming data in memory based on statistical rules.
• Statistical rules are applied to the incoming data stream before data is
stored on disk.
• As data is ingested by ATSD server, a subset of samples that match rule
queries are routed to the rule engine for processing.
• Rule Engine supports both time- and count- based data windows.
• Rule expressions and filters can reference not just numeric values but also
tags such as system type, location, priority to ensure that alerts are raised
only for critical issues.
• Multiple metrics and entities can be correlated within the same rule.
![Page 24: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/24.jpg)
Analytical Rule Engine – Rule Examples
24 Prepared by Axibase
Type Window Example Description threshold none value > 75 Raise an alert if last metric value exceeds threshold
range none value > 50 AND value <= 75 Raise an alert if value is outside of specified range
statistical-count count(10) avg(value) > 75 Raise an alert if average value of the last 10 samples exceeds threshold
statistical-time time('15 min') avg(value) > 75 Raise an alert if average value for the last 15 minutes exceeds threshold
statistical-deviation time('15 min') avg(value) / avg(value(time: '1 hour')) >
1.25
Raise an alert if 15-minute average exceeds 1-hour average by more than 25%
statistical-ungrouped time('15 min') avg(value) > 75 Raise an alert if 15-minute average values for all entities in the group exceeds threshold
metric correlation time('15 min') avg(value) > 75 AND avg(value(metric:
'loadavg.1m')) > 0.5
Raise an alert if average values for two separate metrics for the last 15 minutes exceed predefined
thresholds
entity correlation time('15 min') avg(value) > 75 AND avg(value(entity:
'host2')) > 75
Raise an alert if average values for two entities for the last 15 minutes exceed thresholds
threshold override time('15 min') avg(value) >= entity.groupTag('cpu
_avg').min()
Raise an alert if 15-minute average value exceeds minimum threshold specified for groups to which
the entity belongs
cpu forecast deviation time('5 min') abs(forecast_deviation(wavg())) > 2 Raise an alert if 5-minute average deviates from forecast by more than two standard deviations
cpu forecast diff time('10 min') abs(wavg() - forecast()) > 25 Raise alert if absolute forecast deviates from average by more than specified value
disk threshold time('15 min') new_maximum() &&
threshold_linear_time(99) < 120
Raise alert if last value is the highest observed and linear threshold is expected to violate the 99%
threshold in less than 120 minutes
![Page 25: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/25.jpg)
Analytical Rule Engine
25 Prepared by Axibase
![Page 26: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/26.jpg)
Analytical Rule Engine
26 Prepared by Axibase
![Page 27: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/27.jpg)
Forecasting
27 Prepared by Axibase
• Customers have a growing need to predict problems before they occur. The accuracy of
predictions and the percentage of false positives/negatives highly depends on the frequency of
data collection, the retention interval, and algorithms.
• The use of built-in autoregressive time-series extrapolation algorithms (Holt-Winters, ARIMA,
etc.) in ATSD allows predicting of system failures at early stages.
• The forecasting process is resource intensive and is most effective in a clustered system with
data locality such as ATSD.
• Dynamic predictions eliminate the need to set manual thresholds.
![Page 28: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/28.jpg)
Forecasting Example
28 Prepared by Axibase
![Page 29: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/29.jpg)
Forecasting Example
29 Prepared by Axibase
![Page 30: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/30.jpg)
Forecast Settings
30 Prepared by Axibase
• ATSD selects the most accurate
forecasting algorithm for each
time-series separately based on a
ranking system.
• The winning algorithm is used to
compute forecast for the next day,
week or month.
• Pre-computed forecasts can be
used in rule engine.
![Page 31: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/31.jpg)
Forecast Settings
31 Prepared by Axibase
![Page 32: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/32.jpg)
Visualization
32 Prepared by Axibase
• ATSD can be integrated with Axibase Enterprise Reporting using the ATSD adapter
• ATSD comes with a wide variety of widgets for creating interactive portals directly in ATSD.
• ATSD widgets are designed from the ground-up to handle large data sets and calculations on the
client.
• ATSD visualization is supported on mobile devices and Smart TVs.
![Page 33: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/33.jpg)
Visualization
33 Prepared by Axibase
![Page 34: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/34.jpg)
Search
34 Prepared by Axibase
• Implemented in ATSD is log file search system to detect problems in distributed systems for the
purposes of security, audit and change control.
Notifications
• Supports standard notification mechanisms: email, console, web service, and notification in the
environment.
• For example, Axibase LED lighting system - the "Data Cube", which changes colors depending on
the status of IT services.
![Page 35: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/35.jpg)
ATSD Benefits
35 Prepared by Axibase
• Enables customers to extract value from data that already exists in their operational and IT
infrastructures.
• Delivers preemptive monitoring through identification of abnormal behaviors in production
systems.
• Eliminates most manually-defined rules from the customer’s monitoring catalog.
• Serves as a centralized repository for historical data.
• Directly supported by AER for Dashboards, Reports, Capacity Planning
![Page 36: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/36.jpg)
System Requirements
36 Prepared by Axibase
• Operating Systems:
• Red Hat Enterprise Linux 5.6+
• Ubuntu 12.04+
• Suse Linux Enterprise Server 10+
• Storage:
• Direct attached disks (JBOD)
• NetApp E2660 http://www.netapp.com/us/solutions/big-data/hadoop.aspx
• Computing Hardware: Environment < 1K Metrics/sec < 5K Metrics/sec > 5K Metric/sec
ATSD Nodes 1 1 > 5
Processors 2 vCPU, 2+ GHz 4 vCPU, 2+ GHz 4 vCPU, 2+ GHz
Memory 4 GB (2GB for JVM) 16 GB (8GB for JVM) 16 GB (8GB for JVM)
![Page 37: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/37.jpg)
Use Cases
37 Prepared by Axibase
• ITM long-term history extension
• nmon reporting for AIX, Linux and Solaris
• Minimize exceptions in monitoring catalog
• Collect environmental data from SCADA
• Predictive Maintenance – based on sensors
![Page 38: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/38.jpg)
ITM History Extension
38 Prepared by Axibase
• ITM can be instrumented to write streaming data into CSV files.
• CSV can be instantly uploaded into ATSD using inotify utility and wget.
• Example: private history streaming in ITM
• KHD_CSV_OUTPUT_ACTIVATE = Y
![Page 39: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/39.jpg)
ITM History Extension
39 Prepared by Axibase
• Warehouse Proxy Agent is setup to save history data to CSV file
on the local machine.
• ATSD ingests the CSV files for analytics and long-term storage.
• ATSD converts the data using built in parsers.
![Page 40: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/40.jpg)
nmon Reporting
40 Prepared by Axibase
• Consolidate trusted statistics from UNIX systems in one database
• Analyze nmon data with forecasting algorithms
• Leverage AER reporting features and dashboards
![Page 41: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/41.jpg)
nmon Reporting
41 Prepared by Axibase
![Page 42: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/42.jpg)
42 Prepared by Axibase
ssh –fN –L localhost:14032:$server:8081 username@$server
echo "look for file: $nmonfile"
( echo "nmon p:$parserID e:$entityID f:$filename z:`date +%Z`" && tail -n +0 -f $nmonfile ) | telnet 127.0.0.1 14032 &
sleep 2
telnetpid=$(ps -ef | grep "telnet $server $port" | grep -v "grep" | sort -n | head -n 1 | awk '{print $2}')
tailpid=$(ps -ef | grep "tail -n +0 -f $nmonfile" | grep -v "grep" | sort -n | head -n 1 | awk '{print $2}')
while :;
do
if [ -d "/proc/$nmonpid" -a "$nmonpid" != "" ]; then
if [ -d "/proc/$telnetpid" -a "$telnetpid" != "" -a -d "/proc/$tailpid" -a "$tailpid" != "" ]; then
continue
#echo "tail($tailpid), telnet($telnetpid) and nmon($nmonpid) working"
else
#echo "tail/telnet not working, start new tail/telnet"
kill $tailpid >>/dev/null 2>&1
kill $telnetpid >>/dev/null 2>&1
( echo "nmon p:$parserID e:$entityID f:$filename z:`date +%Z`" && tail -n 0 -f $nmonfile ) | telnet $server $port &
sleep 2
telnetpid=$(ps -ef | grep "telnet $server $port" | grep -v "grep" | sort -n | head -n 1 | awk '{print $2}')
tailpid=$(ps -ef | grep "tail -n 0 -f $nmonfile" | grep -v "grep" | sort -n | head -n 1 | awk '{print $2}')
fi
sleep 2
else
kill $tailpid >>/dev/null 2>&1
kill $telnetpid >>/dev/null 2>&1
break;
fi
done
/usr/bin/topas_nmon -ftdTWALM -s 60 -c 1440 -o /opt/NMON/nmon_log
./resend.sh -d /opt/NMON/nmon_log &
h – helps – remote atsd serverp – remote atsd porti - parser_idd - logs_directory
nmon Sender Scrpit
![Page 43: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/43.jpg)
nmon Parser Configuration
43 Prepared by Axibase
![Page 44: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/44.jpg)
nmon Format - header
44 Prepared by Axibase
AAA,progname,topas_nmon
AAA,command,/usr/bin/topas_nmon -ftdTWALM -s 1200 -c 72 -o /opt/NMON/day/ -
youtput_dir=/opt/NMON/day/ -ystart_time=20:00:01,Oct14,2014
AAA,version,TOPAS-NMON
AAA,build,AIX
AAA,disks_per_line,150
AAA,host,canaria
AAA,user,root
AAA,AIX,6.1.7.16
AAA,TL,07
AAA,runname,canaria
AAA,time,20:00:02
AAA,date,14-OCT-2014
AAA,interval,1200
AAA,snapshots,72
AAA,hardware,Architecture PowerPC Implementation POWER7_in_P7_mode 64 bit
AAA,cpus,512,256
AAA,kernel, HW-type=CHRP=Common H/W Reference Platform Bus=PCI LPAR=Dynamic Multi-
Processor 64 bit
AAA,SerialNumber,84D8AB6
AAA,LPARNumberName,6,canaria
AAA,MachineType,IBM,9119-FHB
AAA,NodeName,canaria
AAA,timestampsize,0
• Upload new lines to ATSD using inotify utility
![Page 45: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/45.jpg)
nmon Format – system commands
45 Prepared by Axibase
BBBB,0000,name,size(GB),disc attach type
BBBB,0001,hdisk10,343.42,Hitachi-HDS
BBBC,000,hdisk10:
BBBC,001,LV NAME LPs PPs DISTRIBUTION MOUNT POINT
BBBC,002,PDIoriglogALv 18 18 00..18..00..00..00 /oracle/PDI/origlogA
BBBC,003,PDIoriglogBLv 18 18 00..18..00..00..00 /oracle/PDI/origlogB
BBBC,004,PDImirrlogALv 18 18 00..18..00..00..00 /oracle/PDI/mirrlogA
BBBC,005,PDImirrlogBLv 18 18 00..18..00..00..00 /oracle/PDI/mirrlogB
BBBC,006,PDIsapdata3Lv 46 46 00..00..00..00..46 /oracle/PDI/sapdata3
BBBC,007,PDIsapdata2Lv 111 111 00..00..00..00..111 /oracle/PDI/sapdata2
BBBC,008,PDIsapmntLv 80 80 00..80..00..00..00 /sapmnt/PDI
BBBC,009,PDIusrsap 136 136 00..96..00..00..40 /usr/sap/PDI
BBBC,010,PDIusrsaptransL 80 80 00..80..00..00..00 /usr/sap/trans/PDI
BBBC,011,PDIoracleLv 112 112 00..56..00..00..56 /oracle/PDI
BBBC,012,PDIorabinLv 64 64 00..64..00..00..00 /oracle/PDI/102_64
BBBC,013,PDIoraarchLv 1982 1982 537..89..536..536..284 /oracle/PDI/oraarch
…..
BBBC,210,LV NAME LPs PPs DISTRIBUTION MOUNT POINT
BBBC,211,PDIsapdata5Lv 670 670 256..95..210..00..109 /oracle/PDI/sapdata5
BBBC,212,PDIsapdata3Lv 1329 1329 144..305..189..400..291 /oracle/PDI/sapdata3
BBBB,0047,hdisk47,255.87,Hitachi-HDS
BBBC,213,hdisk47:
BBBC,214,LV NAME LPs PPs DISTRIBUTION MOUNT POINT
BBBC,215,PDIsapdata2Lv 776 776 00..400..376..00..00 /oracle/PDI/sapdata2
BBBB,0048,hdisk48,255.87,Hitachi-HDS
BBBC,216,hdisk48:
BBBC,217,LV NAME LPs PPs DISTRIBUTION MOUNT POINT
BBBC,218,PDIsapdata5Lv 1999 1999 400..400..399..400..400 /oracle/PDI/sapdata5
![Page 46: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/46.jpg)
nmon Format – snapshot
46 Prepared by Axibase
ZZZZ,T0009,23:02:43,14-OCT-2014
CPU01,T0009,58.9,27.9,6.6,6.6
CPU02,T0009,0.4,0.6,0.0,99.0
CPU03,T0009,0.1,0.3,0.0,99.6
CPU04,T0009,0.0,0.3,0.0,99.7
....
SCPU255,T0009,0.00,0.00,0.00,0.01
SCPU256,T0009,0.00,0.00,0.00,0.01
CPU_ALL,T0009,16.0,1.7,0.7,81.6,,256
PCPU_ALL,T0009,10.22,1.12,0.1,6.42,64.00
SCPU_ALL,T0009,10.22,1.12,0.1,6.42
LPAR,T0009,17.817,64,256,124,64.00,128,0.00,13.92,14.37,1,0,15.98,1.75,0.09,10.03,15.98,1.75,0.09,10.03,0,0
POOLS,T0009,124,124.00,124.00,0.00,0.00,0.00,0.00,0,64.00
MEM,T0009,43.1,98.5,451646.0,129618.0,1048576.0,131584.0
MEMNEW,T0009,40.4,4.3,12.1,43.1,15.0,41.6
MEMUSE,T0009,4.3,3.0,40.0,960,1088,4.3,40.0, 259828592.0
PAGE,T0009,19186.2,17033.4,673.6,0.0,0.0,0.0,0.0,0.0
MEMPAGES4KB,T0009,229089856,106620616,11661852,0,11661852,110641309,960,1088,0,0,110641309
MEMPAGES64KB,T0009,2459100,562547,0,0,0,1896553,60,68,0,0,1896553,0,0,1843706
LARGEPAGE,T0009,0,0,0,0,16.0
PROC,T0009,20.79,0.52,24224,113015,9105,6041,5,6,41235,0,0,0,10
FILE,T0009,0,486,0,89481716,29209504,0,0,0
NET,T0009,0.0,1569.1,4748.1,0.0,21043.1,4752.3
NETPACKET,T0009,0.6,10604.5,4517.1,0.6,10604.5,4517.1
NETSIZE,T0009,56.8,151.5,1076.4,60.0,2921.5,1076.5
NETERROR,T0009,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0
IOADAPT,T0009,20985.2,834.6,797.9,21476.7,882.3,814.1,21053.4,861.9,807.3,21326.5,911.4,812.4,744.0,138.7,36.1,0.1,138.7,33.0
JFSFILE,T0009,88.2,9.5,59.9,44.7,1.3,0.3,15.6,0.3,36.4,73.7,68.1,89.5,59.0,88.9,88.9,88.9,88.9,0.7,46.8,88.6,93.1,93.0,93.5,93.8
JFSINODE,T0009,13.8,0.0,12.4,4.4,0.1,0.0,0.8,0.0,11.1,0.3,18.0,3.2,2.9,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0
DISKBUSY,T0009,5.1,6.4,3.9,4.2,4.9,4.4,4.1,4.1,4.6,3.1,3.9,3.6,2.8,2.2,14.0,22.6,8.5,0.0,5.5,5.6,6.7,10.5,0.5,11.1,0.0,24.9,7.8,5.0
DISKREAD,T0009,1136.4,447.6,382.6,305.1,322.3,352.8,321.1,326.3,355.4,97.8,95.5,87.6,152.3,92.2,979.4,2052.8,10432.8,0.0,438.8,559.2,4
DISKWRITE,T0009,2701.0,6.9,14.3,2.8,10.6,3.0,3.8,3.0,34.0,0.4,0.2,0.6,23.2,278.8,5.2,4.8,0.4,0.0,20.5,38.4,0.8,138.7,0.0,138.7,0.0
DISKXFER,T0009,124.5,56.8,44.8,38.5,40.8,44.2,40.4,41.2,45.6,12.4,12.1,11.3,24.5,15.0,122.6,185.4,166.0,0.0,55.2,70.9,56.7,33.2,3.0,33
DISKRXFER,T0009,74.8,56.0,43.7,38.3,40.4,44.1,40.2,40.9,43.4,12.4,12.1,11.2,19.1,11.0,122.3,185.0,166.0,0.0,53.3,68.5,56.6,0.2,3.0,0.0
DISKBSIZE,T0009,30.8,8.0,8.9,8.0,8.2,8.0,8.0,8.0,8.5,7.9,7.9,7.8,7.2,24.8,8.0,11.1,62.9,0.0,8.3,8.4,8.0,4.8,244.9,4.2,0.5,60.2,8.0,8
![Page 47: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/47.jpg)
47 Prepared by Axibase
"max capacity": "1.0",
"max logical": "16",
"max memory mb": "6144",
"max virtual": "4",
"min capacity": "0.1",
"min logical": "1",
"min memory mb": "1024",
"min virtual": "1",
"nodename": "itm-aix",
"nov11": "2014",
"online memory": "3072",
"pool cpu": "16",
"pool id": "0",
"progname": "topas_nmon",
"runname": "itm-aix",
"serialnumber": "102CA4V",
"smt threads": "4",
"snapshots": "10000",
"time": "04:26:57",
"timestampsize": "0",
"tl": "03",
"user": "root"
"version": "TOPAS-NMON",
"virtual cpu": "2",
"weight": "128",
List of nmon Configuration Properties
"aix": "7.1.3.16",
"build": "AIX",
"capped": "0",
"command": "/usr/bin...,Nov11,2014 ",
"cpu in sys": "16",
"cpus": "16,8",
"date": "11-NOV-2014",
"disks_per_line": "150",
"entitled capacity": "0.5",
"hardware": "Architecture Po...64 bit",
"host": "itm-aix",
"ibm": "8286-42A",
"interval": "60",
"kernel": "HW-type=CHRP=Common...64 bit",
"logical cpu": "8",
"lparname": "ITM-AIX",
"lparno": "16",
"lparnumbername": "16,ITM-AIX",
"machinetype": "IBM,8286-42A",
![Page 48: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/48.jpg)
48 Prepared by Axibase
Derived Metrics
pcpu_total.busy = pcpu_total.sys + pcpu_total.user + pcpu_total.wait
scpu_total.busy = scpu_total.sys + scpu_total.user + scpu_total.wait
pcpu_total.entitled_capacity_used% = pcpu_total.busy / pcpu_total.entitled_capacity * 100
pcpu.total = pcpu.sys + pcpu.user + pcpu.wait -- computed by tag (by processor id)
scpu.total = scpu.sys + scpu.user + scpu.wait -- computed by tag (by processor id)
nmon.memory_mb.memused% = (1 - nmon.memory_mb.memfree/nmon.memory_mb.memtotal) * 100
nmon.memory_mb.memused = nmon.memory_mb.memtotal - nmon.memory_mb.memfree
nmon.memory_mb.swapused% = (1 - nmon.memory_mb.swapfree/nmon.memory_mb.swaptotal) * 100
nmon.memory_mb.swapused = nmon.memory_mb.swaptotal - nmon.memory_mb.swapfree
nmon.cpu_total.busy% = 100 - nmon.cpu_total.idle%
nmon.logical_partition.entitled_used% = nmon.logical_partition.physicalcpu / nmon.logical_partition.entitled * 100
nmon.logical_partition.physicalcpu_used% = nmon.logical_partition.physicalcpu / nmon.logical_partition.virtualcpus * 100
nmon.memory.real_used_% = 100 - nmon.memory.real_free_%
nmon.memory.virtual_used_% = 100 - nmon.memory.virtual_free_%
nmon.memory.real_used(mb) = nmon.memory.real_total(mb) - nmon.memory.real_free(mb)
nmon.memory.virtual_used(mb) = nmon.memory.virtual_total(mb) - nmon.memory.virtual_free(mb)
ATSD computes derived metrics to simplify downstream rule development and visualization tasks
The derived metrics are stored similar to original metrics and are also available in rule expressions, forecasts and widgets:
![Page 49: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/49.jpg)
49 Prepared by Axibase
CPU Metrics CPU Metrics CPU Metrics Disk and i/o Metrics
nmon.asynchronous_i/o.aiocpunmon.asynchronous_i/o.aioprocsnmon.asynchronous_i/o.aiorunning
nmon.cpu.idle%nmon.cpu.sys%nmon.cpu.user%nmon.cpu.wait%
nmon.cpu_total.busynmon.cpu_total.idle%nmon.cpu_total.sys%nmon.cpu_total.user%nmon.cpu_total.wait%
nmon.logical_partition.cappednmon.logical_partition.ec_idle%nmon.logical_partition.ec_sys%nmon.logical_partition.ec_user%nmon.logical_partition.ec_wait%nmon.logical_partition.entitlednmon.logical_partition.foldednmon.logical_partition.logicalcpusnmon.logical_partition.physicalcpunmon.logical_partition.pool_idnmon.logical_partition.poolcpusnmon.logical_partition.poolidlenmon.logical_partition.sharedcpunmon.logical_partition.usedallcpu%nmon.logical_partition.usedpoolcpu%nmon.logical_partition.virtualcpusnmon.logical_partition.vp_idle%nmon.logical_partition.vp_sys%nmon.logical_partition.vp_user%nmon.logical_partition.vp_wait%nmon.logical_partition.weight
nmon.pcpu.idlenmon.pcpu.sysnmon.pcpu.usernmon.pcpu.waitnmon.pcpu_total.entitled_capacitynmon.pcpu_total.idlenmon.pcpu_total.sysnmon.pcpu_total.usernmon.pcpu_total.wait
nmon.processes.asleep_bufionmon.processes.asleep_diocionmon.processes.asleep_rawionmon.processes.blockednmon.processes.execnmon.processes.forknmon.processes.msgnmon.processes.pswitchnmon.processes.readnmon.processes.runnablenmon.processes.semnmon.processes.swap-innmon.processes.syscallnmon.processes.write
nmon.scpu.idlenmon.scpu.sysnmon.scpu.usernmon.scpu.waitnmon.scpu_total.idlenmon.scpu_total.sysnmon.scpu_total.usernmon.scpu_total.wait
nmon.multiple_cpu_pools.entitlednmon.multiple_cpu_pools.entitled_pool_capacitynmon.multiple_cpu_pools.max_pool_capacitynmon.multiple_cpu_pools.pool_busy_timenmon.multiple_cpu_pools.pool_idnmon.multiple_cpu_pools.pool_max_timenmon.multiple_cpu_pools.shcpu_busy_timenmon.multiple_cpu_pools.shcpu_tot_timenmon.multiple_cpu_pools.shcpus_in_sys
nmon.disk_%busynmon.disk_adapter.kb/snmon.disk_adapter.tpsnmon.disk_block_size
nmon.disk_io_average_reads_per_secondnmon.disk_io_average_writes_per_secondnmon.disk_io_reads_per_secondnmon.disk_io_writes_per_second
nmon.disk_read_kb/snmon.disk_read_service_time_msec/xfernmon.disk_service_time_msec/xfernmon.disk_transfers_per_secondnmon.disk_wait_queue_time_msec/xfernmon.disk_write_kb/snmon.disk_write_service_time_msec/xfer
nmon.file_i/o.dirblknmon.file_i/o.igetnmon.file_i/o.nameinmon.file_i/o.readchnmon.file_i/o.ttycanchnmon.file_i/o.ttyoutchnmon.file_i/o.ttyrawchnmon.file_i/o.writech
nmon.jfs_filespace_%usednmon.jfs_inode_%used
nmon.large_page_use.freepagesnmon.large_page_use.highwaternmon.large_page_use.pagesnmon.large_page_use.sizembnmon.large_page_use.usedpages
nmon.transfers_from_disk_(reads)_per_second
![Page 50: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/50.jpg)
50 Prepared by Axibase
Memory Metrics Memory Metrics Memory Metrics Memory Metrics Network Metrics
nmon.memory.real_free(mb)nmon.memory.real_free_%nmon.memory.real_total(mb)
nmon.memory.virtual_free(mb)nmon.memory.virtual_free_%nmon.memory.virtual_total(mb)
nmon.memory_mb.activenmon.memory_mb.bigfreenmon.memory_mb.buffersnmon.memory_mb.cachednmon.memory_mb.highfreenmon.memory_mb.hightotalnmon.memory_mb.inactivenmon.memory_mb.lowfreenmon.memory_mb.lowtotalnmon.memory_mb.memfreenmon.memory_mb.memsharednmon.memory_mb.memtotalnmon.memory_mb.swapcachednmon.memory_mb.swapfreenmon.memory_mb.swaptotal
nmon.memory_new.free%nmon.memory_new.fscache%nmon.memory_new.pinned%nmon.memory_new.process%nmon.memory_new.system%nmon.memory_new.user%
nmon.memory_use.%maxclientnmon.memory_use.%maxpermnmon.memory_use.%minpermnmon.memory_use.%numclientnmon.memory_use.%numperm
nmon.memory_use.lruable_pagesnmon.memory_use.maxfreenmon.memory_use.minfree
nmon.memorypages.cyclesnmon.memorypages.exfillsnmon.memorypages.maxfreenmon.memorypages.minfreenmon.memorypages.nonsys_pgsnmon.memorypages.numclientnmon.memorypages.numclsegpinnmon.memorypages.numclsegusenmon.memorypages.numcompressnmon.memorypages.numframesnmon.memorypages.numfrbnmon.memorypages.numiodonenmon.memorypages.numpermnmon.memorypages.numpermionmon.memorypages.numpgsp_pgsnmon.memorypages.numpoutnmon.memorypages.numpsegpinnmon.memorypages.numpsegusenmon.memorypages.numrallocnmon.memorypages.numremotenmon.memorypages.numsiosnmon.memorypages.numvpagesnmon.memorypages.numwsegpinnmon.memorypages.numwsegusenmon.memorypages.pageinsnmon.memorypages.pageoutsnmon.memorypages.pfavailnmon.memorypages.pfpinavailnmon.memorypages.pfrsvdblksnmon.memorypages.pgexctnmon.memorypages.pgrclmnmon.memorypages.pgspginsnmon.memorypages.pgspgoutsnmon.memorypages.pgstealsnmon.memorypages.scansnmon.memorypages.system_pgsnmon.memorypages.zerofills
nmon.paging_and_virtual.allocstallnmon.paging_and_virtual.kswapd_inodestealnmon.paging_and_virtual.kswapd_stealnmon.paging_and_virtual.nr_dirtynmon.paging_and_virtual.nr_mappednmon.paging_and_virtual.nr_page_table_pagesnmon.paging_and_virtual.nr_slabnmon.paging_and_virtual.nr_unstablenmon.paging_and_virtual.nr_writebacknmon.paging_and_virtual.pageoutrunnmon.paging_and_virtual.pgactivatenmon.paging_and_virtual.pgalloc_dmanmon.paging_and_virtual.pgalloc_highnmon.paging_and_virtual.pgalloc_normalnmon.paging_and_virtual.pgdeactivatenmon.paging_and_virtual.pgfaultnmon.paging_and_virtual.pgfreenmon.paging_and_virtual.pginodestealnmon.paging_and_virtual.pgmajfaultnmon.paging_and_virtual.pgpginnmon.paging_and_virtual.pgpgoutnmon.paging_and_virtual.pgrefill_dmanmon.paging_and_virtual.pgrefill_highnmon.paging_and_virtual.pgrefill_normalnmon.paging_and_virtual.pgrotatednmon.paging_and_virtual.pgscan_direct_dmanmon.paging_and_virtual.pgscan_direct_highnmon.paging_and_virtual.pgscan_direct_normalnmon.paging_and_virtual.pgscan_kswapd_dmanmon.paging_and_virtual.pgscan_kswapd_highnmon.paging_and_virtual.pgscan_kswapd_normalnmon.paging_and_virtual.pgsteal_dmanmon.paging_and_virtual.pgsteal_highnmon.paging_and_virtual.pgsteal_normalnmon.paging_and_virtual.pswpinnmon.paging_and_virtual.pswpoutnmon.paging_and_virtual.slabs_scanned
nmon.paging.cyclesnmon.paging.faultsnmon.paging.pginnmon.paging.pgoutnmon.paging.pgsinnmon.paging.pgsoutnmon.paging.reclaimsnmon.paging.scans
nmon.network_errors.collisionsnmon.network_errors.ierrsnmon.network_errors.oerrsnmon.network_i/o.read-kb/snmon.network_i/o.write-kb/snmon.network_packets.read/snmon.network_packets.reads/snmon.network_packets.write/snmon.network_packets.writes/snmon.network_size.readsizenmon.network_size.writesize
![Page 51: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/51.jpg)
nmon Predefined Portals
51 Prepared by Axibase
![Page 52: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/52.jpg)
52 Prepared by Axibase
Predefined AIX Portal
![Page 53: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/53.jpg)
53 Prepared by Axibase
Predefined Linux Portal
![Page 54: Axibase Time Series Database€¦ · Axibase Time Series Database 2 Prepared by Axibase Axibase Time-Series Database (ATSD) is a clustered non-relational database for the storage](https://reader031.vdocuments.us/reader031/viewer/2022020100/5ae76aff7f8b9a6d4f8e0c64/html5/thumbnails/54.jpg)
54 Prepared by Axibase
Contact Axibase
Axibase Contact Details:• General - 408.973.7897• Fax - 408.725.8885• Email - [email protected]
Our headquarters are located in Cupertino, Silicon Valley: • 19925 Stevens Creek Blvd. Cupertino, CA 95014 USA