Latest "Performance" files
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » SQL
SQL query to list all WordPress post revisions for archiving

SQL query to list all WordPress post revisions for archiving

Here's the SQL query to get all post revisions, which I do prior to cleaning them out of the database, which seems to make it much faster: SELECT p.* FROM…
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » rsync & rsnapshot
Speeding up rsnapshot (rsync) backups by removing wildcard paths from exclude

Speeding up rsnapshot (rsync) backups by removing wildcard paths from exclude

I removed a bunch of wildcard paths from rsnapshot.conf's exclude, and suddenly tonight my backup ran in a few minutes instead of taking over a day like it usually does.…
Workshop » Reference Section » Grimoires » IT » Troubleshooting log » Web Server
Performance troubleshooting & settings changes 2025aug29

Performance troubleshooting & settings changes 2025aug29

Following several days of frequent freezes, I tried changing the following settings updated in : [opcache] original settings ;recommended by https://vpsfix.com/14433/virtualmin-post-installation-configuration-and-server-optimization-guide/ opcache.enable= opcache.memory_consumption= opcache.interned_strings_buffer= opcache.max_accelerated_files= opcache.validate_timestamps= opcache.revalidate_freq= opcache.save_comments= ;end recommendation…
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » PHP
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…
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » cron
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…
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » Apache
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"…
Workshop » Reference Section » Grimoires » IT » Platforms » Linux » Packages » fail2ban
How to check Fail2ban log

How to check Fail2ban log

Command to check fail2ban's log is sudo tail -f /var/log/fail2ban.log
Linux
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",…
Linux
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]…