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…

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…