We’ve already:
- Optimized PHP settings (memory_limit at 768M, execution time unlimited)
- Verified all necessary modules are installed
- Confirmed OPcache is properly configured
- Set up proper error logging
The site has:
- 36,000+ orders
- 150+ members
- 100+ students per semester
- WooCommerce subscriptions
- Custom kiln firing calculator system
- TeraWallet for in-house credits
- Inventory management for glazes and products
- Custom registration system
- GSAP animations
- Receipt printing system for kiln space
- Plans to add reservation system for wheel and glaze room
- Member marketplace functionality
Now we’re moving on to MySQL optimization to handle this load effectively.
Previous MariaDB findings:
MariaDB 10.6.20-MariaDB-cll-lve
Current settings show:
- innodb_buffer_pool_size: 118MB (too small)
- query_cache_size: 1MB (very small)
- query_cache_type: OFF
- table_open_cache: 2000