The llnks were found as an illustration about tweaking DB's. Yes, I was aware of the first video's issue in viewing and an example of any videos shared by any author.
"like what I heard" ... as long as one is aware of date the videos were made and the versions of MySQL they covered, ***some*** of the information ***might*** be useful.
Would I blindly just copy and paste a setting into a my.cnf file to 'see what happens' ... ***ONLY ON A TINKER BOX*** ... but most of the time what is seen/heard/read is researched further using 'official' MySQL docs for the version of MySQL the server is riunning.
Take the mysqldump command (***note versions***):
If one just clicks the above links in order, one will see there are changes to the docs between versions.
Note: 8.0. Am I suggesting one should be running 8.0 .... NO!
As of recent, it has been discovered that MariaDB highest 10.x version is no longer a drop in replacement for MySQL and does require some fixes in Moodle code to be used.
I'll say it again ... one size does not fit all ... each server is different ... while one can give hints/suggestions about DB tweaking, it's still up to the OP to run whatever on their own DB server to see what *might* be tweaked or could be tweaked.
When you make your videos of 'Rick's Way', keep in mind, they probably should be revisited often as you might be sending 'trusting' Moodlers down a rabbit hole.
That's one of the reasons I hate to document ... in short time frame, the info shared/documented could be out of date and require changes/notes/catch 22's listed, etc., etc..
However, you are free to do as you wish. ;)
'spirit of sharing', Ken