I will give an example of resizing the InnoDB buffer pool in MySQL.
Continue reading “Configuring InnoDB Buffer Pool size 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.
Continue reading “Monitoring PPS (Packets Per Second) in Zabbix”
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.
Continue reading “How to change open_files_limit 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”
The script every second displays the number of incoming and outgoing packets per second on the specified network interface.
Continue reading “PPS Viewer Script (Packets Per Second)”
Place the contents of the script into a file, for example, pps.sh and execute by specifying the name of the network interface (you can stop the execution of the script with CTRL+C):
Through “Scaling Governor”, you can choose the optimal CPU frequency control scheme, which affects power consumption and performance.
On highly loaded access servers, acquaintances had cases of server hangup during “ondemand”, although I did not have such cases, but still I recommend changing it to “performance”.
Continue reading “Changing CPU Scaling Governor on Linux”
On laptops and lightly loaded servers, you can leave “ondemand” to save energy.