Database monitoring is indispensable for maintaining the health, performance, and reliability of your database system. It provides administrators and IT teams with real-time insights into the system’s operations, enabling them to proactively identify…
Table of Contents Alice and Bob Imagine there’s a city in a valley. On either side of the valley, there’s an army commanded by a general. On the left hill stands General Alice…
You may have been following my Linux home lab build. One of the most important decisions when building your home lab is selecting the proper router/firewall for your network. After many hours of…
<?php var_dump(realpath_cache_size()); ?> Enjoy! realpath_cache_size = 4M realpath_cache_ttl = 120 Note that if your using Apache Prefork-mpm mod_php to run PHP (the fastest when loading only PHP and not with static content) then…
OPcache is a PHP extension that improves PHP performance by storing precompiled script bytecode in shared memory, thereby removing the need for PHP to load and parse scripts on each request. The extension…
These are not mind-blowing results. However, depending on your current throughput of PHP requests, you may be happy to take whatever improvements you can find. Also, this test was with WordPress only; with…
So, what is observability? Well, rather than adding to the many different published definitions, I’ll point you to a few articles and pages recently published (all within the past six months) by some…
MySQLTuner supports Galera Cluster, TokuDB, Performance schema, Linux OS metrics, InnoDB, MyISAM, Aria, etc. – MySQLTuner on Github. You cannot replace Professional MySQL tuning with scripts. Scripts serve as essential guides, sometimes spot-on,…
-y, –sysenable system stats (interrupts, context switches)–snmp-cpu–floatforce float values on-screen (mutual exclusive with –integer)–top-io-advshow most expensive I/O process (incl. pid and other stats)–qmailshow qmail queue sizes (needs qmail)–top-bioshow most expensive block I/O process…
There are two main reasons to avoid the use of .htaccess files. This search turned out to be unexpectedly time-consuming, but it eventually led me to this article. In the comments section, Martin from Foliovision…
