I will give an example of changing join_buffer_size in MySQL.
Continue reading “How to change 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).
Enabling slow_query_log and log_queries_not_using_indexes will help to identify slow queries and queries without indexes that affect the performance of the MySQL server.
Continue reading “How to enable Slow Query Log in MySQL”
In this article I will give an example of optimizing the parameters of nf_conntrack for a high-loaded NAT server.
Continue reading “Tuning nf_conntrack”
DiskSpd is a utility for generating a load on a disk system and measuring its performance.
Continue reading “DiskSpd. Windows IOPS Test”
InnoDB log file size – the size of the transaction log files that are needed to cancel transactions and restore the database in case of failure.
Continue reading “Changing InnoDB log file size in MySQL”
In this article, I will describe the Cisco Catalyst 6500 online diagnostic commands.
Continue reading “Online diagnostics Cisco Catalyst 6500”
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: