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
We know why you are here! Your good old "workplace" icon is nowhere to be found and you are in panic mode. You need that icon back in its place right now. Don't worry, because you can get it back on your desktop in no time. While Windows 10 has introduced many useful features for ... 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
Some of the PowerShell commands require a password. You can embed a password directly in PowerShell commands. However, it is unwise to do it this way. It can be read by normal users and can be compromised. The best option is to store the password as an encrypted string in a text file. Even if ... Read more
This short guide will show you how to start multiple services simultaneously with the help of PowerShell. Start Multiple Services or Applications with PowerShell 1. Open PowerShell with administrative privileges. 2. Execute the following command (Suppose when you are required to search all exchange related services and start them, just replace the parameter). Get-Service "*Exchange*" ... 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
It's easy to lose track of which files and folders you've set to be shared in Windows with other users since you don't always want them to be shared with everyone. Shared Folders List in Windows Good thing there's a list of all the shared files hidden on your system - to get there, search ... Read more