Nvidia SMI and MariaDB Integration

Input and output integration overview

<p>The Nvidia SMI Plugin enables the retrieval of detailed statistics about NVIDIA GPUs attached to the host system, providing essential insights for performance monitoring.</p>

<p>This plugin writes metrics from Telegraf directly into MariaDB using parameterized SQL INSERT statements, offering a flexible way to store metrics in structured, relational tables.</p>

Integration details

Nvidia SMI

<p>The Nvidia SMI Plugin is designed to gather metrics regarding the performance and status of NVIDIA GPUs on the host machine. By leveraging the capabilities of the <code>nvidia-smi</code> command-line tool, this plugin pulls crucial information such as GPU memory utilization, temperature, fan speed, and various performance metrics. This data is essential for monitoring GPU health and performance in real-time, particularly in environments where GPU performance directly impacts computing tasks, such as machine learning, 3D rendering, and high-performance computing. The plugin provides flexibility by allowing users to specify the path to the <code>nvidia-smi</code> binary and configure polling timeouts, accommodating both Linux and Windows systems where the <code>nvidia-smi</code> tool is commonly located. With its ability to collect detailed statistics on each GPU, this plugin becomes a vital resource for any infrastructure relying on NVIDIA hardware, facilitating proactive management and performance tuning.</p>

MariaDB

<p>The SQL output plugin in Telegraf enables direct writing of metrics into SQL-compatible databases like MariaDB by executing parameterized SQL statements. With support for the MySQL driver, the plugin seamlessly integrates with MariaDB for reliable, structured metric storage. This setup is ideal for users who prefer SQL-based analytics or want to store metrics alongside business data for unified querying. MariaDB is a community-developed, enterprise-grade fork of MySQL that emphasizes performance, security, and openness. The plugin supports inserting time series metrics into custom schemas, enabling flexible analytics and integrations with BI tools like Metabase or Grafana using SQL connectors.</p>

Configuration

Nvidia SMI

MariaDB

Input and output integration examples

Nvidia SMI

<ol> <li> <p><strong>Real-Time GPU Monitoring for ML Training</strong>: Continuously monitor the GPU utilization and memory usage during machine learning model training. This enables data scientists to ensure that their GPUs are not being overutilized or underutilized, optimizing resource allocation and reviewing performance bottlenecks in real-time.</p> </li> <li> <p><strong>Automated Alerts for Overheating GPUs</strong>: Implement a system using the Nvidia SMI plugin to track GPU temperatures and set alerts for instances where temperatures exceed safe thresholds. This proactive monitoring can prevent hardware damage and improve system reliability by alerting administrators to potential cooling issues before they result in failure.</p> </li> <li> <p><strong>Performance Baselines for GPU Resources</strong>: Establish baseline performance metrics for your GPU resources. By regularly collecting data and analyzing trends in GPU usage, organizations can identify anomalies and optimize their workloads accordingly, leading to enhanced operational efficiency.</p> </li> <li> <p><strong>Dockerized GPU Usage Insights</strong>: In a containerized environment, use the plugin to monitor GPU performance from within a Docker container. This allows developers to track GPU performance of their applications in production, facilitating troubleshooting and performance optimization within isolated environments.</p> </li> </ol>

MariaDB

<ol> <li> <p><strong>Business Intelligence Integration</strong>: Store application performance metrics directly into MariaDB and connect it to BI tools like Metabase or Apache Superset. This setup allows blending of operational data with business KPIs for unified dashboards, enhancing visibility across departments.</p> </li> <li> <p><strong>Compliance Reporting with Historical Metrics</strong>: Use this plugin to log metrics into MariaDB for audit and compliance use cases. The relational model enables precise querying of past performance indicators with timestamped entries, supporting regulatory documentation.</p> </li> <li> <p><strong>Custom Alerting Based on SQL Logic</strong>: Insert metrics into MariaDB and use custom SQL queries to define alert thresholds or conditions. Combined with cron jobs or scheduled scripts, this enables advanced alerting workflows not possible with traditional metric platforms.</p> </li> <li> <p><strong>IoT Sensor Metrics Storage</strong>: Collect sensor data from IoT devices via Telegraf and store it in MariaDB using a normalized schema. This approach is cost-effective and integrates well with existing SQL-based systems for real-time or historical analysis.</p> </li> </ol>

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.