MySQL Performance Tuning: Tips, Scripts and Tools

With MySQL, common configuration mistakes can cause serious performance problems. In fact, 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 important to ensure that your performance issues are not due to poorly […]

60 Linux Networking commands and scripts

Recently, I wanted to test network throughput via command line with at least 3 tools. For the life of me, I could not remember iperf. Not being able to remember previously used command line tools is frustrating and something we can all relate to. So I created a go-to-list of network tools for myself. Then, I […]

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 – […]

Top Serverless Monitoring Tools + Serverless Resources

Technology continues to evolve and solutions for hosting applications continue to expand. One such method of application hosting that has been growing in popularity is Serverless Computing.   What is Serverless Computing? Put simply, Serverless Computing is a cloud-computing execution model managed by cloud providers who run the servers hosting your application. Therefore, instead of […]

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 […]

Apache Performance: Disable .htaccess

A while back, I searched the web for a performance article which I could forward to a client of StackLinux. An article explaining how using WordPress Cache plugins which make use of .htaccess, are almost always slower than plugins that don’t use .htaccess. Surprisingly, that search took a lot longer than expected, until I finally came across this […]

Disable cron emails (solution)

Cron is a daemon that executes scheduled commands. More specifically, the software utility cron is a time-based job scheduler for Unix-like operating systems, like Linux. Cron can be used to set up jobs to run periodically at fixed times, dates, or intervals. Cron is an extremely powerful tool because just about anything that you are able […]

Raspberry Pi Performance: Add ZRAM and these Kernel Parameters

A couple of weeks ago, I published a Pinebook Pro review article on this blog. Similar to the Pinebook Pro, the Raspberry Pi and more recently the Raspberry Pi 4, are also ARM based. I’ve applied some of the optimizations mentioned in that previous article to the Raspberry Pi 4, with good results. I wanted […]