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

20 Leading Companies Share How COVID-19 is Accelerating the Future of APM

One year ago, I asked 12 of the leading providers of application performance monitoring (APM) and other SaaS-based monitoring services: what will the future of APM look like in 2020?  They pointed to the rise of AIOps (Artificial Intelligence for IT Operations), Big Data, and Digital Experience Monitoring (DEM) as the core advancements in this space. […]

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

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

How to Optimize Your Cloud Services Cost

In this blog post, we review some of the biggest risks behind increasing services cost and how to optimize cloud services cost with a proper application monitoring solution. As modern software deployments continue to break down into smaller and more modular units, the world is seeing more moving parts in the deployment equation. The drivers […]

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

MySQL Database Performance: Avoid this common mistake

One frequent topic of support request emails I receive is MySQL database performance. Clients complain about MySQL using too much server memory, too many MySQL slow queries, the famous Mysql server has gone away error and many other MySQL performance related issues. As such, I wanted to quickly share the solution to a common MySQL configuration […]

Strip Down Apache to Improve Performance & Memory Efficiency

Can you believe that its been five eight years since the release of Apache 2.4?! Still, most Apache based web servers continue to run Apache version 2.2 or even 2.0. This is understandable for the same reasons why Apache web servers are still used more than Nginx… compatibility, official support and features. If you haven’t replaced Apache […]

Panopta (exclusive offer) Get Two Free Months

Over the years Panopta has listened to customer feedback; they continue to respond with additional development and improvements to their infrastructure, application and network performance monitoring tools. With Panopta you can easily keep an eye on the most fundamental metrics across complex infrastructure so you can identify the root cause of problems. If you suffer […]