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:
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:
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:
Through “Scaling Governor”, you can choose the optimal CPU frequency control scheme, which affects power consumption and performance.
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. […]
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: If Ubuntu version is 18.04 and newer, then NetData is installed with the command: After installation, the configuration will be in /etc/netdata/, the logs […]
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: In CentOS as follows:
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 […]
Iperf — cross-platform console client-server program – a TCP and UDP traffic generator for testing network bandwidth. The installation command in Ubuntu: To display help in the console, type: Let’s see what version was installed: To test network bandwidth, the following commands are executed: On server: On the client: On the client from Windows, you […]