Drupal Performance - Revision history

Piousbox: /* changes I'm making */

2026-05-08T02:00:05Z

‎changes I'm making

2026-05-08T01:59:05Z

‎changes I'm making

2026-05-08T01:58:16Z

‎check php cache

2026-05-08T01:53:15Z

‎part IV

2026-05-08T01:51:30Z

‎part IV

2026-05-08T01:48:17Z

‎part IV

2026-05-08T01:48:01Z

‎part IV

2026-05-08T01:44:59Z

‎part IV

2026-05-08T01:41:31Z

2026-05-02T21:28:33Z

← Older revision		Revision as of 02:00, 8 May 2026
Line 60:		Line 60:

	opcache.validate_timestamps=0 # made no difference		opcache.validate_timestamps=0 # made no difference
		+	realpath_cache_ttl = 600

← Older revision		Revision as of 01:59, 8 May 2026
Line 59:		Line 59:
	== changes I'm making ==		== changes I'm making ==

−	opcache.validate_timestamps=0	+	opcache.validate_timestamps=0 # made no difference

← Older revision		Revision as of 01:58, 8 May 2026
Line 56:		Line 56:

	php -i \| grep opcache		php -i \| grep opcache
		+
		+	== changes I'm making ==
		+
		+	opcache.validate_timestamps=0

← Older revision		Revision as of 01:53, 8 May 2026
Line 52:		Line 52:
	* OPCache not configured		* OPCache not configured
	* reverse DNS / external HTTP calls		* reverse DNS / external HTTP calls
		+
		+	== check php cache ==
		+
		+	php -i \| grep opcache

← Older revision		Revision as of 01:51, 8 May 2026
Line 42:		Line 42:
	* high upstream_header_time		* high upstream_header_time
	** → app slow before first byte		** → app slow before first byte
		+
		+	For containerized Drupal, a 3–4 second first-hit delay is commonly one of:
		+	* PHP-FPM worker cold start
		+	* Drupal cache rebuild/bootstrap
		+	* slow DB query
		+	* uncached Twig/container compilation
		+	* network latency to DB/Redis
		+	* bind-mounted filesystem slowness
		+	* OPCache not configured
		+	* reverse DNS / external HTTP calls

@@ Line 35: / Line 35: @@
 Interpretation:
 * high request_time + high upstream_*
-  → backend app is slow
+**  → backend app is slow
 * high request_time + no upstream times
-  → nginx/static filesystem issue
+**  → nginx/static filesystem issue
 * high upstream_connect_time
-  → nginx struggling to reach upstream
+**  → nginx struggling to reach upstream
 * high upstream_header_time
-  → app slow before first byte
+**  → app slow before first byte

← Older revision		Revision as of 01:48, 8 May 2026
Line 32:		Line 32:
	#		#
	access_log /var/log/nginx/timing.log timing;		access_log /var/log/nginx/timing.log timing;
		+
		+	Interpretation:
		+	* high request_time + high upstream_*
		+	→ backend app is slow
		+	* high request_time + no upstream times
		+	→ nginx/static filesystem issue
		+	* high upstream_connect_time
		+	→ nginx struggling to reach upstream
		+	* high upstream_header_time
		+	→ app slow before first byte

@@ Line 15: / Line 15: @@
 = part IV =
    curl -o /dev/null -s \
      -w 'dns=%{time_namelookup} connect=%{time_connect} tls=%{time_appconnect} ttfb=%{time_starttransfer} total=%{time_total}\n' \
      https://piousbox.com/issues/2025q2-issue

← Older revision		Revision as of 01:41, 8 May 2026
Line 13:		Line 13:
	# skip-name-resolve		# skip-name-resolve
	max_connections = 300		max_connections = 300
		+
		+	= part IV =
		+
		+	curl -o /dev/null -s \
		+	-w 'dns=%{time_namelookup} connect=%{time_connect} tls=%{time_appconnect} ttfb=%{time_starttransfer} total=%{time_total}\n' \
		+	https://piousbox.com/issues/2025q2-issue

← Older revision		Revision as of 21:28, 2 May 2026
Line 5:		Line 5:
	$settings['cache']['bins']['dynamic_page_cache'] = 'cache.backend.database'		$settings['cache']['bins']['dynamic_page_cache'] = 'cache.backend.database'
	$settings['cache']['bins']['page'] = 'cache.backend.database'		$settings['cache']['bins']['page'] = 'cache.backend.database'
		+
		+
		+	reconfigure /etc/mysql/conf.d/docker.conf
		+
		+	[mysqld]
		+	# skip-host-cache
		+	# skip-name-resolve
		+	max_connections = 300