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”Tag Archives: Performance
How to change open_files_limit in MySQL
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.
Solution «TX driver issue detected, PF reset issued»
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»”Installing and using innotop
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”PPS Viewer Script (Packets Per Second)
The script every second displays the number of incoming and outgoing packets per second on the specified network interface.
Place the contents of the script into a file, for example, pps.sh and execute by specifying the name of the network interface:
Changing CPU Scaling Governor on Linux
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”.
On laptops and lightly loaded servers, you can leave “ondemand” to save energy.
BGP. Channel Balancing on Quagga
I will give an example of balancing only incoming traffic with two channels using Quagga.
On the test, I will use Ubuntu 16.04.4 LTS and Quagga 0.99.24.1, the network interface ens1f0 for the second provider with one neighbors and ens2f0 for the first provider with two neighbors, the local network will be connected to ens2f1. Both providers announce “default”.
3.3.3.0/23 this will be my network with white IP addresses.
Continue reading “BGP. Channel Balancing on Quagga”
NetData installation
NetData – monitoring system that displays real-time statistics on web panels.
On the test, I will install NetData on Ubuntu 18.04 and Ubuntu 16.04.
Before installing, you can upgrade the system:
sudo apt-get update sudo apt-get upgrade
If Ubuntu version is 18.04 and newer, then NetData is installed with the command:
sudo apt-get install netdata
After installation, the configuration will be in /etc/netdata/, the logs in /var/log/netdata/.
On Ubuntu 16.04 and older, you can install as follows (the installation will be done in /opt/netdata/):
sudo bash <(curl -Ss https://my-netdata.io/kickstart-static64.sh)
Restart NetData can command:
sudo systemctl restart netdata
View status:
sudo systemctl status netdata sudo ps ax | grep netdata
After installing NetData, you can immediately open it in the browser http://HOST:19999
I recommend to immediately restrict access to the tcp port 19999, for example through iptables.
Installing and using mysqltuner.pl
MySQLTuner – This is a Perl script that will give recommendations for improving the performance and stability of the MySQL server.
GitHub Page – https://github.com/major/MySQLTuner-perl
MySQLTuner in Ubuntu can be installed with the command:
sudo apt-get install mysqltuner
In CentOS as follows:
yum install mysqltuner
Install Apache JMeter in Ubuntu
Apache JMeter — load testing tool.
For Apache JMeter you need to install Java, see my article – Installing Java on Linux.
For an example I’ll install Apache JMeter in Ubuntu Desktop 18.04.
After Java is installed, copy the link to the archive with the latest version of Apache JMeter from the official site http://jmeter.apache.org/download_jmeter.cgi and download it:
wget http://apache.volia.net//jmeter/binaries/apache-jmeter-4.0.tgz
Extract the archive:
tar -xf apache-jmeter-4.0.tgz
Run:
cd apache-jmeter-4.0/bin/ ./jmeter
After the startup, a message was displayed that you can create tests in the Apache JMeter graphical mode, and you can execute them only from the terminal, for example:
jmeter -n -t [jmx file] -l [results file] -e -o [Path to web report folder]
By the way, Apache JMeter in Windows is run through the jmeter.bat file.