andykillen/wcnl-2023

Details of sources used, and spreadsheet for calculations

wcnl-2023 Sources used for the presentation.

• The presentation
• Forbes: stats on E-Commerce
• Servebolt Optimizer plugin to add db performance optimization
• How to Estimate How Many Website Visitors Your Hosting Can Deal With

# number of processors
grep processor /proc/cpuinfo | wc -l

# max page requests
Number of CPU cores / Average time for a page request (in seconds) = Max Page Requests per second

# max users
Max Page Requests per second * 60 * Click frequency of users in seconds = Maximum Number of Simultaneous Users

• Spreadsheet for Estimatation
• Profiling SQL Query performance
• PHP Bench & WP Bench on E-commerce, 2023 results
• Setup REDIS to deal with PHP Session data
• Galera cluster
• Query Monitor
• Taxonomy query example code
• Quick import example code
• Product Flow