Reduce CPU and Disk load of backup scripts with nice and ionice

Reduce CPU and Disk Load on Linux

Running a nightly backup script on a server system, such as a web hosting server, can result in a heavy load and longer latency for other processes, for example, HTML or .php pages load slowly during the backup because the backup script requires too many I/O or CPU resources. On Linux systems, two shell utilities ... Read more

How to convert RPM software packages to Debian (.deb)

Maybe you have had this problem: you are using Debian or Ubuntu Linux and a software package you would like to install is only available in RPM format. The solution is the handy tool called alien, which converts .rpm files to .deb files. Install alien: apt-get install alien Converting an rpm package to Debian format: ... Read more

Check and Repair All MySQL Databases on Ubuntu

MySQL Optimize and Repair

The following command can be used to check and repair all MySQL databases on a Ubuntu or Debian Linux System. I've tested the commands on Ubuntu 20.04 and Debian 10. Repair MySQL databases on Ubuntu Linux sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases MySQL database repair on Debian mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases The benefit of ... Read more

How to find ID of the display connected to your Linux system

Linux connected Display ID

Mostly, we have only a single display connected to computer systems. However, you can have multiple displays connected to a system. While working with more than one display, sometimes you might find yourself in a situation where-in you need to perform a display-specific task. For example, taking a screenshot. In these scenarios, you need to ... Read more

How to enable port 587 (submission) in postfix

Postfix Port 587

Some internet access providers have port 25 disabled in their routers to prevent spam. If you run your own email server in a data center, you might have to enable the submission port (587) in postfix to be able to send emails from your local email client to your own mail server. Enable Submission Port ... Read more

Optimize MySQL Performance with Mysqltuner

MySQL Optimization

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

How to add PHP support for jailed SSH users in ISPConfig 3

ISPConfig PHP Jail

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