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

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