Author Archives: Vyacheslav

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”

File Integrity Check Script

Once on one server it was necessary to monitor the integrity of the file in which the changes were made, and if someone performed a system update, then this file could change and corrections had to be made again.
Usually I use a Zabbix agent and a Zabbix server for such purposes, but this server was single and it makes no sense to install a Zabbix server on it, so I wrote a simple script:

Continue reading “File Integrity Check Script”