How to remove warning when installing Сaсti: sort_buffer_size 2 M <= -52.61 M

[usernews]

Please tell me what needs to be fixed here so that there is no warning when installing cacti:

10.6.11-MariaDB-0ubuntu0.22.04.1
4Gb - RAM, Dual Core E-7400
up to 100 devices
default polling time

sort_buffer_size 2 M <= -52.61 M When performing joins, if they are below this size, they will be kept in memory and never written to a temporary file. As this is a per connection memory allocation, care must be taken not to increase it too high. The sum of the join_buffer_size + sort_buffer_size + read_buffer_size + read_rnd_buffer_size + thread_stack + binlog_cache_size + Core MySQL/MariaDB memory should be below 80%. If the recommendation is negative, you must decrease this and or the sort_buffer_size until the recommendation fits within the allowable memory.

max_heap_table_size = 128M
tmp_table_size = 64M
join_buffer_size = 64M
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_buffer_pool_size = 1024M
innodb_doublewrite = OFF
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_io_capacity = 5000
innodb_io_capacity_max = 10000

[usernews]

Сhanged these two values and the warning disappeared

join_buffer_size 10 M <= 10.39 M
sort_buffer_size 1 M <= 1.39

[TheWitness]

Yea, you just have to find the happy median. You can run with values larger than that, you only risk swapping disk. If all you are doing is plain old Cacti on the server with plugins that don't generate a lot of data like syslog, flowview, and mactrack, you will never really tax your MySQL/MariaDB database too much. So, you should be safe.