MySQL Performance Tuning: Tips, Scripts and Tools

With MySQL, common configuration mistakes can create severe performance problems. If you misconfigure just one of the many config parameters, it can cripple performance. Of course, the performance of MySQL is often tied to the efficiency of your MySQL queries. It’s essential to ensure that your performance issues are not due to poorly written MySQL […]

dstat command in Linux w/ examples

This dstat command guide follows my previous 90 Linux Commands frequently used by Linux Sysadmins article. As time allows, I will continue to publish articles on around the 90 commands geared toward Linux sysadmins and Linux power users. Let’s continue this series with the dstat command. Dstat is used for generating system resource statistics. It is a versatile […]

iftop command in Linux w/ examples

This iftop command guide follows my previous 90 Linux Commands frequently used by Linux Sysadmins article. As time allows, I will continue to publish articles on around the 90 commands geared toward Linux sysadmins and Linux power users. Let’s continue this series with the iftop command. iftop is a terminal program that shows network activity and details in text form. It’s […]

Home Lab Beginners guide (Hardware)

Until recently, and for well over the past decade, my wife and I have been nomads. Moving from the Caribbean to Miami, New York, Las Vegas, Vancouver, and now back home. This has meant that for many of those years, my home office basically comprised of a few laptops and screens. These days, we are […]

Generating Secure Passwords for your Linux Server

Update: March 4th 2024: While the guidance below – originally provided in 2013 – emphasizes the creation and management of secure passwords, more than a decade later, it’s important to recognize and advocate for the use of passwordless authentication methods wherever feasible. Authentication keys for SSH, biometric authentication, and single sign-on (SSO) are exemplary alternatives that […]

Apache Performance: Disable .htaccess

In 2013, while seeking a detailed guide on performance enhancements for a StackLinux client, I began a quest to find an article that explained the impact of WordPress Caching plugins—specifically, how those utilizing .htaccess might be less efficient than their counterparts. This search turned out to be unexpectedly time-consuming, but it eventually led me to this […]

Choosing Linux Terminal Emulators – Discussion and List

The terminal emulator stands as an unsung hero, bridging the gap between user and machine with a blend of simplicity and power. As we delve into the world of terminal emulators, we uncover a landscape rich in diversity and innovation. From the classic simplicity of XTerm to the modern, Rust-powered elegance of Warp, terminal emulators […]

Tuning MySQL my.cnf? Avoid this common pitfall!

It took me some time to decide on the title of this article. MariaDB has been fast replacing MySQL as many Linux distributions now default to MariaDB over MySQL. MariaDB is an enhanced drop-in replacement for MySQL. Therein lies my predominantly self-made conundrum, MySQL or MariaDB? The MySQL tuning advice below applies to MySQL, MariaDB […]

SCP Linux – Securely Copy Files Using SCP examples

This post includes SCP examples. SCP or secure copy allows the secure transferring of files between a local host and a remote host or between two remote hosts. It uses the same authentication and security as the Secure Shell (SSH) protocol from which it is based. SCP is loved for its simplicity, security, and pre-installed […]

Must-Have Devices to boost your Linux skills (2024)

Are you ready for a transformative journey that will elevate your Linux skills in ways theoretical learning alone can’t? The devices mentioned in this article offer a great way to get hands-on experience and change how you understand and use Linux skills in practical, everyday scenarios. 4 Linux Devices for Hands-On Learning Boosting your Linux […]

Top ↑