Can’t open PID file /run/zabbix/ (yet?) after start: No such file or directory

Once, on Ubuntu 18.04.6 LTS, I updated the Zabbix server to version 6.0 LTS and the new version did not start.

Continue reading “Can’t open PID file /run/zabbix/ (yet?) after start: No such file or directory”

Migrating MySQL Directory

Once I created a raid, mounted it as a disk system partition and transferred the MySQL directory directly to it, but in this case there were drawbacks, the lost+found directory could appear, it could not be used for other data, etc., after that I began to transfer the MySQL directory not directly to the partition, but created a directory on it and transferred it to it.

Continue reading “Migrating MySQL Directory”

How to change innodb_io_capacity in MySQL

innodb_io_capacity – determines the number of write IOPS for background InnoDB tasks, such as flushing pages from a buffer pool, etc. If the cleanup operation is lagging, then InnoDB can perform cleanup more aggressively at a higher IOPS, which is defined in the innodb_io_capacity_max variable.

Continue reading “How to change innodb_io_capacity in MySQL”