Query all WordPress posts in MySQL not having a Yoast SEO meta description
Query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin
Sysadmins of the North
Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security
Sysadmins of the North
Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security
Category WordPress
WordPress powers a massive portion of the web, but running it at a professional level – especially on Windows/IIS or high-performance Linux stacks – requires specific expertise. This sub-category focuses on the technical side of the world’s most popular CMS: from MySQL/MariaDB tuning and PHP-FPM optimization to advanced caching strategies and security hardening.
Forget the basic plugin reviews; here we go under the hood. You’ll find guides on managing WordPress via WP-CLI, automating updates, and protecting your installation from the latest vulnerabilities. If you are looking to host WordPress with the speed and security of an enterprise-grade application, these battle-tested configurations are for you.
Read MoreQuery all WordPress posts in MySQL not having a Yoast SEO meta description
Disallow direct access to PHP files in wp-content/uploads/
Securing the WordPress uploads folder is important. In many hacked WordPress sites, a PHP backdoor is found within the WP_CONTENT_DIR/uploads directory. Often because this is the location where uploads are placed automatically. From the backdoor within wp-content/uploads other backdoors are uploaded to various locations, and scripts are injected with malware.
WordPress .htaccess security best practices in Apache 2.4.6+
Since Apache 2.4.6, a new module is used to configure and set up access control for websites: mod_authz_core. This means you have to use a different syntax for allowing or blocking hosts and IP addresses to your website. Apache Access Controle done right in WordPress .htaccess.
Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php
How to increase the memory limit for your WordPress website, the right way. In this post I show you a correct way of setting WordPress WP_MEMORY_LIMIT and PHP memory_limit settings to improve Wordpress speed & performance.
Protect WordPress from brute-force XML-RPC attacks
How to protect your WordPress from brute-force XML-RPC attacks, because the WordPress XML-RPC API has been under attack for many years now.
Remove Jetpack email sharing service
Remove Jetpack email sharing service using WordPress plugin or theme functions.php file. It's often abused by spammers
Check WordPress Core files integrity
Check WordPress integrity and verify WordPress Core files' md5 checksums against WordPress' checksums API, using this standalone PHP file.
Clear PHP opcode caches before WordPress Updates: ease the updating process
WordPress core-, plugin- and theme updates sometimes fail because of enabled opcode caches in PHP. Popular PHP opcode caches are OPcache, WinCache and APC. This little WordPress Must Use Plugin tries to flush opcode caches. Making your live a bit easier when updating WordPress Core, Plugins and Themes.
Tips to speed up WordPress, serve gzip compressed static HTML files
Gzip compress and serve WP-Super-Cache or Cache Enabler static HTML files, to supercharge your WordPress blog!
Akal Premium WordPress theme XSS vulnerability
This post describes the Akal premium WordPress theme Cross Site Scripting (XSS) vulnerability. If you use this theme, delete it immediately!
Optimize(d) WordPress hosting (9+ practical tips)
9+ Practical tips to optimize WordPress hosting - or for any other PHP web application for that matter. Learn optimizing your WordPress hosting
Optimize WordPress MySQL tables through Cron, behind the scenes
Schedule WordPress database optimization with WP-Cron.
Minify WP-Super-Cache HTML cache files: WPSCMin a WP-Super-Cache plugin
The WordPress WP-Super-Cache cache plugin doesn't minify HTML cache files, which I find a disadvantage. Knowing minify libraries, I went looking for an existing solution (why reinvent the wheel?), and found one: WPSCMin. Read on ...
My WordPress web.config
Do you host your WordPress website on Windows Server IIS? And are you having trouble with your web.config? Here is mine :)
Disable WordPress comments (how-to)
With thousands spam reactions, disabling (and removing) WordPress comments is often the only way to go. Here is how to disable WordPress comments in both the WordPress Dashboard interface and in your MySQL / MariaDB database.
Send authenticated SMTP email over TLS from WordPress
Learn how to override wp-mail() and send secure email using authenticated SMTP and StartTLS from WordPress.
Huge increase in WordPress xmlrpc.php POST requests
How to identify, block, mitigate and leverage xmlrpc.php scans, brute-force, and user enumeration attacks on WordPress sites... Secure WordPress xmlprc.php interface and reduce service disruption.
Block WordPress comment spammers manually
The less spammers hit your WordPress blog, the better your blog performs, is one of my opinions. A second is, the less unnecessary plugins you use on your WordPress blog, the better. So, a little while ago I decided to remove plugins like Stop Spammer Registration Plugin and do its work myself.
Cleanup WordPress post revisions
Clean up WordPress post revisions easily with one (1) simple SQL statement. Delete WordPress post revisions, turn them off and speed up your WordPress blog.
![[HttpException (0x80004005): The length of the URL for this request exceeds the configured maxUrlLength value.]](https://cdn.saotn.org/wp-content/uploads/2025/06/Length_of_URL_for_request_exceeds_maxUrlLength_value-11-150x150.png)
