MySQL Performance Tuning: Tips, Scripts and Tools

MySQL Performance Tuning: Tips, Scripts and Tools

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,…

dstat command in Linux w/ examples

dstat command in Linux w/ examples

-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…

iftop command in Linux w/ examples

iftop command in Linux w/ examples

sudo iftop -F 192.168.1.0/24 pacman -S iftop iftop command examples iftop is a terminal program that shows network activity and details in text form. It’s suitable for users who want to monitor network…

Managing User Focus with :focus-visible

Managing User Focus with :focus-visible

button:focus-visible { outline-color: black; font-size: 1.2em; font-family: serif; font-weight: bold; } /*** OR ***/ input:focus-visible { outline-color: black; font-size: 1.2em; font-family: serif; font-weight: bold; } Support One example that always comes to mind…

The Power of :has() in CSS

The Power of :has() in CSS

New and improved with modern day CSS coming in hot! The capabilities of what we can do in the browser have come a long way. We now can take advantage of CSS to…

Best Linux Distro (2024)

Best Linux Distro (2024)

This collection isn’t your typical lineup; it’s for the enthusiasts who relish in customization, efficiency, and a deep understanding of their system’s workings. From the ambitious endeavor of crafting your system from scratch…

Apache Performance: Disable .htaccess

Apache Performance: Disable .htaccess

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…

Manual Product Upgrades – LAB2PROD

Manual Product Upgrades – LAB2PROD

February 13, 2024 VMware Cloud Foundation: Manual Product Upgrades Why You Shouldn’t Upgrade VMware NSX Manually The Issue? My VCF Troubleshooting guide has a few other tips for administrators. Log back onto SDDC…