Tuning MySQL: my.cnf, avoid this common pitfall!

Caution: Don’t overwrite my.cnf all at once. Backup data and config, make one or two changes per restart, test extensively. It took me some time to decide the title for this article. MariaDB has been fast replacing MySQL as a growing number of Linux distributions now default to MariaDB over MySQL. MariaDB is an enhanced drop-in replacement […]

Analyze Your Website’s TTFB (Time to First Byte)

Have you improved load time of your websites and web applications recently? Or, maybe your web store or other web app is now slower to respond as you’ve added more features or due to data growth? The time it takes for your web applications to respond when users visit, is more important than ever before! […]

20 Top Server Monitoring & Application Performance Monitoring Solutions

UPDATE: 50 Top Server Monitoring & Application Performance Monitoring (APM) Solutions Last Updated: Nov 23th 2018 – Fixed broken links. (including defunct, mergers, acquisitions, or changed links) Back in September I wrote about an article than touched on the subject of server performance monitoring.  Then just last month a LinkedIn connection asked: “I am using New Relic to monitor […]

Measure Linux web server memory usage correctly

Important update: This article was originally posted back in 2014. However, as I later posted in 2017 in the blog post Does your Linux server need a RAM upgrade? Lets check with free, top, vmstat and sar …there was a Linux kernel change to address this in 2016. Hopefully, this change will motivate New Relic and others to follow […]

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