MySQL Performance: Stop hoarding. Drop unused MySQL databases

Recently, I supported a new client with solving MySQL performance issues. There were several areas where MySQL performance issues were addressed. One issue, however, was overlooked prior to our communications, was that of keeping around unused databases. There was around 15 gigabytes of unused MySQL data – a mix of MyISAM and Innodb tables – […]

How to diagnose OOM errors on Linux systems

Out-of-memory (OOM) errors take place when the Linux kernel can’t provide enough memory to run all of its user-space processes, causing at least one process to exit without warning. Without a comprehensive monitoring solution, OOM errors can be tricky to diagnose. In this post, you will learn how to diagnose OOM errors in Linux kernels […]

bashtop – the ‘cool’ top alternative.

Meet bashtop, an esthetically pleasing system monitor, written completely in Bash. Yup, you can view all 5000 lines of code, by simply opening /usr/bin/bashtop with a text editor or view on Github. Over the years, the available options for command-line system monitoring tools have grown quite a bit. There is top, htop, glances, nmon, ytop, gtop, vtop, and […]

SCP Linux – Securely Copy Files Using SCP examples

This post includes SCP examples. SCP or secure copy allows 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 it’s simplicity, security and pre-installed availability.   SCP […]

atop – For Linux server performance analysis

We’re all familiar with top, a real-time system monitor. Some prefer htop and previously I mentioned iotop for use with storage read/write monitoring. Lets looks at another popular tool for Linux server performance analysis: atop.   Advantages of atop Atop is an ASCII full-screen performance monitor which can log and report the activity of all server processes. One feature […]

htop: Quick Guide & Customization

htop is an interactive system-monitor, but also a process-viewer, process-manager, strace tool and more. Sysadmins may opt to use htop in cases where Unix top does not provide enough information about system processes. htop uses a cursor-controlled interface for sending signals to processes. One example where this comes in handy is: you don’t have to type […]

Using CentOS CR (Continuous Release) Repo

CentOS (Community Enterprise Operating System) is a Linux distribution that attempts to provide free, enterprise-class, community-supported computing platform functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL). CentOS is run by volunteers who work directly with Red Hat’s RPM source files and pushing them to CentOS for release. At times the project will fall behind […]

How to direct-install Debian SID rolling release using mini.iso (w/ screenshots)

This post has been updated. Original post: May 20th, 2017. Last updated Feb, 28th 2020. For desktop, I’ve often preferred rolling release distros such as Arch Linux or custom installed Kali Linux. However, currently I’m on Ubuntu 14.04 LTS Fedora 31. Ubuntu recently released 16.04 LTS 18.04 LTS which meant performing an in-place upgrade or complete re-install […]