Skip to content

Instantly share code, notes, and snippets.

@lcatlett

lcatlett/binding_binding_1a49ea8f28df49aca3c6807386976633.json

Created July 23, 2025 23:56
Show Gist options
  • Save lcatlett/15b7bbb20700050a4e2b5e0c2d3c2ef3 to your computer and use it in GitHub Desktop.
Save lcatlett/15b7bbb20700050a4e2b5e0c2d3c2ef3 to your computer and use it in GitHub Desktop.
Download ZIP
Pantheon Binding Audit Report - Site: 4e9372f2-e74f-43d2-9245-fc45643f2624 (live) - 2025-07-23 19:56:23
Raw
binding_binding_1a49ea8f28df49aca3c6807386976633.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:55:12Z",
"binding_id": "1a49ea8f28df49aca3c6807386976633",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/1a49ea8f28df49aca3c6807386976633",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "da4b451c-b275-41c7-8eb5-d2871921cbee"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 49,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2596,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 183523,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 928,
"url_patterns": [],
"cascade_indicators": [
" 928 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 928,
"worker_waste_percent": 0,
"response_distribution": "200:556 404:182 403:180 304:69 301:6 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/images/custom/bio_curran_annamarie_24.jpg(10658535.0s) /sites/default/files/images/custom/bio_Courtney_Matthew_19.jpg(8521540.0s) /sites/default/files/images/custom/bio_kauffman_graham_24_v2.jpg?odnHeight=372&odnWidth=372&odnBg=FFFFFF(5068583.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 928 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 19,
"nginx_error_logs": 5,
"php_logs": 3,
"total_log_size_mb": 12
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_2a79f40197924801af6f6288301a6052.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:55:12Z",
"binding_id": "2a79f40197924801af6f6288301a6052",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/2a79f40197924801af6f6288301a6052",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "807843b8-2338-4e41-b5de-16e6c66446f7"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 14158,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 14158,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 10,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 12.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 896,
"url_patterns": [],
"cascade_indicators": [
" 896 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"393 user 499s > 170 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 393,
"bot_499s": 170,
"avg_499_response_time": 0.00,
"long_running_requests": 896,
"worker_waste_percent": 0,
"response_distribution": "200:661 404:135 403:72 304:69 499:34 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/PSC_2024_Proxy_Statement_0.pdf(5601905.0s) /sites/default/files/document/PSC_2023_Annual_Report.pdf(4824558.0s) /sites/default/files/document/4Q22_Investor_Deck.pdf(3498434.0s) ",
"top_499_urls": "/pantheon_healthcheck(27) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(22) /api/secfilingslastpagenumber(6) ",
"top_499_user_agents": "Mozilla/5.0(150) Mozilla/5.0(71) Pingdom.com_bot_version_1.4_(http://www.pingdom.com/)(27) ",
"cascade_indicators": [" 896 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","393 user 499s > 170 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 170,
"user_499s": 393,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 9
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (393 user vs 170 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_31df242b1d454a1abaddd8f659139816.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:53:58Z",
"binding_id": "31df242b1d454a1abaddd8f659139816",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/31df242b1d454a1abaddd8f659139816",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "26a472ee-f2df-438d-965c-d7dac0b8ac7e"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 15931,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 15931,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 11,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 13.8
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 926,
"url_patterns": [],
"cascade_indicators": [
" 926 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"363 user 499s > 173 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 363,
"bot_499s": 173,
"avg_499_response_time": 0.00,
"long_running_requests": 926,
"worker_waste_percent": 0,
"response_distribution": "200:680 404:141 403:77 304:58 301:18 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/HCM_update_April2023_1.pdf(7757998.0s) /sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(23) /pantheon_healthcheck(17) /accessibility(6) ",
"top_499_user_agents": "Mozilla/5.0(113) Mozilla/5.0(49) Mozilla/5.0(31) ",
"cascade_indicators": [" 926 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","363 user 499s > 173 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 173,
"user_499s": 363,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 4,
"nginx_error_logs": 1,
"php_logs": 4,
"total_log_size_mb": 19
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (363 user vs 173 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_75c116a1e2de46c99a37461cdcd686a7.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:55:10Z",
"binding_id": "75c116a1e2de46c99a37461cdcd686a7",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/75c116a1e2de46c99a37461cdcd686a7",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "d00ef372-a5e6-4ac6-a62e-45bb5125497a"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 2959,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2959,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189262,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 889,
"url_patterns": [],
"cascade_indicators": [
" 889 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"77 user 499s > 28 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 77,
"bot_499s": 28,
"avg_499_response_time": 0.00,
"long_running_requests": 889,
"worker_waste_percent": 0,
"response_distribution": "200:652 404:125 304:79 403:67 499:32 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/2024_PiperSandler_Sustainability_Report.pdf(6588716.0s) ",
"top_499_urls": "/pantheon_healthcheck(5) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(5) /about/people/michael-lund(4) ",
"top_499_user_agents": "Mozilla/5.0(17) Mozilla/5.0(15) Mozilla/5.0(7) ",
"cascade_indicators": [" 889 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","77 user 499s > 28 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 28,
"user_499s": 77,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 3
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations"
]
}
Raw
binding_binding_7b567f7c87804920bfacd8d155f5dedc.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:53:56Z",
"binding_id": "7b567f7c87804920bfacd8d155f5dedc",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/7b567f7c87804920bfacd8d155f5dedc",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "cd74d7d0-9da2-47ee-ace5-6a0e1c6cde39"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 13,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 13,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 44820,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 0,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 0.0
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 13,
"url_patterns": [],
"cascade_indicators": [
" 13 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 13,
"worker_waste_percent": 0,
"response_distribution": "200:8 404:2 403:2 301:1 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/js/js_wtay8gQvEEeLzNOpkvK8QAzqTLcjeMImlXq0U2ROGwk.js?scope=footer&delta=0&language=en&theme=pipersandler&include=eJx1zlEOwzAIA9ALLd2ZPEK2SAkgYOr1x2-l9dd-lmzT2APSF_uTdJsKSx6UaC9429qxHvYfjbmy8ms9VBInh26-FgbH22Gfg4rUvhG8xx0ajPw695YOCVBOlVssfMbirDcNROq98A_SaVZH(189262.0s) /sites/default/files/styles/large/public/images/custom/group-2-technologies.png.webp?itok=3zfKG-nm(44820.0s) /sites/default/files/styles/large/public/images/custom/pacira_biosciences_inc_slide_1_image.jpg?itok=X3Bmz1ST(16061.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 13 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 1
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_8092a78191df42beb1585e9c99b77b14.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:55:12Z",
"binding_id": "8092a78191df42beb1585e9c99b77b14",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/8092a78191df42beb1585e9c99b77b14",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "2420afdf-5aaa-4d1f-8f3b-951bbda7ddd7"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 43,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2504,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 182806,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 922,
"url_patterns": [],
"cascade_indicators": [
" 922 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 922,
"worker_waste_percent": 0,
"response_distribution": "200:557 404:178 403:171 304:77 302:8 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/images/custom/istock-1328677020_conf_room.jpg(10761504.0s) /sites/default/files/images/custom/NYC_horizontal-fullwidth.jpg(5508809.0s) /sites/default/files/images/custom/bio_niggel_joe_24.jpg(3140826.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 922 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_8488e465ba93461ab44b35a19f0903ac.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:53:57Z",
"binding_id": "8488e465ba93461ab44b35a19f0903ac",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/8488e465ba93461ab44b35a19f0903ac",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "0f6bd5a9-a227-4eea-93a6-49c03e9041a5"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 14797,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 14797,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 124704,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 10,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 12.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 910,
"url_patterns": [],
"cascade_indicators": [
" 910 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"333 user 499s > 144 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 333,
"bot_499s": 144,
"avg_499_response_time": 0.00,
"long_running_requests": 910,
"worker_waste_percent": 0,
"response_distribution": "200:687 404:121 403:71 304:64 499:26 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/Heartland_Summit_2022_Recap.pdf(10429633.0s) /sites/default/files/document/code_of_ethics_policy_2024.pdf(6748031.0s) /sites/default/files/document/PJC-Q4-2016-10K-FILED-w-EXHIBITS.pdf(6064911.0s) ",
"top_499_urls": "/pantheon_healthcheck(17) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(12) /conferences-and-events(5) ",
"top_499_user_agents": "Mozilla/5.0(137) Mozilla/5.0(38) Mozilla/5.0(27) ",
"cascade_indicators": [" 910 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","333 user 499s > 144 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 144,
"user_499s": 333,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 2,
"nginx_error_logs": 1,
"php_logs": 4,
"total_log_size_mb": 12
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (333 user vs 144 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_b6bec5d9e7504be9991acb29df8eb576.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:53:59Z",
"binding_id": "b6bec5d9e7504be9991acb29df8eb576",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/b6bec5d9e7504be9991acb29df8eb576",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "75428e69-7b14-4bb3-8d53-3378e0cb5430"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 41,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 875,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 158063,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 1,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 1.2
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 817,
"url_patterns": [],
"cascade_indicators": [
" 817 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 1,
"user_499s": 1,
"bot_499s": 0,
"avg_499_response_time": 0.00,
"long_running_requests": 817,
"worker_waste_percent": 0,
"response_distribution": "200:513 403:148 404:147 304:55 302:5 ",
"cascade_stats": "Count: 1, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/images/custom/esckilsen_christine_testimonial.png(22190911.0s) /sites/default/files/images/custom/tedesco_sam_testimonial.png(13258272.0s) /sites/default/files/images/custom/gettyimages-1252668228-careers.jpg(10342367.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(1) ",
"top_499_user_agents": "Mozilla/5.0(1) ",
"cascade_indicators": [" 817 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 1,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 3,
"nginx_error_logs": 2,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_cec117893fd444d3b02697f3e8768ad5.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:55:10Z",
"binding_id": "cec117893fd444d3b02697f3e8768ad5",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/cec117893fd444d3b02697f3e8768ad5",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "b8d6ae27-ea2d-4fab-ad0a-daafa089d3f2"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 3083,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 3083,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189466,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 920,
"url_patterns": [],
"cascade_indicators": [
" 920 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"64 user 499s > 26 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 64,
"bot_499s": 26,
"avg_499_response_time": 0.00,
"long_running_requests": 920,
"worker_waste_percent": 0,
"response_distribution": "200:696 404:123 403:68 304:60 301:19 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/2024_PiperSandler_Sustainability_Report.pdf(6588716.0s) /sites/default/files/document/Conference-Recap_Web16.pdf(5763668.0s) /sites/default/files/document/Piper_Sandler_Sustainability_Report_2023.pdf(4628038.0s) ",
"top_499_urls": "/pantheon_healthcheck(8) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(8) /sites/default/files/css/css_6CZOAAPg-fLRPxFVxj-5l3fCFBePZ8hNH3UtRMBGeA8.css?delta=0&language=en&theme=pipersandler&include=eJx1UdFuwyAM_CEEnxQ54BC3BjMMa7OvH8taVVXSF3O-404GeyjNr-BmUDSeQXV7wwlVIaI--yxhaFJxoJqA6QfN5atj3aZOU4CGhfwVq3tBU6BCrFBWdaH2AmxfjO259JlJVwymUMGqkAOPgCgSGe0iuem7om0bwj7lCe8lFcn4wcWwSW9nSm_E1Gg8VcUT8JQwEExM-aruSNm2YkLzTXhTt1ebJHRGc8N5GX_jHqeFC9wPJPJw52YDNiAeaRLjifd5bWG8z_I55rGmg_5XDuQ-uf1f6C8_K8ia(3) ",
"top_499_user_agents": "Mozilla/5.0(17) Mozilla/5.0(9) Pingdom.com_bot_version_1.4_(http://www.pingdom.com/)(8) ",
"cascade_indicators": [" 920 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","64 user 499s > 26 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 26,
"user_499s": 64,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 3
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations"
]
}
Raw
binding_binding_df47046c10294c128695b9ec9001464c.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:53:58Z",
"binding_id": "df47046c10294c128695b9ec9001464c",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/df47046c10294c128695b9ec9001464c",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "5806624d-54ef-41bb-bb96-b4523c406716"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 9580,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 9580,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189262,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 7,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 8.8
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"url_patterns": [],
"cascade_indicators": [
" 915 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"192 user 499s > 113 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 192,
"bot_499s": 113,
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"worker_waste_percent": 0,
"response_distribution": "200:651 404:152 403:81 304:66 301:19 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/Piper_Sandler_2023_Automotive_Service_Year_in_Review.pdf(7568103.0s) /sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/Simmons_Energy_18th_Annual_Recap.pdf(6539683.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(22) /pantheon_healthcheck(17) /locations(6) ",
"top_499_user_agents": "Mozilla/5.0(34) Mozilla/5.0(29) Mozilla/5.0(23) ",
"cascade_indicators": [" 915 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","192 user 499s > 113 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 113,
"user_499s": 192,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 30,
"nginx_error_logs": 5,
"php_logs": 4,
"total_log_size_mb": 50
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (192 user vs 113 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_e9d931b9014d484fbdca82db24732401.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:56:17Z",
"binding_id": "e9d931b9014d484fbdca82db24732401",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/e9d931b9014d484fbdca82db24732401",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "eabd6d3d-b484-4b70-ad2b-8073006b26db"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 28,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 28,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 83465,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 0,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 0.0
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 25,
"url_patterns": [],
"cascade_indicators": [
" 25 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 25,
"worker_waste_percent": 0,
"response_distribution": "200:19 404:4 304:3 403:2 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/document/021025_CAMarketUpdate.pdf(480260.0s) /sites/default/files/images/custom/bio_okeefe_kevin_22.jpg(117558.0s) /sites/default/files/images/custom/One-Equity-Partners.png(83465.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 25 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 1
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_f4f01c8a31704c5f85c297d0814e943d.json
{
"audit_metadata": {
"timestamp": "2025-07-23T23:56:18Z",
"binding_id": "f4f01c8a31704c5f85c297d0814e943d",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/f4f01c8a31704c5f85c297d0814e943d",
"date_range": {
"start_date": "2025-07-22",
"end_date": "2025-07-23",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "a595034e-817f-4d7f-bbf8-569be82b6a76"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 35,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2847,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 928,
"url_patterns": [],
"cascade_indicators": [
" 928 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 2,
"user_499s": 2,
"bot_499s": 0,
"avg_499_response_time": 0.00,
"long_running_requests": 928,
"worker_waste_percent": 0,
"response_distribution": "200:570 403:202 404:149 304:70 301:4 ",
"cascade_stats": "Count: 2, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/images/custom/tedesco_sam_testimonial.png(13258272.0s) /sites/default/files/images/custom/gettyimages-1252668228-careers.jpg(10342367.0s) /sites/default/files/images/custom/bio_binette_ryan_24.jpg(9926321.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(2) ",
"top_499_user_agents": "Mozilla/5.0(2) ",
"cascade_indicators": [" 928 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 2,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
summary_recommendations.json
{
"recommendations_metadata": {
"timestamp": "2025-07-23T23:56:22Z",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"total_bindings_analyzed": 12,
"bindings_with_recommendations": 6
},
"summary": {
"critical_actions_count": 10,
"warning_actions_count": 10,
"optimization_opportunities_count": 0,
"affected_bindings_count": 6
},
"critical_actions": [
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (192 user vs 113 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (333 user vs 144 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (393 user vs 170 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (363 user vs 173 bot)"
],
"warning_actions": [
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues"
],
"optimization_opportunities": [
],
"affected_bindings": [
"cec117893fd444d3b02697f3e8768ad5",
"df47046c10294c128695b9ec9001464c",
"8488e465ba93461ab44b35a19f0903ac",
"2a79f40197924801af6f6288301a6052",
"75c116a1e2de46c99a37461cdcd686a7",
"31df242b1d454a1abaddd8f659139816"
]
}
Raw
summary_site_summary.json
{
"summary_metadata": {
"timestamp": "2025-07-23T23:56:22Z",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"binding_count": 12,
"audit_version": "1.0"
},
"site_overview": {
"site_name": "piper-sandler-co",
"plan_name": "Elite",
"service_level": "elite_1m",
"total_bindings": 12,
"overall_severity": "CRITICAL"
},
"aggregated_metrics": {
"total_requests_today": 60717,
"total_requests_week": 69371,
"total_499_errors_today": 0,
"total_499_errors_week": 0,
"total_502_errors_today": 0,
"total_502_errors_week": 0,
"overall_error_rate_today_percent": 0.00,
"overall_error_rate_percent": 0.00
},
"binding_health": {
"critical_bindings": 6,
"warning_bindings": 0,
"healthy_bindings": 6,
"health_distribution_percent": {
"critical": 50.0,
"warning": 0.0,
"healthy": 50.0
}
},
"binding_reports": [
{"binding_id": "8092a78191df42beb1585e9c99b77b14", "report_file": "binding_8092a78191df42beb1585e9c99b77b14.json"},
{"binding_id": "b6bec5d9e7504be9991acb29df8eb576", "report_file": "binding_b6bec5d9e7504be9991acb29df8eb576.json"},
{"binding_id": "1a49ea8f28df49aca3c6807386976633", "report_file": "binding_1a49ea8f28df49aca3c6807386976633.json"},
{"binding_id": "7b567f7c87804920bfacd8d155f5dedc", "report_file": "binding_7b567f7c87804920bfacd8d155f5dedc.json"},
{"binding_id": "cec117893fd444d3b02697f3e8768ad5", "report_file": "binding_cec117893fd444d3b02697f3e8768ad5.json"},
{"binding_id": "f4f01c8a31704c5f85c297d0814e943d", "report_file": "binding_f4f01c8a31704c5f85c297d0814e943d.json"},
{"binding_id": "df47046c10294c128695b9ec9001464c", "report_file": "binding_df47046c10294c128695b9ec9001464c.json"},
{"binding_id": "8488e465ba93461ab44b35a19f0903ac", "report_file": "binding_8488e465ba93461ab44b35a19f0903ac.json"},
{"binding_id": "2a79f40197924801af6f6288301a6052", "report_file": "binding_2a79f40197924801af6f6288301a6052.json"},
{"binding_id": "e9d931b9014d484fbdca82db24732401", "report_file": "binding_e9d931b9014d484fbdca82db24732401.json"},
{"binding_id": "75c116a1e2de46c99a37461cdcd686a7", "report_file": "binding_75c116a1e2de46c99a37461cdcd686a7.json"},
{"binding_id": "31df242b1d454a1abaddd8f659139816", "report_file": "binding_31df242b1d454a1abaddd8f659139816.json"}
]
}
Raw
summary_summary.md

Pantheon Binding Tool - Comprehensive Report

Executive Summary

  • Site Name: piper-sandler-co
  • Site ID: 4e9372f2-e74f-43d2-9245-fc45643f2624
  • Plan: Elite
  • Total Bindings: 12
  • Overall Status: CRITICAL
  • Audit Date: Wed Jul 23 19:56:22 EDT 2025

Performance Overview (Last 7 Days)

  • Total Requests: 69,371
  • 499 Errors (Client Disconnects): 0
  • 502 Errors (Bad Gateway): 0
  • Overall Error Rate: 0.00%

Binding Health Summary

  • 🔴 Critical Issues: 6 bindings
  • 🟡 Warning Issues: 0 bindings
  • 🟢 Healthy: 6 bindings

Technical Details

Audit Methodology:

  • Log analysis covers last 7 days of nginx access/error logs
  • Configuration analysis of PHP-FPM, nginx, and Redis settings
  • Performance metrics extracted from current and historical log files
  • Error rate calculations based on total requests vs error responses

Key Metrics Explained:

  • 499 Errors: Client disconnected before server response
  • 502 Errors: Bad gateway errors
  • Socket Errors: Resource exhaustion at nginx level
  • PHP-FPM Pool Exhaustion: All PHP workers busy, requests queued/dropped

Thresholds:

  • Critical: Error rate > 5% OR > 1000 errors/day
  • Warning: Error rate > 1% OR > 100 errors/day
  • Healthy: Error rate < 1% AND < 100 errors/day

Next Steps

  1. Immediate Actions:

    • Review critical recommendations above
    • Implement fixes for high-priority items
    • Monitor error rates closely

  2. Scheduled Improvements:

    • Address warning-level issues during maintenance windows
    • Implement optimization recommendations
    • Update monitoring and alerting

  3. Follow-up:

    • Re-run audit after 24-48 hours to verify improvements
    • Set up regular auditing schedule
    • Review trends over time for capacity planning

Report Files

  • Site Summary: site_summary.json - Machine-readable aggregate data
  • Recommendations: recommendations.json - Detailed actionable items
  • Individual Bindings: bindings/binding_*.json - Per-binding detailed analysis

Generated: Wed Jul 23 19:56:22 EDT 2025 Audit Tool: Pantheon Binding Tool v1.0 Data Source: Last 7 days of log files and current configuration

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment