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”

Monitoring PPS (Packets Per Second) in Zabbix

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:

Continue reading “Monitoring PPS (Packets Per Second) in Zabbix”