Tony

# スロークエリ調査
@tony analyze slow queries on production PostgreSQL

# 特定のパフォーマンスターゲット
@tony identify queries with execution time >2 seconds on orders database

# 実行プラン分析
@tony analyze execution plans for the 20 slowest queries

# クエリパターン
@tony find queries that could benefit from caching

# インデックス推奨
@tony analyze missing indexes that would improve performance by >10%

# 接続最適化
@tony review connection pooling configuration for high-load scenarios

# 設定チューニング
@tony optimize MySQL 8.0 configuration for high-throughput OLTP with 10k connections

# リソース分析
@tony identify queries consuming >5% of total database CPU

# ヘルスチェック
@tony check database health and performance metrics

# レプリケーション状況
@tony assess replication lag and recommend optimization

# ストレージ分析
@tony analyze database growth patterns and recommend archiving strategy

# 接続分析
@tony analyze connection usage patterns and identify connection leaks

# バックアップ検証
@tony verify backup status and recovery procedures for production databases

# DR 計画
@tony create disaster recovery plan with RTO/RPO analysis

# リカバリテスト
@tony recommend backup testing strategy for production databases

@tony #dashboard database performance metrics for production cluster
@tony #report query performance analysis with optimization plan
@tony #recommend index optimizations prioritized by impact
@tony #alert when P95 query latency exceeds 500ms

# 良い例
@tony analyze queries with
execution time >2 seconds
running >100 times daily

# 避けるべき例
@tony make database faster

# 良い例
@tony optimize MySQL 8.0
for read-heavy workloads
with 10k concurrent connections

# 避けるべき例
@tony check the database

# Step 1: 特定
@tony identify top 10 slowest queries in last hour

# Step 2: 分析
@tony analyze execution plans for problematic queries

# Step 3: 最適化
@tony #recommend index changes and query rewrites

# Step 4: 監視
@tony #dashboard real-time query performance

# Step 1: ベースライン
@tony #dashboard current performance metrics

# Step 2: 分析
@tony identify optimization opportunities across all databases

# Step 3: 優先順位付け
@tony #recommend optimizations ranked by impact and effort

# Step 4: 自動化
@tony #schedule weekly performance review

# Step 1: 成長分析
@tony analyze database growth patterns over last 6 months

# Step 2: 予測
@tony predict storage and compute needs for next year

# Step 3: 計画
@tony #recommend scaling strategy with cost analysis