We know that using Linux swap space instead of RAM (memory) can severely slow down performance. So, one might ask, since I have more than enough memory available, wouldn’t it be better to delete swap space? The answer is: No. There are performance benefits when swap space is enabled, even when you have more than […]
“MySQL server has gone away” error – Solution(s)
The MySQL server has gone away error, which means that the MySQL server (mysqld) timed out and closed the connection. By default, MySQL will close connections after eight hours (28800 seconds) if nothing happens. However, in some cases, your web host, DBA, or app developer may have decreased this timeout setting, as discussed below. MySQL […]
Fix Error: Failed to download metadata for repo ‘appstream’ – CentOS 8
As we all know, CentOS 8 reached its End of Life (EOL) on December 31, 2021, and CentOS Linux 7 will reach its end of life (EOL) on June 30, 2024, marking a significant shift in the CentOS ecosystem. This transition to CentOS Stream leaves system administrators and users with some important decisions to make. […]
innodb_buffer_pool_size – MySQL Performance
In MySQL performance tuning, few variables wield as much influence as innodb_buffer_pool_size. This essential MySQL configuration parameter directly impacts the performance of InnoDB, the most commonly used storage engine in MySQL. In this second installment in our series on MySQL database performance optimization, we continue to delve into the intricate world of MySQL configuration variables by […]
MySQL Performance Schema
When it comes to database performance monitoring and optimization, MySQL offers a powerful tool called Performance Schema. This versatile instrument provides invaluable insights into the inner workings of your MySQL database, enabling you to fine-tune its performance for optimal efficiency. In this installment of our series on MySQL database performance optimization, we delve into the […]
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 […]
Linux benchmark scripts and tools
This list of Linux benchmark scripts and tools should prove helpful for quick performance checks of CPU, storage, memory, and network on Linux servers and VPS. Check each script before running from the command line. Most of these scripts will benchmark the CPU, memory, storage, and network. In most cases, the CPU Model, frequency, and […]
Your Web Host Doesn’t Want You To Read This: Benchmark Your VPS
Aug 13th, 2023: added Yet-another-bench-script benchmarking tool. Sept 27th, 2021: Added link to a great list of command-line benckmark scripts. June 17th, 2019: Added instructions for network speed test using speedtest-cli script. Nov 2nd, 2016: Included quick dd commands to check cached vs. uncached read performance. This article will highlight using the ‘dd’ Unix command […]
NGINX Reverse Proxy Metrics to Monitor
NGINX is one of the most popular web servers nowadays, especially for Linux web servers. According to nginx.com, it powers more than 400 million websites. It is, however, probably even more commonly used as a reverse proxy. Since it acts as a go-between for your application and your users, it’s important to properly monitor NGINX […]
Memcache PHP Extensions for Memcached Caching Daemon
Memcached (Memcache Daemon) is a caching daemon designed especially for dynamic web applications to decrease database load by storing objects in memory. It is commonly used to speed up dynamic database-driven websites by caching data and objects in server memory to reduce the number of times the data source must be read. Memcached is free […]