Search results: mysql

100 Server and Application Performance Monitoring Tools 2019

Last Updated: Jan 15th 2019 November 29th 2018 – Site24x7 replaces Coscale. Coscale was recently acquired by New Relic.  Oct 11th 2018 update: 100+ – Fixed 11 broken links. (including defunct, mergers, acquisitions, or changed links) December 1st 2017 update: 70 100 Top Server Monitoring & Application Performance Monitoring Tools. August 6th 2017 update: 50 70 Top Server Monitoring & Application Performance Monitoring […]

Could not increase number of max_open_files to more than… (Solution)

A quick solution to the warning “Could not increase number of max_open_files to more than” when starting MySQL or MariaDB. For some background read How MySQL Opens and Closes Tables. Here’s an excerpt: “The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. If you increase one or both of these […]

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

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

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

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

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

Generating Secure Passwords for your Linux Server

Very often sysadmins will have to setup new servers or harden existing server passwords during security audits. As a result, secure passwords have to be chosen for root, cPanel accounts, ftp, etc. There are many composite practices that make a server secure, but often overlooked is using secure passwords. Notice that SSH or MySQL root […]