Search results: mysql

htop: Quick Guide & Customization

htop is an interactive system monitor, but also a process-viewer, process-manager, strace tool and more. Sysadmins may opt to use htop when Unix top does not provide enough information about system processes. htop uses a cursor-controlled interface for sending signals to processes. One example where this comes in handy is: you don’t have to type […]

Linux Commands frequently used by Linux Sysadmins – Part 3

Last week and the week before, I published part 1 and part 2 of this five-part series entitled: Linux Commands frequently used by Linux Sysadmins. Those two articles took us a bit deeper into what I believe are around 50 to 100 commands often used by Linux Sysadmins and power users. Also, see Part 4 and Part 5. […]

PHP memory_limit – understanding and increasing this setting

PHP memory_limit is per-script, just as a highway’s speed limit is per-vehicle. For example, although PHP’s memory limit may be set high to 1GB, that does not mean that scripts will pile up to use that 1GB. Let’s take a quick look at understanding PHP’s memory_limit setting.   PHP memory_limit is a per-script setting PHP.net’s […]

Generating Secure Passwords for your Linux Server

Sysadmins will often have to set up new servers or harden existing server passwords during security audits. As a result, secure passwords have to be chosen for SFTP, admin panels, etc. Many practices make a server secure, but often neglected is using secure passwords. Notice that I didn’t include SSH or MySQL root passwords above. […]

Linux server performance: Is disk I/O slowing your application?

If your Linux server is bogged down, your first step may often be to use the top command in the terminal to check load averages. However, there are times when top shows very high load averages even with low CPU ‘us’ (user) and high CPU ‘id’ (idle) percentages. This is the case in the video […]

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, let’s investigate, then make a few adjustments to maximize the life of your SSDs and SD cards. Article refreshed from 6 years ago.   Using iotop to monitor and […]

100 Top Server Monitoring, APM and Observability Tools

Looking for application monitoring and observability solutions? On this page, I’ve listed the top application performance monitoring (APM), infrastructure monitoring, and observability solutions to date. The listings are updated periodically as APM and observability solutions continue a rapid evolution. While I haven’t tested all of these solutions, I’ve used more than a third of them. […]

PHP 8 Compatibility Check and Performance Tips.

PHP 7 was first released back on 03 Dec 2015. Yes, I’m sure, it’s been around a while! The PHP team encouraged upgrading to PHP 7, hailing its improvements such as being twice as fast, consistent 64-bit support, removal of old and unsupported SAPIs and extensions, improved fatal error resistance, to name a few. A […]

PHP Performance: Additional CPU cores vs Faster CPU cores

Some time ago, I received an email from a client experiencing slow performance issues with a LEMP (Linux, Nginx, MySQL, and PHP webserver). During a full audit, I found that the server’s load average was pretty low (see above screenshot). However, the website was indeed very slow. There were some misconfigurations, but one of the […]

Linux top: Here’s how to customize it

The top command – referred to below as Linux top – is a command on Unix and Unix-like systems such as Linux, which provides a dynamic real-time overview of a running system. It can display system summary information and a list of processes or threads currently being managed by the Linux kernel. The types of […]