How to compute (or imagine) the good buffersize for the logstore_database

How to compute (or imagine) the good buffersize for the logstore_database

by Dominique Palumbo -
Number of replies: 0
Picture of Particularly helpful Moodlers Picture of Plugin developers

Hi,


we've a logstore store in an external database we keep it one year for +/- 40.000 students.

I've remarked the parameter : logstore_database | buffersize

By default is 50 and it said it's to increase performance.


I would like to change it to have even a better performance. But I'm afraid to make it worse than better.

We've peaked at 20 actions per sec but the average is more 5. It's the buffer at 50 is good enough or increase it is suitable ?

If someone has advice or experience about this parameter, I'll be happy to read it.

Thanks in advance.

Dominique.




Average of ratings: -