uptime command in Linux

This uptime command guide is a follow-up to my previous 90 Linux Commands frequently used by Linux Sysadmins article. As time allows, I will continue to publish articles on these 90 commands geared toward Linux sysadmins and power users. Let’s continue this series with the uptime command. The uptime outputs the current time, system uptime, number of logged-in […]

btop – the htop alternative

Meet btop, an aesthetically pleasing system resource monitor showing usage and stats for processor, memory, disks, network, and processes. btop is the lighter and faster C++ version and continuation of bashtop and bpytop. Over the years, the available options for command-line system monitoring tools have grown quite a bit. There is top, htop, glances, nmon, ytop, gtop, vtop, and […]

MySQL Database Performance: Avoid this common mistake

One frequent topic of support request emails I receive is MySQL database performance. Clients complain about MySQL using too much server memory, too many MySQL slow queries, the famous Mysql server has gone away error and many other MySQL performance-related issues. As such, I wanted to share the solution to a common MySQL configuration mistake. […]

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