Latest "Web Server" files
» » » » » »
SQL query to list all WordPress post revisions for archiving
Posted in

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…
Tags: |  Permanent URL: https://michaelkupietz.com?p=30697  |  Share this page  |  Embed link
» » » »
Performance troubleshooting & settings changes 2025aug29
Posted in

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…
Tags: |  Permanent URL: https://michaelkupietz.com?p=30615  |  Share this page  |  Embed link
» » » » » »
Resolving an rsnapshot error — “rsync: –delete does not work without –recursive (-r) or –dirs (-d). rsync error: syntax or usage error (code 1) at main.c(1795)”
Posted in

Resolving an rsnapshot error — “rsync: –delete does not work without –recursive (-r) or –dirs (-d). rsync error: syntax or usage error (code 1) at main.c(1795)”

I discovered rsnapshot hadn't run in a few days. Checking /etc/rsnapshot.log, I found every recent day had this: rsync: --delete does not work without --recursive (-r) or --dirs (-d). rsync…
Tags: |  Permanent URL: https://michaelkupietz.com?p=30576  |  Share this page  |  Embed link