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…
Latest "Performance" files
SQL query to list all WordPress post revisions for archiving
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.…
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…
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…
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"…
How to check Fail2ban log
Command to check fail2ban's log is sudo tail -f /var/log/fail2ban.log
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]…
