Apparently, the high usage of the mdl_files table is to do with a pdf conversation plugin in moodle.
May not apply to everyone.
Hardware and performance
MySQL Performance for Moodle
This discussion has been locked so you can no longer reply to it.