InnoDB log file size – the size of the transaction log files that are needed to cancel transactions and restore the database in case of failure.Continue reading “Changing InnoDB log file size in MySQL”
In this article, I will describe the Cisco Catalyst 6500 online diagnostic commands.Continue reading “Online diagnostics Cisco Catalyst 6500”
I will give an example of resizing the InnoDB buffer pool in MySQL.
In the InnoDB buffer pool, this is the memory space in which indexes, caches, buffers, etc. are stored.
I will give an example of monitoring PPS (Packets Per Second) on network interfaces in Linux.
In order to calculate the number of transmitted packets per second on the network interface, create two simple scripts, the first to calculate the transmitted packets:
dhcdrop is a utility for suppressing unnecessary DHCP servers and stress testing.Continue reading “Suppression of DHCP servers (dhcdrop)”
I will give an example of a simple caching of PHP pages with an interval of 600 seconds (10 minutes).
Paste at the beginning of the code:Continue reading “Simple page caching”
One day after restarting the Ubuntu server, due to the long start of a large number of network interfaces, my script which increased the values of the buffers and also performed other settings was performed ahead of time, respectively, the changes did not apply and I found out about this problem only after 24 hours, so I decided monitor current RX and TX buffers.Continue reading “Monitoring current RX and TX network interface buffers in Zabbix”
I will give an example of viewing and increasing the open_files_limit parameter in MySQL.
Will perform operations in the Ubuntu Server 16.04.
Once on one high-load access server with about 5 Gb/s traffic in /var/log/syslog, errors began to appear frequently:Continue reading “Solution «TX driver issue detected, PF reset issued»”
innotop is a utility for monitoring the status of MySQL server.
I will give an example of installing innotop in Ubuntu. Since innotop is present in mysql-client, we install it and the necessary components:Continue reading “Installing and using innotop”