Subfolders
Latest "Grimoires" Articles
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » cron
Posted inIT Grimoire

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 to do things, it create a small, constant resource drag, so disable it when done troubleshooting.

# The first element of the path is a directory where the debian-sa1
# script is located
PATH=/usr/lib/sysstat:/usr/sbin:/usr/sbin:/usr/bin:/sbin:/bin

# Activity reports every 10 minutes everyday
#ORIGINAL DEFAULT WAS 5-55/10 * * * * root command -v debian-sa1 > /dev/null && debian-sa1 1 1
#uncomment above line and comment out /tmp/outage_resource_log.txt lines to restore original functionality
* * * * * root date +"%Y-%m-%d %H:%M:%S" >> /tmp/outage_resource_log.txt
* * * * * root sar -u 1 1 >> /tmp/outage_resource_log.txt 2>&1
* * * * * root sar -r 1 1 >> /tmp/outage_resource_log.txt 2>&1
* * *…

| Permanent URL: https://michaelkupietz.com?p=29707  |  Share this  |  Embed link  |  Webmentions are: off
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » Apache
Posted inIT Grimoire

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 = /fpm-status

May need at very start of .htaccess to prevent wordpress from intercepting the URL, not sure:
RewriteRule ^fpm-status$ - [L]

| Permanent URL: https://michaelkupietz.com?p=29702  |  Share this  |  Embed link  |  Webmentions are: off
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » Apache
Posted inIT Grimoire

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" filters out hits from my uptime monitor.

| Permanent URL: https://michaelkupietz.com?p=29700  |  Share this  |  Embed link  |  Webmentions are: off
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » fail2ban
Posted inIT Grimoire

How to check Fail2ban log

Command to check fail2ban's log is sudo tail -f /var/log/fail2ban.log

| Permanent URL: https://michaelkupietz.com?p=29693  |  Share this  |  Embed link  |  Webmentions are: off
Linux
Posted inIT Grimoire

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", sum/NR/1024,"M") }'

| Permanent URL: https://michaelkupietz.com?p=29677  |  Share this  |  Embed link  |  Webmentions are: off
Linux
Posted inIT Grimoire

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] --pass [pass]

Remember to quote any punctuation or BASH tokens in the password.

| Permanent URL: https://michaelkupietz.com?p=29669  |  Share this  |  Embed link  |  Webmentions are: off
Workshop » Reference Section » Grimoires » IT » Troubleshooting log

/Devlog

  • 2026jul24
    • Added a slow log and made some apache changes mostly related to logging and registering header info sent from cloudflare. Details are at https://michaelkupietz.com/server-changes-summary-july-24-2026/
  • 2026jul3
    • Changed .metainfo > .dashicons {margin-bottom: -2px;margin-top: -2px; /* fix for dashicons raising text baselines in tags in meta info line */} to use ".page-header .metainfo > .dashicons" so didn't add weird spacing to metainfo in archove page post lists.
    • Create ktwp-table-of-contents and ktwp-raw-html-shortcode plugins
    • add :target {scroll-margin-top: 120px; /* o make named anchors always appear under sticky header */ }
  • 2026jul1
    • Added overflow-y:hidden during earthquake to prevent extra scrollbars from appearing.
    • Discovered the earthquake was moving all .do-earthquake-children around the same origin, and, earthquake was being applied to invisible elements. Fixed both.
  • 2026jun21
    • Moved category "In Brief: Topical Short Takes" from "Written Snippets" category to "Blog Posts" and renamed it "You Can Quote…
| Permanent URL: https://michaelkupietz.com?p=11164  |  Share this  |  Embed link  |  Webmentions are: off