skills.rest
sirius-db
sirius-dbOFFICIAL
Explore all skills by this author →
GitHub

config-optimizer

Optimize Sirius database configurations for TPC-H workloads across scale factors.

1.0k|109|Updated Jun 19, 2024
Search Tags:#optimization#configuration#performance tuning#sirius#tpc-h#gpu utilization
One-click install
npx skills add https://github.com/sirius-db/sirius --skill config-optimizer-sirius-db
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: config-optimizer
Source: https://github.com/sirius-db/sirius/tree/main/.claude/skills/config-optimizer
Command: npx skills add https://github.com/sirius-db/sirius --skill config-optimizer-sirius-db

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps users find the optimal configuration for the Sirius database system when running TPC-H benchmarks at various scale factors, aiming to maximize performance and GPU utilization.

Core Features & Use Cases

  • Systematic Configuration Tuning: Explores a defined set of Sirius configuration parameters to identify optimal settings.
  • Performance Evaluation: Uses an optimization advisor to measure performance metrics like query latency and GPU utilization.
  • TPC-H Benchmark Focus: Specifically designed for optimizing Sirius performance on TPC-H datasets.

Quick Start

Use the config-optimizer skill to find the optimal configuration for sirius running TPCH at scale factor 10.

Frequently Asked Questions about config-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize Sirius database configuration for TPC-H workloads?▼

To optimize Sirius database configuration for TPC-H, systematically adjust parameters like thread counts, cache modes, and batch sizes through baseline evaluation and iterative patching script testing to maximize performance.

What parameters should I tune to maximize GPU utilization in Sirius?▼

Maximizing GPU utilization in Sirius requires tuning configuration parameters such as thread counts, cache modes, and batch sizes, systematically tested across your specific TPC-H workload scale factor.

Can I use this configuration optimizer for TPC-H benchmarks at any scale factor?▼

Yes, the configuration optimizer supports TPC-H benchmarks across different scale factors, evaluating baseline performance and applying iterative parameter adjustments to find the optimal settings.

What is the process for performance tuning a Sirius database system?▼

Performance tuning a Sirius database system involves establishing a baseline, running iterative tests using a patching script to adjust configurations, and generating a final report of optimal settings.

Does the Sirius configuration optimizer require manual parameter testing?▼

No, the Sirius configuration optimizer automates parameter testing by using an optimization advisor and a patching script to systematically explore and evaluate different configuration settings.

Why does my Sirius TPC-H performance vary between different scale factors?▼

Sirius TPC-H performance varies between scale factors because optimal configurations depend on adjusting thread counts, cache modes, and batch sizes specific to the dataset size and workload.

Related Skills

Explore More Software Engineering Skills→
kindoflukekindofluke

config-optimizer

Identify optimal Sirius configurations for TPC-H workloads across scale factors.

Community
Advanced
sirius-dbsirius-db
1.0k

tpcds-benchmark

Execute TPC-DS benchmarks across Legacy Sirius, Super Sirius, and DuckDB CPU engines.

Official
Advanced
kindoflukekindofluke

dataset-manager

Generate, inspect, consolidate, and optimize TPC-H parquet datasets for Sirius benchmarking.

Community
Advanced
manutejmanutej
61

observability-monitoring

Configure Prometheus metric collection, PromQL queries, Grafana dashboards, and Alertmanager routing.

Community
Advanced