Intel PowerStat and SQLite Integration

Input and output integration overview

Monitor power statistics on Intel-based platforms and is compatible with Linux-based operating systems. It helps in understanding and managing power efficiency and CPU performance.

Telegraf’s SQL output plugin stores metrics in an SQL database by creating tables dynamically for each metric type. When configured for SQLite, it utilizes a file-based DSN and a minimal SQL schema tailored for lightweight, embedded database usage.

Integration details

Intel PowerStat

The Intel PowerStat plugin is designed to monitor power statistics specifically on Intel-based platforms running a Linux operating system. It offers visibility into critical metrics such as CPU temperature, utilization, and power consumption, making it essential for power saving initiatives and workload migration strategies. By leveraging telemetry frameworks, this plugin enables users to gain insights into platform-level metrics that help with monitoring and analytics systems in the context of Management and Orchestration (MANO). It facilitates the ability to make informed decisions and perform corrective actions based on the state of the platform, ultimately contributing to better system efficiency and reliability.

SQLite

The SQL output plugin writes Telegraf metrics to an SQL database using a dynamic schema where each metric type corresponds to a table. For SQLite, the plugin uses the modernc.org/sqlite driver and requires a DSN in the format of a file URI (e.g., ‘file:/path/to/telegraf.db?cache=shared’). This configuration leverages standard ANSI SQL for table creation and data insertion, ensuring compatibility with SQLite’s capabilities.

Configuration

Intel PowerStat

[[inputs.intel_powerstat]]
  # package_metrics = ["current_power_consumption", "current_dram_power_consumption", "thermal_design_power"]
  # cpu_metrics = []
  # included_cpus = []
  # excluded_cpus = []
  # event_definitions = ""
  # msr_read_timeout = "0ms"

SQLite

[[outputs.sql]]
  ## Database driver
  ## Valid options: mssql (Microsoft SQL Server), mysql (MySQL), pgx (Postgres),
  ## sqlite (SQLite3), snowflake (snowflake.com), clickhouse (ClickHouse)
  driver = "sqlite"

  ## Data source name
  ## For SQLite, the DSN is a filename or URL with the scheme "file:".
  ## Example: "file:/path/to/telegraf.db?cache=shared"
  data_source_name = "file:/path/to/telegraf.db?cache=shared"

  ## Timestamp column name
  timestamp_column = "timestamp"

  ## Table creation template
  ## Available template variables:
  ##  {TABLE}        - table name as a quoted identifier
  ##  {TABLELITERAL} - table name as a quoted string literal
  ##  {COLUMNS}      - column definitions (list of quoted identifiers and types)
  table_template = "CREATE TABLE {TABLE} ({COLUMNS})"

  ## Table existence check template
  ## Available template variables:
  ##  {TABLE} - table name as a quoted identifier
  table_exists_template = "SELECT 1 FROM {TABLE} LIMIT 1"

  ## Initialization SQL (optional)
  init_sql = ""

  ## Maximum amount of time a connection may be idle. "0s" means connections are never closed due to idle time.
  connection_max_idle_time = "0s"

  ## Maximum amount of time a connection may be reused. "0s" means connections are never closed due to age.
  connection_max_lifetime = "0s"

  ## Maximum number of connections in the idle connection pool. 0 means unlimited.
  connection_max_idle = 2

  ## Maximum number of open connections to the database. 0 means unlimited.
  connection_max_open = 0

  ## Metric type to SQL type conversion
  ## The values on the left are the data types Telegraf has and the values on the right are the SQL types used when writing to SQLite.
  #[outputs.sql.convert]
  #  integer       = "INT"
  #  real          = "DOUBLE"
  #  text          = "TEXT"
  #  timestamp     = "TIMESTAMP"
  #  defaultvalue  = "TEXT"
  #  unsigned      = "UNSIGNED"
  #  bool          = "BOOL"

Input and output integration examples

Intel PowerStat

1. Optimizing Data Center Energy Usage: Monitor power consumption metrics across all CPUs in a data center. By capturing real-time data, administrators can identify which servers consume the most power and implement shutdowns or load balancing strategies during low demand periods, effectively reducing operational costs.

2. Dynamic Workload Migration Based on Power Efficiency: Integrate this plugin with a cloud orchestration tool to enable dynamic migration of workloads based on power usage metrics. If a particular server is recorded as consuming excessive power without corresponding output, the orchestrator can seamlessly migrate workloads to more efficient nodes, ensuring optimal resource utilization and lower energy expenses.

3. Monitoring and Alerting Mechanism for Overheating CPUs: Implement an alerting system using the CPU temperature metrics captured by Intel PowerStat. Setting thresholds for temperature can alert system administrators when a CPU is prone to overheating, allowing proactive measures to be taken before hardware damage occurs, ultimately extending the life of the components.

4. Performance Benchmarking for CPU-intensive Applications: Use the metrics provided to benchmark the performance of CPU-intensive applications. By analyzing the cpu_frequency, cpu_temperature, and power metrics under load, developers can optimize application performance and make informed decisions regarding scaling and resource allocation.

SQLite

1. Local Monitoring Storage: Configure the plugin to write metrics to a local SQLite database file. This is ideal for lightweight deployments where setting up a full-scale database server is not required.
2. Embedded Applications: Use SQLite as the backend for applications embedded in edge devices, benefiting from its file-based architecture and minimal resource requirements.
3. Quick Setup for Testing: Leverage SQLite’s ease of use to quickly set up a testing environment for Telegraf metrics collection without the need for external database services.
4. Custom Schema Management: Adjust the table creation templates to predefine your schema if you require specific column types or indexes, ensuring compatibility with your application’s needs.

Feedback

Thank you for being part of our community! If you have any general feedback or found any bugs on these pages, we welcome and encourage your input. Please submit your feedback in the InfluxDB community Slack.