Wasya Wiki - New pages [en]

Drupal Performance

2026-05-02T21:19:08Z

Piousbox: /* changes I'm making */

Add these to settings.php:

$settings['cache']['bins']['render'] = 'cache.backend.database'
$settings['cache']['bins']['dynamic_page_cache'] = '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

= part IV =

See how long the request takes:

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

Add nginx log temporarily:

log_format timing '$remote_addr - $request '
'rt=$request_time '
'urt=$upstream_response_time '
'uht=$upstream_header_time '
'uct=$upstream_connect_time';
#
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

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

== check php cache ==

php -i | grep opcache

== changes I'm making ==

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

Html

2026-04-12T14:32:11Z

Piousbox:

certbot run -d $DOMAIN --nginx -n --expand

Color picker: https://www.w3schools.com/colors/colors_picker.asp

Unlimited music downloads: https://www.bensound.com/pricing

Google cloud billing (make sure it's at zero): https://console.cloud.google.com/billing/

<pre>

<video width="640" height="480" controls="">
<source src="">
Your browser does not support the video tag.
</video>

</pre>

<pre>

<video width="640" height="360" controls="">
<source src="">
Your browser does not support the video tag.
</video>

</pre>

<pre>

<video width="300" height="225" controls="">
<source src="">
Your browser does not support the video tag.
</video>

</pre>

<pre>

<video width="480" height="640" controls="">
<source src="">
Your browser does not support the video tag.
</video>

</pre>

Postal

2026-04-07T13:25:52Z

Piousbox: Created page with " == enable TLS == From: https://docs.postalserver.io/features/smtp-tls openssl req -x509 -newkey rsa:4096 -keyout /opt/projects/annesque_email/config/postal/smtp.key \..."

== enable TLS ==

From: https://docs.postalserver.io/features/smtp-tls

openssl req -x509 -newkey rsa:4096 -keyout /opt/projects/annesque_email/config/postal/smtp.key \
-out /opt/projects/annesque_email/config/postal/smtp.cert -sha256 -days 365 -nodes

Wget

2026-04-03T21:38:49Z

Piousbox:

wget --mirror --convert-links --adjust-extension --page-requisites --no-parent $domain

=== Limit download scope ===

-l 2 → only go 2 levels deep

wget -r -np -k -p -E -l 1 $domain

=== other ===

<pre>
-r → recursive download (follows links)
-np → no parent (won’t go above the starting directory)
-k → convert links for local viewing
-p → download all page assets (images, CSS, etc.)
-E → save files with proper extensions (like .html)
</pre>

wget -r -np -k -p -E https://example.com

Aws s3

2026-03-28T00:43:50Z

Piousbox:

== get size of bucket ==

aws s3 ls s3://your-bucket-name --recursive --summarize --human-readable

== remove .DS_Store ==

export bucket='your-bucket-name'

preview:

aws s3api list-objects-v2 \
--bucket $bucket \
--query "Contents[?contains(Key, '.DS_Store')].Key"

execute:

aws s3api list-objects-v2 \
--bucket $bucket \
--query "Contents[?contains(Key, '.DS_Store')].Key" \
--output text | tr '\t' '\n' | while read key; do
aws s3 rm "s3://$bucket/$key"
done

== remove objects that start with ._ ==

export bucket='your-bucket-name'

Preview:

aws s3api list-objects-v2 \
--bucket $bucket \
--query "Contents[?starts_with(Key, '._') || contains(Key, '/._')].Key"

execute:

aws s3api list-objects-v2 \
--bucket $bucket \
--query "Contents[?starts_with(Key, '._') || contains(Key, '/._')].Key" \
--output text | tr '\t' '\n' | while read key; do
aws s3 rm "s3://$bucket/$key"
done