Editing my.cnf is a correct thing to do, but it's tricky. And it depends upon the version of MySQL or MariaDB that you have.
However, tweaking my.cnf can help improve the performance of your Moodle, so it is worth exploring.
There is some guidance in the Moodle docs. I suggest that when you try a change, do it one line at a time.
I am going to attach a copy of my.cnf for you to see. Don't take my my.cnf and copy it to yours! Read what I am doing, read other resources for your db, see if you might agree with my setting, try it, and see if it improves. But be very careful as you learn and progress. Have a backup of your moodle, just in case. I have tried to document my my.cnf to help.
However, tweaking my.cnf can help improve the performance of your Moodle, so it is worth exploring.
There is some guidance in the Moodle docs. I suggest that when you try a change, do it one line at a time.
I am going to attach a copy of my.cnf for you to see. Don't take my my.cnf and copy it to yours! Read what I am doing, read other resources for your db, see if you might agree with my setting, try it, and see if it improves. But be very careful as you learn and progress. Have a backup of your moodle, just in case. I have tried to document my my.cnf to help.