frappe-ops-performance

Tune MariaDB, Redis, Gunicorn, and CDN configurations for Frappe/ERPNext deployments.

163|53|Updated Jan 14, 2026
One-click install
npx skills add https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package --skill frappe-ops-performance
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: frappe-ops-performance
Source: https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package/tree/main/skills/source/ops/frappe-ops-performance
Command: npx skills add https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package --skill frappe-ops-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Production deployments of Frappe/ERPNext often suffer from misconfigured database, cache, and app server settings, leading to slow queries, timeouts, and unstable performance.

Core Features & Use Cases

  • MariaDB tuning and query optimization
  • Redis memory management and caching improvements
  • Gunicorn worker sizing and RQ worker tuning
  • CDN integration and static asset delivery
  • Slow query log analysis and Python profiling
  • Production-grade deployment guidance for reliability and observability

Quick Start

Apply the recommended tuning steps in a staging environment and verify measurable performance improvements.

Frequently Asked Questions about frappe-ops-performance

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

FAQPage Schema
How do I tune MariaDB for slow queries in a Frappe ERPNext deployment?

To tune MariaDB for slow queries in a Frappe ERPNext deployment, you need to analyze the slow query log and apply database tuning configurations. This optimization resolves memory bottlenecks and stabilizes production performance.

Why does Frappe experience high memory usage and cache misses in production?

Frappe experiences high memory usage and cache misses in production due to misconfigured Redis memory management. Adjusting Redis caching settings and application server sizing directly addresses these memory bottlenecks.

What's the best way to size Gunicorn workers for high concurrency in ERPNext?

The best way to size Gunicorn workers for high concurrency in ERPNext is to tune the application server configurations based on your deployment's resource limits. Proper Gunicorn worker tuning handles high concurrency and prevents timeouts.

Does this Frappe performance tuning guidance apply to both on-prem and cloud deployments?

Yes, this Frappe performance tuning guidance applies to both on-prem and cloud deployments running Frappe v14 through v16. It provides production-grade deployment guidance for reliability and observability across different environments.

Can I use Python profiling workflows to fix Frappe application server timeouts?

Yes, you can use Python profiling workflows to fix Frappe application server timeouts by identifying slow processing logic. Combining profiling with Gunicorn worker tuning and CDN integration optimizes static asset delivery.

What are the limitations when applying CDN integration to Frappe static assets?

A limitation when applying CDN integration to Frappe static assets is that misconfigured cache and app server settings can still cause unstable performance. You must verify measurable improvements in a staging environment before production deployment.