Monitoring Combined Network Interface Channels in Zabbix

I decided to add to Zabbix a check of the number of Combined channels of network interfaces, since when loading the server there could be different situations when my scripts changing their number were not always executed or were executed, but the value was reset during the system startup.

Continue reading “Monitoring Combined Network Interface Channels in Zabbix”

Distribution of network card interrupts across processor cores

I will give an example of the distribution of interrupt network interfaces on the processor cores.
For example, I’ll take a server with accel-ppp, 6Gb/s traffic, 500K + pps, nat with ipoe and 6000 dchp clients.
Also, be sure to disable hyper-threading in the BIOS, since load balancing on virtual cores can greatly increase the load on some physical cores.

Continue reading “Distribution of network card interrupts across processor cores”

How to change join_buffer_size in MySQL

I will give an example of changing join_buffer_size in MySQL.
join_buffer_size determines the size of the buffer for index scanning and joins without indexes. I recommend adding indexes or slightly increasing join_buffer_size (but in this case a full table scan will be performed).

Continue reading “How to change join_buffer_size in MySQL”