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…

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…