Subfolders
Latest "IT Grimoire" files
» » » » »
Filtering LinkedIn Posts, Notifications, and Comments by keyword

Filtering LinkedIn Posts, Notifications, and Comments by keyword

I use the uBlock Origin browser plugin to filter my LinkedIn Posts, Notifications, and Comments to hide anything containing objectionable topics. uBlock Origin allows you to add custom rules to…
|  Permanent URL: https://michaelkupietz.com?p=29799  |  Share this page  |  Embed link
» » » »
Deactivating, deleting, and completely removing a plugin that WordPress won’t let you deactivate

Deactivating, deleting, and completely removing a plugin that WordPress won’t let you deactivate

I installed the WordPress plugin LWS Optimize, which turned out to be unusably broken (which is the reason I'm not linking to it) and made my site unusable. To make…
|  Permanent URL: https://michaelkupietz.com?p=29781  |  Share this page  |  Embed link
» » »
Website returns 503 server errors, but no errors in logs

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…
|  Permanent URL: https://michaelkupietz.com?p=29769  |  Share this page  |  Embed link
» » » »
Get names of all input fields in a FileMaker Pro table

Get names of all input fields in a FileMaker Pro table

ExecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName='[TABLE NAME]' AND FieldClass='Normal'",",","¶")
|  Permanent URL: https://michaelkupietz.com?p=29760  |  Share this page  |  Embed link
» » » » » »
How to monitor RAM for tuning pm.max_children

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…
|  Permanent URL: https://michaelkupietz.com?p=29746  |  Share this page  |  Embed link
» » » » » »
Add sar logging for CPU, RAM, and disk I/O

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…
|  Permanent URL: https://michaelkupietz.com?p=29707  |  Share this page  |  Embed link
» » » » » »
Add /fpm-status page to Apache virtual host

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 =…
|  Permanent URL: https://michaelkupietz.com?p=29702  |  Share this page  |  Embed link
» » » » » »
View last 200 lines of all access logs on apache server

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"…
|  Permanent URL: https://michaelkupietz.com?p=29700  |  Share this page  |  Embed link
Linux PHP tuning utilities & commands

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",…
|  Permanent URL: https://michaelkupietz.com?p=29677  |  Share this page  |  Embed link
Linux SQL Tuning Utilities

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]…
|  Permanent URL: https://michaelkupietz.com?p=29669  |  Share this page  |  Embed link