Does anyone understand MySQL row formatting enough to makes some recommendations for best performance?
There are about 401 tables, and the vast majority mostly contain 10-40 fields comprising of varchar, longtext, datetime, timestamp, int, and tinyint fields. The exception is about 3 or 4 tables that also contain BLOB data fields holding document file types. .doc, docx, .pdf. .xlsx, etc. The data being entered is consistent with what would be otherwise entered on a business form for a quality management system, or in a material management database. Most of the databases are version 5.7, although we are in the process of upgrading everyone to MySQL 8.0
Is there a default row format I should be using that is likely to give me the best performance? And what circumstances might make an exception to that default setting?