Having 12+ Years of Experience in Software Development
MariaDB Query Cache Deprecation and InnoDB Buffer Pool Tuning As of MariaDB 10.0, the Query Cache has been deprecated and removed entirely in MariaDB 10.5. For WordPress sites on Debian 12 Bookworm running MariaDB, relying on the Query Cache for performance optimization is a relic of the past. The focus must shift entirely to the […]
Nginx FastCGI Cache Configuration for WooCommerce Optimizing Nginx’s FastCGI cache is paramount for high-traffic WooCommerce stores. This involves carefully tuning cache zones, key generation, and cache purging strategies to minimize database load and accelerate page delivery. We’ll focus on Ubuntu 24.04 LTS, assuming a standard LEMP stack with PHP-FPM. Defining Cache Zones and Parameters The […]
Prerequisites and System Setup This guide assumes a functional openSUSE Leap 15.5 installation with root or sudo privileges. We will be setting up HAProxy to distribute traffic across multiple Nginx instances serving Magento 2. Ensure your Nginx servers are already configured and accessible on a specific port (e.g., 8080) for the backend Magento 2 applications. […]
Identifying the Memory Leak: Initial Observations and Tools When encountering persistent memory growth in MariaDB instances running on openSUSE Leap 15.5, particularly after recent upgrades or configuration changes, a systematic diagnostic approach is paramount. The first step involves confirming the leak and gathering baseline metrics. Tools like top, htop, and ps are invaluable for real-time […]
Assessing the Perl Upgrade Landscape on openSUSE Leap 15.5 Enterprise environments often rely on specific Perl versions for critical applications. Upgrading Perl on a stable distribution like openSUSE Leap 15.5, particularly from 5.34 to 5.38, necessitates a meticulous approach, especially when dealing with custom-compiled CPAN modules that link against system libraries or have C/C++ extensions […]
Understanding `dirty_ratio` and `dirty_background_ratio` On Linux systems, the virtual memory subsystem manages how data is written from RAM to persistent storage. A critical aspect of this management involves the concept of “dirty” pages. A page is considered dirty when it has been modified in memory but has not yet been written back to its underlying […]
Prerequisites and Initial Setup This guide assumes you have a fresh installation of openSUSE Leap 15.5 with root or sudo privileges. We’ll be installing Supervisor, a process control system that allows you to monitor and control a number of processes on UNIX-like operating systems. This is particularly useful for daemonizing long-running applications like Python-based message […]
Leveraging Btrfs Subvolumes for Atomic Database Backups For enterprise environments demanding robust and atomic database backup strategies, Btrfs subvolumes offer a powerful, filesystem-level solution. This approach bypasses the complexities and potential race conditions inherent in file-level copying of live databases. By creating read-only snapshots of dedicated subvolumes containing database files, we achieve point-in-time consistency without […]
Understanding the Problem: Query Bloat in Sage Roots Layouts Modern WordPress development, particularly with frameworks like Sage Roots, often involves complex data retrieval patterns. While the flexibility of WordPress’s query system is a strength, it can also lead to significant “query bloat” within a single page load. This is especially true when rendering multiple distinct […]
PHP-FPM Pool Tuning for Firebase Realtime Database Handlers When developing WordPress plugins that heavily interact with Firebase Realtime Database (RTDB) for real-time data synchronization or complex backend logic, the performance of your PHP execution environment becomes paramount. High concurrency, especially under load, can quickly expose bottlenecks in PHP-FPM’s process management and opcode caching. This guide […]