This short tutorial describes the steps to optimize the performance of a MySQL database with the mysqltuner script. This tool can be used for MySQL and MariaDB. Install mysqltuner The mysqltuner High-Performance MySQL Tuning Script is available as a package on Debian 10 and Ubuntu 20.04, install it with at: sudo apt install mysqltuner For ... Read more
Sometimes you might want to block connects to your server by IP address. E.g. when someone tries to attack your system. This can be done in several different ways, e.g. with iptables (firewall) rules or by setting up a reject route. Reject access with Linux route command Using iptables sometimes causes conflicts with installed firewalls ... Read more
When working on the command line in Linux, you may want to know how much time a particular command has taken (from start to finish). If you are new to Linux and looking for a way to do this, you will be pleased to learn that there is a command-line tool that does exactly what ... Read more
This short guide shows you how to get a list of all installed Packages on Debian Linux. Packages on Debian get installed with the apt package installer. We will use the dpkg command, which is part of the apt toolset, to query the installed packages database. Get all installed Debian packages dpkg --get-selections As you ... Read more
Sometimes it is necessary to limit the download rate of the wget command, e.g. when you are downloading a large file over a slow internet connection. Wget Command Download Limit The parameter to apply a download speed limit is the --limit-rate option. This setting is followed by the rate limit plus "k" for Kbit or ... Read more
Jailkit is an easy-to-use tool to create and maintain jail environments for shell users on Linux. In this guide, I will show you how to move PHP and its dependencies into the jail so that the jailed user can execute PHP scripts inside the jail on an ISPConfig server. Edit the jailkit .ini file and ... Read more
The Linux TigerVNC Server provides a command to set a new password. Set VNC Password The command is "vncpasswd", the password is stored in encrypted form into the file ~/.vnc/passwd of the home directory of the user. Run: vncpasswd to set a new password for the currently logged-in user. The command will then prompt for the ... Read more
This guide shows you how to kill an unresponsive OpenVZ container in case the normal stop procedure fails. Killing the container will not delete any files or remove the container, it just kills all processes so that you can start or restart the container again when it gets stuck. I will use container ID 101 ... Read more
It is important to keep your Linux server up to date with security updates. Linux distributions like Ubuntu and Debian release updates on a daily basis, so keeping the system up-to-date can become a tedious task. Fortunately, there is an option to install security updates automatically. Here are the steps to enable automatic security updates ... Read more
Sometimes, you might want to apply a chmod to files only and not directories. This guide shows you three different ways to achieve that goal on the Linux command line. How to chmod files only One of the easiest ways is to use the find command to select the files and then run the chmod command with ... Read more