MySQL Query Cache for Performance, Avoid This When Tuning

Update: MySQL query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. – mysql.com One of the most misconfigured MySQL performance features, is MySQL query_cache_size. This post references a web server with 32 gigabytes of RAM where the existing config had MySQL’s query cache size set incorrectly to 4 gigabytes. The thought behind it seemed […]

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

Linux top: Here’s how to customize it

The top command – referred to below as Linux top – provides a dynamic real-time view of a running system. It can display system summary information as well as a list of processes or threads currently being managed by the Linux kernel. The types of system summary information shown by Linux top command and the order […]

Nginx tuning tips: TLS/SSL HTTPS – Improved TTFB/latency

As of 30th June 2018, the PCI Security Standards Council requires that support for SSL 3.0 and TLS 1.0 be disabled. TLS 1.1 or higher must be used and TLS 1.2 is strongly recommended. In addition, starting this July, Google Chrome will begin to mark HTTP web sites as “not secure”. Over the past few years, […]

Free Linux Server Monitoring and APM solutions for SysAdmins

Today’s software applications require developers, testers, and SysAdmins to work together (DevOps) more seamlessly than ever before. A single line of code or poorly configured service can negatively impact your application’s performance, causing crippling slowdowns for end-users. This is where application performance monitoring (APM), comes in. APM is also referred to as application performance measurement or application performance management. […]

How to upgrade to PHP 7 on RHEL/CentOS

TL;DR = Upgrade to PHP 7 using Remi’s RPM repository – PHP Configuration wizard. Red Hat Enterprise Linux (RHEL) is a Linux distribution developed by Red Hat targeted toward the commercial market. Red Hat uses strict trademark rules to restrict free re-distribution of its officially supported versions, but still freely provides its source code. Third-party derivatives […]

htop and top Alternatives: Glances, nmon

Previously we took a look at top, atop and indirectly (due to it’s popularity as top’s alternative) htop (the last screenshot on this page). But are there other alternatives worth looking at? As it pertains to system health and performance, this is largely a matter of preference regarding what data is most important to you. We […]

Logagent: The Swiss Army Knife for Log Processing?

Guest post by Stefan Thies DevOps Evangelist at Sematext Group Inc. Dealing with log files or extracting data from various data sources is a daily task in the IT administration. Users ask about statistics or details of their technical or business operations. The relevant data is often present in log files, databases or message queues. Converting […]

Increase Performance and lifespan of SSDs & SD Cards

SSDs (solid-state drives) and SD (Secure Digital) cards have a limited number of writes before they wear out. To get the most out of this storage type lets investigate, then make a few adjustments to maximize the life of your SSDs and SD cards. Article refreshed from 3 years ago.   Using iotop to monitor and minimize […]

80% of the web powered by PHP

Today, PHP is used by more than 80% of all the websites whose server-side programming language we know. Popular websites such as Slack, Etsy, Cloudflare, Tesla, Wikipedia, WordPress.com, Tumblr and this website are all powered by PHP. With such a large share of the web, it may or may not surprise you that more than 90% 88% […]