skills/maxnorm/magento2-agent-skills/magento-performance-analyst

magento-performance-analyst

SKILL.md

Magento 2 Performance Analyst

Expert specialist in conducting comprehensive performance analysis and implementing systematic optimizations that deliver measurable improvements in application speed, scalability, and user experience.

When to Use

  • Analyzing performance bottlenecks
  • Profiling applications
  • Optimizing database queries
  • Improving system scalability
  • Conducting load testing
  • Optimizing frontend performance

Performance Analysis

Profiling Tools

  • Blackfire: Performance profiling and optimization
  • XHProf: PHP profiling tool
  • New Relic: APM monitoring
  • Browser DevTools: Frontend performance analysis
  • Database Profiling: Query profiling and analysis

Bottleneck Identification

  • Code Profiling: Identify slow functions and performance hotspots
  • Database Analysis: Analyze slow queries and database performance
  • Network Analysis: Identify network latency and bandwidth issues
  • Resource Contention: Identify resource conflicts and bottlenecks
  • Third-party Integration: Analyze external service performance impact

Performance Optimization Areas

Frontend Performance

  • Core Web Vitals: Optimize LCP, FID, CLS, and other web vitals
  • JavaScript Optimization: Minimize and optimize JavaScript execution
  • CSS Optimization: Optimize stylesheet delivery and rendering
  • Image Optimization: Modern image formats and responsive loading
  • Asset Optimization: Minimize and compress assets

Database Optimization

  • Query Optimization: Optimize database queries and eliminate N+1 problems
  • Index Strategy: Design efficient database indexing
  • Connection Pooling: Optimize database connection management
  • Query Caching: Implement query result caching
  • Database Tuning: Tune database configuration for performance

Application Optimization

  • Code Optimization: Optimize PHP code execution
  • Memory Management: Optimize memory usage and detect leaks
  • Caching Strategy: Implement comprehensive caching strategies
  • Resource Management: Optimize CPU, I/O, and network resources
  • Lazy Loading: Implement lazy loading for expensive operations

Performance Analysis Process

1. Performance Assessment

  • Baseline Establishment: Establish current performance baselines and metrics
  • User Experience Analysis: Analyze real user performance and experience
  • System Resource Analysis: Assess CPU, memory, disk, and network usage
  • Application Profiling: Deep application profiling and code analysis
  • Infrastructure Assessment: Evaluate infrastructure performance and capacity

2. Bottleneck Identification

  • Code Profiling: Identify slow functions and performance hotspots
  • Database Analysis: Analyze slow queries and database performance
  • Network Analysis: Identify network latency and bandwidth issues
  • Resource Contention: Identify resource conflicts and bottlenecks
  • Third-party Integration: Analyze external service performance impact

3. Optimization Planning

  • Priority Matrix: Prioritize optimizations based on impact and effort
  • Resource Planning: Plan resource requirements for optimizations
  • Risk Assessment: Assess risks associated with performance changes
  • Testing Strategy: Plan comprehensive testing for optimization changes
  • Rollback Planning: Prepare rollback strategies for optimization failures

4. Implementation & Validation

  • Optimization Implementation: Implement systematic performance improvements
  • Performance Testing: Validate optimization effectiveness through testing
  • Monitoring Setup: Implement monitoring for sustained performance
  • Documentation: Document optimization changes and performance gains
  • Continuous Monitoring: Establish ongoing performance monitoring

Performance Metrics

Key Metrics

  • Page Load Time: Total page load time
  • Time to First Byte (TTFB): Server response time
  • Largest Contentful Paint (LCP): Loading performance
  • First Input Delay (FID): Interactivity
  • Cumulative Layout Shift (CLS): Visual stability

Database Metrics

  • Query Execution Time: Database query performance
  • Slow Query Count: Number of slow queries
  • Connection Pool Usage: Database connection efficiency
  • Index Usage: Index effectiveness
  • Cache Hit Rate: Cache performance

Best Practices

Optimization Strategy

  • Measure First: Always measure before optimizing
  • Prioritize High Impact: Focus on optimizations with highest impact
  • Incremental Approach: Make incremental improvements
  • Test Thoroughly: Test all optimizations thoroughly
  • Monitor Continuously: Monitor performance continuously

Scalability Planning

  • Horizontal Scaling: Design for horizontal scaling
  • Vertical Scaling: Optimize for vertical scaling when needed
  • Load Balancing: Implement proper load balancing
  • Resource Planning: Plan for resource growth
  • Performance Budgets: Set and maintain performance budgets

Tools & Commands

Profiling Commands

# Enable developer mode for profiling
bin/magento deploy:mode:set developer

# Check performance
bin/magento setup:performance:generate-fixtures

# Database status
bin/magento setup:db:status

Monitoring

  • Set up APM tools (New Relic, Datadog, etc.)
  • Monitor server resources (CPU, memory, disk)
  • Track application metrics
  • Set up alerts for performance degradation

References

Focus on systematic performance analysis and optimization that delivers measurable improvements.

Weekly Installs
64
GitHub Stars
6
First Seen
Feb 11, 2026
Installed on
opencode61
codex61
gemini-cli59
github-copilot58
kimi-cli58
amp57