Website returns 503 server errors, but no errors in logs
Had a weird one today. Last one website of the several of on this server suddenly started returning 503 (service unavailable) errors. There was nothing in the PHP error log…
Subfolders
Latest "General Interest & Reference Library" files
Get names of all input fields in a FileMaker Pro table
ExecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName='[TABLE NAME]' AND FieldClass='Normal'",",","¶")
How to monitor RAM for tuning pm.max_children
How to monitor RAM usage: free -h: This command shows your system's total, used, and free memory in a human-readable format. Key metrics: total: Total RAM. used: RAM currently in…
Add sar logging for CPU, RAM, and disk I/O
Add or change /etc/cron.d/sysstat to this. This creates a cron jobe to write file /tmp/outage_resource_log.txt that keeps minute-by-minute stats, sometimes useful in troubleshooting slowdowns. However, it's not a great way…
Add /fpm-status page to Apache virtual host
Add this to virtual host file in /etc/apache2/sites-available/, right below DocumentRoot, in both :80 and :443 sections SetHandler "proxy:unix:/var/php-fpm/170027027353667.sock|fcgi://127.0.0.1" Require all granted May need in /etc/php/8.2/fpm/pool.d/www.conf, not sure: pm.status_path =…
View last 200 lines of all access logs on apache server
find [path/to/access/logs/folder] -name "*_access_log" -exec sh -c 'tail -200 "$1" | grep -v "HetrixTools\|ok\.txt\|canary" | sed "s/$/ [$(basename "$1" _access_log)]/"' _ {} \; | sort -k4,4 The grep -v "HetrixTools\|ok\.txt\|canary"…
Linux PHP tuning utilities & commands
1. See memory consumed by php-fpm8.2 (change this to match different PHP version if necessary) ps --no-headers -o "rss,cmd" -C php-fpm8.2 | awk '{ sum+=$1 } END { printf ("%d%s\n",…
Linux SQL Tuning Utilities
1. tuning-primer.sh Run from Github: curl -L https://raw.githubusercontent.com/BMDan/tuning-primer.sh/main/tuning-primer.sh | bash 2. MySQLTuner.pl wget http://mysqltuner.pl/ -O mysqltuner.pl wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv perl mysqltuner.pl --host 127.0.0.1 --user [user]…
Posted inArchives & Collections Posted in genres
The Emperor's New Code: The Encyclopedia Of AI Apologies (now with bonus AI Swearing and Generative Suicide Threats!)
I've spent so much time fruitlessly trying to get LLMs (Large Language Model chatbots, commonly referred to generically as "AI") to actually help me solve coding problems that I've taken,…
Posted inWriting Posted in genres
Word Salad: Vocabulary
As I run across words or phrases that I like, I add them here. Apotropaic magic (from Greek αποτρέπω, apotrépō 'to ward off') - protective magic, a type of magic…
