htop: Here’s how to customize it

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. Just one example where this comes in handy: you don’t have to type […]

How to Kill Inactive SSH Sessions

So, you’ve been disconnected from your server a couple of times which resulted in inactive ssh sessions. You know this because when you use the “w” command, you see something like the following… 22:47:28 up 315 days, 21:09, 2 users, load average: 9.04, 8.17, 7.30 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT root pts/0 ipxxx-xxx-xxx-xxx 23:54 […]

MySQL Performance: Stop hoarding. Drop unused MySQL databases

Last year, I was assisting a new client in addressing MySQL performance issues. There were several areas where MySQL performance issues were addressed. One issue overlooked for several years prior to our communications, was that of keeping around unused databases. Over 15GB of unused MySQL data – a mix of MyISAM and Innodb tables – […]