hi,
I assume the default recommendations for buffers sizes in my.cnf need some research?
I’m not sure where to start. How are you guys managing these?
I’m using Matomo 5.1.2 on MySQL Community Server 8.4.3 LTS version. The MySQL is installed on Rocky Linux 9.4
This is what I have in my.cnf file. They are commented out by default.
Thank you
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M